ExcelBanter - Sumif (I think)

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Sumif (I think) (https://www.excelbanter.com/new-users-excel/261291-sumif-i-think.html)

Jarod

Sumif (I think)

How do I sum with more than one criteria
Example:

Product Line Period Revenue
Dewatering 1 $5,000
Dewatering 4 $4,000
Intake 2 $2,000
Dewatering 3 $1,000

How would I sum all "Dewatering" revenue for periods 1 thru 3?

RonaldoOneNil

Sumif (I think)

Assuming your data starts in A1

=SUMPRODUCT((A2:A5="Dewatering")*(B2:B5<4)*C2:C5)

"Jarod" wrote:

How do I sum with more than one criteria
Example:

Product Line Period Revenue
Dewatering 1 $5,000
Dewatering 4 $4,000
Intake 2 $2,000
Dewatering 3 $1,000

How would I sum all "Dewatering" revenue for periods 1 thru 3?

All times are GMT +1. The time now is 05:42 AM.