Sumif (I think)
Assuming your data starts in A1
=SUMPRODUCT((A2:A5="Dewatering")*(B2:B54)*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?
|