How do I apply conditional formulas across multiple columns?

A

ansoriano1

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!
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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

ansoriano1

perfect - thank you

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
Top