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

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

try
=sumproduct((b4:b118="Consistent Support Staff")*(c4:C118="Positive"))


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mrswhit9" wrote in message
...

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

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

=SUMPRODUCT((B4:B118="Consistent Support Staff")*(C4:C118="Positive"))

--
Gary''s Student - gsnu200909


"Mrswhit9" wrote:


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