Sum column using 2 other columns as criteria

  • Thread starter Thread starter Hall
  • Start date Start date
H

Hall

My table has 3 columns: A, B, and C. C has all numeric values.

I want to SUM values in C for all rows where value in A equals "a" and value
in B equals "b".

Can anyone tell me a formula construct for this?

Thanks!
 
=SUMPRODUCT((A1:A14="a")*(B1:B14="b")*(C1:C14))

Adjust the range as required

Regards

Trevor
 
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

Figuring out a lengthy formula. Probably quite simple... 3
CONDITIONAL SUM FOR MULTIPLE CRITERIA IN SINGLE RANGE 1
Counting unique values in multiple columns 4
In a sales quote sheet - sum totals by license type 1
Find largest value in column with 2 criteria 1
Pivot table calculated field Count(field) / sum(field) 0
Looking formula that SUM values with specific value in neighboring colum 2
Excel Formula Help 2

Back
Top