Count the non-numeric value starting with "T" based on specific date

[ExcelNewbie2020]

i have a long range of dates.. i want to count all the non-numeric values starting with the latest "T" upto specific date (Q2).
However the count is zero if the specific date is "T" followed by a numeric value or a numeric value.. see below

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2																	05-03-25
3
4	01-03-25	02-03-25	03-03-25	04-03-25	05-03-25	06-03-25	07-03-25	08-03-25	09-03-25	10-03-25	11-03-25	12-03-25	13-03-25	14-03-25	15-03-25		Expected Result
5	8	T	V	F	T	8	8	8	8	8	T	S	V	F	E		0	Since March 5 is T and followed by numeric values
6	6	6	T	F	E	F	S	T	F	F	E	F	S	V	X		3	Starting March 3 "T" to March 5
7	8	T	S	F	F	E	F	S	V	V	F	E	T	S	V		4	Starting March 2 "T" to March 5
8	8	8	8	T	E	F	E	F	S	V	T	E	F	S	V		2	Starting March 4 "T" to March 5
9	8	8	8	8	8	8	T	F	S	V	T	E	F	S	V		0	Since March 5 numeric values
10	8	8	8	8	T	Z	F	F	S	V	T	E	F	S	V		1	Since March 5 is "T" followed by non-numeric values
Sheet2

 

[ExcelNewbie2020]

How about this option:

=LET(fr,FILTER(A5:O5,$A$4:$O$4<=$Q$2+1),c,IF(TAKE(fr,,-1)="T",HSTACK(DROP(fr,,-1),"E"),fr),a,--ISTEXT(DROP(c,,XMATCH("T",c,,-1))),IF(TAKE(a,,1)=0,0,SUM(a)))

i think that solves it.. thank you very much

 

[Georgiboy]

You're welcome, thanks for the feedback.