COUNTIF

P

Paul

I need a formula to count the # of rows where the contents
of Cell A2 are in column I and column E contains "S".
 
P

Peo Sjoblom

=SUMPRODUCT((I2:I100=A2)*(E2:E100="S"))

or

=SUMPRODUCT((I2:I100=A2)*(ISNUMBER(SEARCH("S",E2:E100))))

if can be part of a string. It is probably the first one you are looking
for
 
Top