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 |