Thread: SUMIF Function
View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.