P Paul Oct 10, 2003 #1 I need a formula to count the # of rows where the contents of Cell A2 are in column I and column E contains "S".
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 Oct 10, 2003 #2 =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
=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
