=SUMPRODUCT(--(ISNUMBER(FIND("2000",B18:B351))),--(C18:C351="No"))


"John Deakins" wrote:

I have two columns, one of which has "2000" among other text while the other
has "No." I need to count the number of times there is "No" in a row if it
also contains "2000." From reading previous posts, if appeared that the
following would work, but it doesn't. It just brings the calculation to 0.
What is the proper of way accomplishing this? Thanks.

=SUMPRODUCT((B18:B351="*2000*")*(C18:C351="No"))