Sumif (I think)

J

Jarod

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?
 
R

RonaldoOneNil

Assuming your data starts in A1

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summation Formula Needed 6
Summing Up Data Based on Codes 2
Formula needed for Sum(A1:C1) then Sum(D1:F1) in next cell 7
Vlookup & 2 variables 3
Multiple Condition Sumif Formula 3
in-cell dropdown for vlookup return 4
formula to return a $ amount for a range of % 2
Calculating on a Continuous Form 3

Top