Multiple SUMIF criteria

[jxbeeman]

How can I do a sumif function with multiple criteria?

For Example
I have 2 columns that i want to sort by criteria and 1 different column that
i want to sum.

Maybe something like this?????
=Sumif(range1,"criteria1",& , range2,"criteria2", "Sum_Range")

Thanks, Josh

 

[Mike H]

Sumproduct may be better suited

=SUMPRODUCT((A1:A19=1)*(B1:B19=2)*(C1:C19))

Mike