| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF With Multiple Criteria
What would the form of the function be if I wanted to use the SUMIF funtion
but evaluate two criteria instead of one? I almost want to use the SUMIF and the AND function. |
|
#2
|
|||
|
|||
|
SUMIF With Multiple Criteria
One way is to use the Sumproduct function. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html Or give us more detail as to what you are trying to sum for specific examples. Regards Rowan Mike wrote: What would the form of the function be if I wanted to use the SUMIF funtion but evaluate two criteria instead of one? I almost want to use the SUMIF and the AND function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| Can I use multiple criteria in SUMIF funqtion? | Excel Worksheet Functions | |||
| SUMIF, multiple criteria | Excel Discussion (Misc queries) | |||
| How do I sum (like sumif) but predicated on multiple criteria, in. | Excel Worksheet Functions | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
Linear Mode
