How do I apply conditional formulas across multiple columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=SUMPRODUCT(--(A1A6="Molly"),--(B1:B6="April"),--(C1:C6="Candy"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate days in a month 2
aconcat UDF throwing a #NAME error 10
Sum results from 2 columns that meet criteria 1
Sum on multiple columns with search criteria 6
Trickey SumProduct with Multiple Conditions 1
Get a percentage based on multiple conditions 4
How do I get a cell to give a result based on the month we are in? 3
IF/SUMIF function 2

Back
Top