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

Summing across multiple columns 1
Vlookup & 2 variables 3
Grow/Shrink Text gradually from slide to slide 0
in-cell dropdown for vlookup return 4
linking data 2
Calculate rolling average using last 30 values greater than 0. 3
Summation Formula Needed 6
Summing Up Data Based on Codes 2

Top