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"))
 
Back
Top