How do I apply conditional formulas across multiple columns?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ansoriano1 - 25 Aug 2006 15:59 GMT

Say my data set looks like this:
A B C

Molly April Candy
Sally April Candy
Sally May Soda
Molly May Soda
Amy June Candy
Amy June Soda

How do I create a function that finds out How many Candy are associated with
Molly in April?

How many candy are associated with April?

Thanks!

Reply to this Message

Bob Phillips - 25 Aug 2006 16:10 GMT

=SUMPRODUCT(--(A1A6="Molly"),--(B1:B6="April"),--(C1:C6="Candy"))

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Say my data set looks like this:
> A B C
[quoted text clipped - 12 lines]
>
> Thanks!

Reply to this Message

ansoriano1 - 25 Aug 2006 16:49 GMT

perfect - thank you

> =SUMPRODUCT(--(A1A6="Molly"),--(B1:B6="April"),--(C1:C6="Candy"))
>
[quoted text clipped - 15 lines]
> >
> > Thanks!

Reply to this Message