How do I apply conditional formulas across multiple columns?
perfect - thank you
"Bob Phillips" wrote:
=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!
|