If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|