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

--
HTH

Bob Phillips

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

"ansoriano1" wrote in message
...
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!