countif

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I'm using the countif function but want to check a number
of variables, usually details in at least 2 separate
columns of cells. How should I list the range of cells in
the function bar?

Eg countif(H2:H104,"staying") + (I2:I104,"hostfamily").
I've tried using the simple addition sign but that does
not work.

KMB
 
Hi Kevin

You are almost there
=countif(H2:H104,"staying") +countif (I2:I104,"hostfamily")
 
Back
Top