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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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:B100>4),C1:C100)
the double negative converts False/True to 0/1
best wishes
 
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.
 
Back
Top