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.