COUNTIFS Range question

[tabbytomo]

Hi, I'm wanting to count the number of 'Yes' values in columns B and C, but only count the 'Yes' values after the last entry in column D for the associated location.

In the attached example, for Kettering the count should result in 1, as there is only 1 'Yes' in columns B and C if we count after the last entry in column D.

I've wracking my brains trying to understand how to express this.

Thank you.

 

[DanteAmor]

Check if the following formula is what you need.
In column F I manually put the names, in column G I put the formula.

Dante Amor
	A	B	C	D	E	F	G
1		Red Bag	2nd	Stock
2	Ket	Yes				Ket	3
3	Tow	Yes	Yes			Tow	1
4	Nor					Nor	2
5	Ket			10
6	Tow	Yes
7	Ket	Yes	Yes
8	Ket		Yes
9	Tow			5
10	Nor			3
11	Nor	Yes
12	Tow		Yes
13	Nor		Yes
14
15
Hoja5

Cell Formulas
Range	Formula
G2:G4	G2	=IFERROR(SUM(($A$2:$A$15=F2)*(($B$2:$B$15="Yes")+($C$2:$C$15="Yes"))*(ROW($A$2:$A$15)>IF(MAX(($A$2:$A$15=F2)*($D$2:$D$15<>"")*ROW($D$2:$D$15))>0,MAX(($A$2:$A$15=F2)*($D$2:$D$15<>"")*ROW($D$2:$D$15)),NA()))),0)
Press CTRL+SHIFT+ENTER to enter array formulas.

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------​