Formula problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joyce - 07 May 2008 19:14 GMT

I am having problems coming up with a formula
Here is my scenario

If A2:A5 = Apples and B2:B5 = Oranges, then count the number of oranges in
Column B

Reply to this Message

Bob Phillips - 07 May 2008 19:17 GMT

=SUMPRODUCT(--(A2:A5="Apples"),--(B2:B5="Oranges"))

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I am having problems coming up with a formula
> Here is my scenario
>
> If A2:A5 = Apples and B2:B5 = Oranges, then count the number of oranges in
> Column B

Reply to this Message

Gaurav - 07 May 2008 19:22 GMT

There might be a better way but this one should also work.

=SUMPRODUCT(--(A1:A5="Apples"),--(B1:B5="Oranges")*(B1:B5="Oranges"))

>I am having problems coming up with a formula
> Here is my scenario
>
> If A2:A5 = Apples and B2:B5 = Oranges, then count the number of oranges in
> Column B

Reply to this Message