| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SumIF
Is there a way to use Sumif for several criterion in different columns?
|
|
#2
|
|||
|
|||
|
Yes if you extend the data area by concatenating relevant fields.
Otherwise, you'll need to switch to formulas that operate on arrays like those with SumProduct or with Sum. See an example I just posted at: http://www.mrexcel.com/board2/viewtopic.php?t=123021 that shows how to use SumIf with multiple conditions along with SumProduct. anuita wrote: Is there a way to use Sumif for several criterion in different columns? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF with two conditions ? | Excel Discussion (Misc queries) | |||
| Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
| Sum or Sumif | Excel Discussion (Misc queries) | |||
| sumif | Excel Discussion (Misc queries) | |||
Linear Mode
