I hope that I ask this correctly.
In the first table B5 needs to equal the count of all in B31:B200, but only for the same value as in A5. I currently have this formula: =COUNTIF(B31:B218, A5)
But now I have a problem, I need that to be true only if the cell in column C in the same row number is FR.
Ex: B32 = DR
B35 = DR
C32 = FR
C35 = FR
That combination is how B7 has a value of 2. IF C35 were to change to CB, then B7 would change to 1.
Any help is appreciated. Thank you
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"></colgroup><tbody>
</tbody>
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"></colgroup><tbody>
</tbody>
In the first table B5 needs to equal the count of all in B31:B200, but only for the same value as in A5. I currently have this formula: =COUNTIF(B31:B218, A5)
But now I have a problem, I need that to be true only if the cell in column C in the same row number is FR.
Ex: B32 = DR
B35 = DR
C32 = FR
C35 = FR
That combination is how B7 has a value of 2. IF C35 were to change to CB, then B7 would change to 1.
Any help is appreciated. Thank you
A | B | C | D | E | F | G | |
5 | R | 1 | $60.00 | $60.00 | |||
6 | RK | 1 | $65.00 | $65.00 | |||
7 | DR | 2 | $380.00 | $380.00 | |||
8 | HS | ||||||
9 | BP |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"></colgroup><tbody>
</tbody>
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
30 | Date | SP | Type (FR or CB) | Location | Date of Repair | Referral # | Name | Vehicle | Date of Replace | $$$ Full Replacement | $$$ Clawback | Days Since Repair | ||
31 | 1/15/2018 | JY | FR | 308 | 12/8/2017 | 2017 Ford Escape | ||||||||
32 | 1/23/2018 | DR | FR | LV | 12/16/2017 | 2008 Ford Edge | 1/25/2018 | $190.00 | ||||||
33 | 1/23/2018 | ID | FR | 308 | 8/28/2017 | 2016 Hyundai Santa Fe | ||||||||
34 | 1/23/2018 | JY | FR | 355 | 1/14/2018 | 2009 Chevy T&C | ||||||||
35 | 1/25/2018 | DR | FR | LV | 3/14/2017 | 2010 Ford Edge | 1/25/2018 | $190.00 | ||||||
36 | 1/26/2018 | RK | CB | NEL | 6/22/2017 | 2008 Jeek Cherokee | 1/26/2018 | $65.00 | ||||||
37 | 1/26/2018 | R | CB | NEL | 10/6/2016 | 2016 Ford Escape | 1/26/2018 | $60.00 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"></colgroup><tbody>
</tbody>