Count IF Counting a values in a row, but only if two other rows have specific values.

[xryanx]

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

	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>

 

[offthelip]

Your requirement is not very clear but I think you can do what you want with the countifs function :
=COUNTIFS(B31:B218, A5,A31:a218,"FR")

 

[xryanx]

All I had to do was change A31:A218 to C31:C218. But that worked perfectly. I'm glad that you were able to decipher my question. Thank you so much.