How do I count the number of time 2 columns meet my criteria

  • Thread starter Thread starter Mrswhit9
  • Start date Start date
M

Mrswhit9

Can anyone tell me what is wrong with this formula? I am trying to say if
the text in column B = this, and the text from column C = this, and then
count the returned values:

=IF(b4:b118,"Consistent Support Staff",IF(C4:C118,"Positive"),"1","0"))
 

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

Count unique with criteria 3
Counting text which meets a criteria 2
Count unique records that also meet criteria 3
COUNT 1
COUNT and SUM with multiple criteria 2
Count matching text in two columns 9
count number of duplicates between 2 columns 8
And then there were ZEROs... 7

Back
Top