Hi,

Try this. D7:D11 is the range and C14:C15 holds Normal and Healthy

=SUMPRODUCT(1*(ISNUMBER(MATCH(D7:D11,C14:C15,0))))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"PAL" wrote in message
...
Thanks.

Is there a way to tweak this to do the following:

Count all titles that had the words, "normal" AND/OR "healthy".

"Gary''s Student" wrote:

=COUNTIF(A1:A100,"*Extension*")

--
Gary''s Student - gsnu200857