countif

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
 
R

Roger Govier

Hi Kevin

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

Biff

Hi Kevin,

Try this:

=COUNTIF(H2:H104,"staying")+COUNTIF(I2:I104,"hostfamily")

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Countif Function - Calculating Between Two Sets of Values 3
Countif with a Range of criteria 8
countif using other cell values for 'range' and 'criteria' 4
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
COUNTIFS with a date for criteria... 1
using =COUNTIF() in a variable range on a different worksheet? 4
non-numeric in a calculation 1
Countif Limitations 5

Top