how do i set up a complicated IF formula
 

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?

how do i set up a complicated IF formula
 

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?

how do i set up a complicated IF formula
 

Try this:

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

Adjust the ranges to suit your data.

Hope this helps.

Pete

On Sep 24, 11:43*am, 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?

how do i set up a complicated IF formula
 

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?

how do i set up a complicated IF formula
 

Brilliant, thanks Mike

"Mike H" wrote:

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?