thatholycow
New Member
- Joined
- Nov 19, 2018
- Messages
- 3
Hi,
I am unable to derive below 2 amounts using SUMIFS.
Item code (e.g. C1, A1, A2, A4, A12) cannot be split due they are a cluster.
Appreciate if someone is able to enlighten me.
Many thanks in advance!
<tbody>
</tbody>
<tbody>
</tbody>
I am unable to derive below 2 amounts using SUMIFS.
Item code (e.g. C1, A1, A2, A4, A12) cannot be split due they are a cluster.
Appreciate if someone is able to enlighten me.
Many thanks in advance!
Item Group | Item Code | Total Amt (Using SUMIFS) | Manual Calculation |
52-21-01 | C1, A1, A2, A4, A12 | NA | $687.00 |
52-21-01 | C2 | $66.00 | $66.00 |
52-21-01 | C1, A1, A2, A4, A12, A14 | NA | $984.00 |
52-21-01 | C2 | $66.00 | $66.00 |
52-09-01 | C1 | $652.00 | $652.00 |
<tbody>
</tbody>
Item Price List | ||
Item Group | Item Code | Price |
52-09-01 | C1 | $652.00 |
52-09-01 | P2 | $28,556.00 |
52-21-01 | C1 | $92.00 |
52-21-01 | C2 | $66.00 |
52-21-01 | C1, A1, A2, A4, A12, A17 | $687.00 |
52-21-01 | A14 | $297.00 |
<tbody>
</tbody>