How do I sum a range after 2 different conditions are met (2 colu.

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

Guest

I would like to sum a range if column A = x and column B = y then sum those
numbers in range C that meet the criteria. Is this possible? SumIf only
allows for one range and criteria, how can I get around this?
 
Try

=SUMPRODUCT(--(A2:A500="x"),--(B2:B500="y"),C2:C500)


Regards,

Peo Sjoblom
 
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

Conditional Sum - variable criteria 5
sumif with 2 variables 2
sum a range if two conditions are met 3
conditional formula question with multiple criteria 2
SUMIF - how to enter a second criteria 1
Conditional Sum date range 2
Sum with multiple conditions - sumproduct, dsum or dproduct? 3
Sum a range based on a column 2

Back
Top