Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
SUMIF Function
Any idea how you can enter three arguments into the SUMIF function?
Many thanks |
#2
|
|||
|
|||
If you mean *criteria* when you say arguments, the best
you could do would be something like: =SUM(SUMIF(A:A,{"a","b","c"},B:B)) This would sum for all 3 conditions. But it's not very robust. Your best bet would be SUMPRODUCT: http://www.xldynamic.com/source/xld.SUMPRODUCT.html HTH Jason Atlanta, GA -----Original Message----- Any idea how you can enter three arguments into the SUMIF function? Many thanks . |
#3
|
|||
|
|||
=SUMPRODUCT(--(rng1="val1"),--(rng2="val2"),--(rng3="val3"),rng4)
will make 3 tests and add from rng4 where all 3 are met -- HTH RP (remove nothere from the email address if mailing direct) "Peter Curtis" wrote in message ... Any idea how you can enter three arguments into the SUMIF function? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Criteria | Excel Discussion (Misc queries) | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |