sumproduct() is often used for multiple arguements

=sumproduct(--(range1 = argument 1),(range2 = argument2),range3)
will add up the values in range 3 when arguments 1 and 2 are met
the --( changes the logical true/false to a numeric 1/0
and the arrays in each seciton must be the same size but cannot be the full
row/column shorthand (A:A wont work)

"Paul Chalmers" wrote:

I use SUMIF all the time where I check one arguement. How do I write the
formula to check for two arguments? Have checked documentation but am going
in circles - would appreciate any pointers.

Thanks