I | J | K | L | M | N | O | |
5 | NEL | 2 | 2 | $125.00 | $125.00 | ||
6 | LV | 2 | 2 | $380.00 | $380.00 | ||
7 | AA | ||||||
8 | 308 | 3 | 3 |
<tbody>
</tbody>
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
29 | 1/15/2018 | JY | FR | 308 | 12/8/2017 | 2017 Ford Escape | 38 | ||||||||
30 | 1/23/2018 | DR | FR | LV | 12/16/2017 | 2008 Ford Edge | 1/25/2018 | $190.00 | 38 | ||||||
31 | 1/23/2018 | ID | FR | 308 | 8/28/2017 | 2016 Hyundai Santa Fe | 148 | ||||||||
32 | 1/23/2018 | JY | FR | 355 | 1/14/2018 | 2009 Chevy T&C | 9 |
<tbody>
</tbody>
Hopefully someone can help me.
D:29 down is the location of the sale
C:29 down is the code for Full Replace (FR)or Clawback (CB)
M:29 down is the amount of the replacement
N:29 down is the amount of the clawback
I5:I12 are the locations
I am currently using the below formulas:
in M5
=SUMIF(D29:D216, I5, M29:M216) to get the Replacement totals
in N5
=SUMIF(D29:D216, I5, N29:N216) to get the Clawback totals
I would like to eliminate N:29 down and only use M:29 down for amounts.
How can I change my current formulas in M5 and N5 to read data from C29, D29, M29, I5 and add the totals to M5 (FR)and N5(CB) that I am looking for.
Also, I have another formula that I have else where on this sheet that I was trying to reference. =COUNTIFS(D29:D216, I5,C29:C216,"FR")
I hope that this made sense and any help is appreciated.