Sum Frequency Within a Date Range?

Hi everyone,

I'm having difficulty counting the frequency of an event within a date range. I've managed to count the total instances within the date range but I can't figure out how to make this work with the frequency.

I think the most challenging part is that the frequency is looking for two different conditions, where when I've got the total instances working I'm just looking for 1 set criteria.

I've attached a sample worksheet including sample data and expected results which hopefully helps explain this better!

(looking for frequency of consecutive T and X events within a date range)

Thanks for the help!

Excel_Noob

Please try

=LET(x,C7:K7,d,$C$6:$K$6,z,FILTER(x,(d>=$N$3)*(d<=$M$3)),y,TRIM(CONCAT(0,IF((z="T")+(z="X")," ",0),0)),LEN(y)-LEN(SUBSTITUTE(y," ",)))

or

=SUM(SIGN(FREQUENCY(IF(($C$6:$K$6>=$N$3)*($C$6:$K$6<=$M$3)*((C7:K7="T")+(C7:K7="X")),COLUMN(C7:K7)),IF(C7:K7="",COLUMN(C7:K7)))))