how do i set up a complicated IF formula

[Scott]

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?

 

[Mike H]

Hi,

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

Mike

 

[Pete_UK]

Try this:

=SUMPRODUCT(--(A1:A100="Recall"),--(B1:B100="yes"))

Adjust the ranges to suit your data.

Hope this helps.

Pete

 

[Mike H]

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

 

[Scott]

Brilliant, thanks Mike

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