sumif
 

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

sumif
 

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.

"BOONER" wrote:

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

sumif
 

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))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"BOONER" wrote in message
...
I know this is probably elementary, but how do you do a sumif if you have
multiple criteria that needs to be met?

sumif
 

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.

"BOONER" wrote:

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

sumif
 

Correction - not Vlookup but Sumif on the new column.


"JMB" wrote:

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.

"BOONER" wrote:

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