C4 needs to have the total sum of all Values from J16:J200 that have the value in B16:B200 that is equal to A4.
Example: Because A4 is RK and B16 is RK, C4 will equal $250.
IF I add a new row and B18 is RK and J18 is $250, then C4
will be $500.
Thank you for any help.
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 166px;"><col style="width: 82px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Example: Because A4 is RK and B16 is RK, C4 will equal $250.
IF I add a new row and B18 is RK and J18 is $250, then C4
will be $500.
Thank you for any help.
A | B | C | D | E | F | G | H | I | J | |
3 | SP | # of Fails | $$$ | SP | # of Fails | $$$ | Total Crackouts | 2 | ||
4 | RK | 1 | 11 | Total $$$ | $470.00 | |||||
5 | DR | 1 | 12 | |||||||
6 | HS | 13 | Avg Lovgevity | 213.5 | ||||||
7 | BP | 14 | ||||||||
8 | JY | 15 | ||||||||
9 | 6 | 16 | ||||||||
10 | 7 | 17 | ||||||||
11 | 8 | 18 | ||||||||
12 | 9 | 19 | ||||||||
13 | 10 | 20 | ||||||||
14 | ||||||||||
15 | Date | SP | Location | Date of Repair | Referral # | Name | Vehicle | Date of Replace | $$$ | |
16 | 1/1/2018 | RK | NEL | 1/1/2017 | 6549876549 | johnson johnson and | 2018 ford expedition lkkk | 12/30/2018 | $250.00 | |
17 | 2/2/2018 | DR | LV | 12/2/2017 | 321321 | bobb | $220.00 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 166px;"><col style="width: 82px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas | ||||||||||||||||||||||||||||||||||||||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>