How do I ask for multiple criteria when creating a "sumif" formul.


G

Guest

I need to create a "sumif" formula in excel that allows me to dictate
MULTIPLE criteria...for example, in range a1:c10, I want to sum cell c3 only
if a1="value" and b1="value", and so on down the line...ideally, I would
creat a formula that looks like this:

=sumif(a1:c10,a1:a10="value1"AND b1:b10="value2",c1:c10)

I've tried layer "if" and "and" formulas in the sumif formula; nothing seems
to work.

HELP!
 
Ad

Advertisements

D

Dave R.

You can use sumproduct for that:

=SUMPRODUCT((A1:A4="red")*(B1:B4="car"),C1:C4)

this will sum C1:C4 when A1:A4="red" and B1:B4="car".
 
G

Guest

I'm not sure I understand the wording of your question, but it sounds like
SUMPRODUCT could help you:
=SUMPRODUCT(--(A1:A10="Required Text"),--(B1:B10=RequiredNumber),(C1:C10))

This formula should add the values in Column C only if the text in the same
row in column A matches the RequiredText in the formula and the value in the
same row for column B matches the RequiredNumber.
Note that text goes in quotes, numbers do not.

For more, check out:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html


tj
 
Ad

Advertisements


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