Hello all!
I am trying to create a SUMIFS statement that will use drop-down box values to select sum totals in a pivot table by Period (P1 - P6) for all categories from A:E.
Excel 2013/2016
<tbody>
</tbody>
The drop-down items are below:
Excel 2013/2016
<tbody>
</tbody>
The answer I am looking for is the sum total of P5 in this case is $1,726.00
Thank you!
I am trying to create a SUMIFS statement that will use drop-down box values to select sum totals in a pivot table by Period (P1 - P6) for all categories from A:E.
Excel 2013/2016
A | B | C | D | E | F | G | H | I | J | K | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | Values | ||||||||||
2 | Factory | Node | Cost Center Description | Secondary Expense | Expense Type | P1 | P2 | P3 | P4 | P5 | P6 |
3 | Hackettstown | HKP Line 1 Non-Nut | HKP L1 General Expense/Alloc | Prod Exp - Consumables | Expense | - | - | 13.00 | 648.00 | 1,726.00 | 746.00 |
4 | Hackettstown | HKP Line 1 Non-Nut | HKP L1 Maintenance | Prod Exp - Consumables | Expense | 5,889.00 | 2,864.00 | 3,116.00 | 446.00 | 1,993.00 | 1,376.00 |
5 | Hackettstown | HKP Line 1 Non-Nut | HKP Milk Chocolate Shift Leads | Prod Exp - Consumables | Expense | 181.00 | 176.00 | - | 20.00 | - | - |
6 | Hackettstown | HKP Line 1 Non-Nut | HKP Milk Process | Prod Exp - Consumables | Expense | - | - | - | - | - | - |
7 | Hackettstown | HKP Line 1 Non-Nut | HKP Packing Room -Milk Choco | Prod Exp - Consumables | Expense | - | - | - | - | 125.00 | - |
8 | Hackettstown | HKP Line 1 Non-Nut | HKP Support Value Stream Team Captains | Prod Exp - Consumables | Expense | - | - | - | 14.00 | - | 191.00 |
9 | Grand Total | 6,070.00 | 3,040.00 | 3,129.00 | 1,128.00 | 3,844.00 | 2,313.00 |
<tbody>
</tbody>
2017 Pivot
The drop-down items are below:
Excel 2013/2016
B | C | |
---|---|---|
2 | Period | P5 |
3 | Factory | Hackettstown |
4 | Node | HKP Line 1 Non-Nut |
5 | Cost Center Description | HKP L1 General Expense/Alloc |
6 | Secondary Expense | Prod Exp - Consumables |
7 | Expense Type | Expense |
8 | ||
9 | Total | $1,726.00 |
<tbody>
</tbody>
Hackettstown
The answer I am looking for is the sum total of P5 in this case is $1,726.00
Thank you!
Last edited: