Thread: How do I count the number of time 2 columns meet my criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mrswhit9 Mrswhit9 is offline
external usenet poster
  
Posts: 1
Default How do I count the number of time 2 columns meet my criteria

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

--
mrswhit
Reply With QuoteReply With Quote