| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
multiple criteria then sum
I am trying to figure out how to sum a column based on 2 criteria being true.
criteria1 criteria2 volume 3 2 100 2 2 500 2 1 600 3 2 200 For example, I want the sum for volume when criteria 1 = 3 and criteria 2 = 2 simultanously. In this example, volume would equal 300. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract multiple records matching criteria from list | Excel Worksheet Functions | |||
| Multiple Criteria (add or subtract) | Excel Discussion (Misc queries) | |||
| Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Threaded Mode
