Formula help

[mehoop]

I cannot get a formula to work with this excel file

[#2 · Accepted solution]

@mehoop 

Change the formula in G2 to

=--LEFT(F2,5)

and fill down to G302.

Change the formula in J2 to

=COUNTIFS($G$2:$G$302,">="&H2,$G$2:$G$302,"<"&I2)

and fill down to J4.

[#3]

Hans, THANK YOU very much, it worked like I want it to