Dynamic Countif Across Columns

[dabrows]

I am basically looking to create a dynamic range for the countif function call. Basically, if I change my 'Time' parameter the range within the call will adjust accordingly. I am struggling to do this without VBA. Rather not code something if I don't have to. Any and all help is much appreciated!

See the attached for a brief example.

[CARACALLA]

M3=sumproduct((a1:j1=m1)*(a2:j100=m2))

[PaulM100]

From what I understand in your sample sheet you should use: =COUNTIFS($A$1:$J$1,"<="&M1,$A$2:$J$2,$M$2)

[dabrows]

From what I understand in your sample sheet you should use: =COUNTIFS($A$1:$J$1,"<="&M1,$A$2:$J$2,$M$2)

This is exactly what I needed! Thank you for your help!