SUMIF Function
 

Any idea how you can enter three arguments into the SUMIF function?

Many thanks

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
.

=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