Hmm,

After have bought E2007 I should get used to the new functionality so if you
have e2007 try

=COUNTIFS(A1:A20,"Recall",B1:B20,"Yes")

Mike

"Mike H" wrote:

Hi,

=SUMPRODUCT((A1:A20="Recall")*(B1:B20="Yes"))

Mike

"Scott" wrote:

I have a spreadsheet set up where column A has either Recall, Retail or VSR
in it, and column B has either Yes or No in it. I need to be able to count
how many Recalls have yes beside them.

Can anyone help?