COUNTIF with compound comparison
 

I would like to look in the range of c4:c216 for the occurrence of the
word "No" which appears as the first two characters as part of a longer
sentence in any of those cells in that range. Then, if "No" appears
and the word COM appears in cell D4, I would like the count to
increment by 1.
So I think I need to use the COUNTIF and LEFT function and then I'm
stuck with the compound statement, trying to do the other comparison
with cell D4.
Any suggestions are appreciated.

=sumproduct(--(d4:d216)="com"),--(left(d4:d216),2)="No")


"Thermometer" wrote in message
ups.com...
I would like to look in the range of c4:c216 for the occurrence of the
word "No" which appears as the first two characters as part of a longer
sentence in any of those cells in that range. Then, if "No" appears
and the word COM appears in cell D4, I would like the count to
increment by 1.
So I think I need to use the COUNTIF and LEFT function and then I'm
stuck with the compound statement, trying to do the other comparison
with cell D4.
Any suggestions are appreciated.