How do I use multiple criteria with sumif in Excel?

A

Aaron A

I have to check two columns to determine if I pull the sums from a third. So
I need a sumif formula that accepts two criteria. For example:

I need to get the sum of values in column C where column A=Account 1 and
column B=Cost Center 2 (answer in this case would be 2,000):

A B C
Account 1 Cost Center 1 1,000
Account 1 Cost Center 2 2,000
Account 1 Cost Center 3 3,000
Account 2 Cost Center 1 500
Account 2 Cost Center 2 250
Account 2 Cost Center 3 425

Any ideas on how to get Excel to accept both criteria?
 
B

bj

try sumproduct()
=sumproduct(--(rangeB="Cost Center 2),--(rangeA="Account 1"),RangeC)
the --(changes the logiccal true false to a numeric 1 0
the arrays in each secton must be the same size but cannot be the full
column shorthand. (A:A wont work)
 

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

Top