Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif
I know this is probably elementary, but how do you do a sumif if you have
multiple criteria that needs to be met? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Help with SUMIF function | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |