how do i set up a complicated IF formula

  • Thread starter Thread starter Scott
  • Start date Start date
S

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?
 
Try this:

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

Adjust the ranges to suit your data.

Hope this helps.

Pete
 
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
 
Brilliant, thanks Mike

Mike H said:
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
Click to expand...
 
Back
Top