ExcelBanter - Multiple SUMIF criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple SUMIF criteria (https://www.excelbanter.com/excel-worksheet-functions/176610-multiple-sumif-criteria.html)

jxbeeman

Multiple SUMIF criteria

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

Multiple SUMIF criteria

Sumproduct may be better suited

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

Mike

"jxbeeman" wrote:

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

All times are GMT +1. The time now is 02:25 AM.