Not sure if this is what you want or not:

=SUMPRODUCT((A1:A5000={"RC","NC","RS"})*(B1:B5000= "complete"))

This gives you the number of times the word "complete" appears in
column B and the letters RC, NC or RS appear in Col A on the same row.

Is that what you're looking for?


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=523676