How do I specify more than one argument for the SUMIF function?
 

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

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

You don't! You use SUMPRODUCT
Suppose you want to sum values in C column when cell in A cell value is
Apple and value in B cell is greater than 4.
=SUMPRODUCT(--(A1:A100="apple"),--(B1:B1004),C1:C100)
the double negative converts False/True to 0/1
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Paul Chalmers" <Paul wrote in message
...
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

conditional formatting
 

I just need to know how I can enter multiple arguments not for a range e.g.
..25 =".15" and .30=".50" and .45=".75" in one cell? thanks.