Any idea how you can enter three arguments into the SUMIF function? Many thanks
P Peter Curtis Jan 12, 2005 #1 Any idea how you can enter three arguments into the SUMIF function? Many thanks
J Jason Morin Jan 12, 2005 #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
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
B Bob Phillips Jan 12, 2005 #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)
=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)
