sumif

B

BOONER

I know this is probably elementary, but how do you do a sumif if you have
multiple criteria that needs to be met?
 
J

JMB

You don't. Look at sumproduct (link below) if you want to return a numerical
value (sum based on multiple conditions). There is also a link from this
site to Chip Pearson's site that discusses array formulas. If you want to
return text based on multiple conditions, try Index/Match in an array formula.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Alternatively, create a new column and concatenate the columns with the
criteria to create a unique key (like =B1&C1&D1), then use VLOOKUP on this
new column.
 
R

Ragdyer

Under normal circumstances you'd probably use another function, like
Sumproduct().

You could still use SumIf() in some scenarios, like:

=Sumif(A1:A100,">=50",B1:B100)-Sumif(A1:A100,">75",B1:B100)
To get totals on Column B where Column A values are between 50 and 75.

OR

Total Column B where Column A values are equal to 50 *or* 75:

=Sum(Sumif(A1:A100,{50,75},B1:B100))
 
A

Ananth

Please consider using the conditional sum wizard that will do the summing up
for multiple conditions. You will find this feature in the Tools Menu. If
you are not finding it, choose add-ins in tools menu and activate Conditional
Sum Wizard. The wizard will guide you thro the process of summing a range
against multiple conditions.
 
Top