Count cells in a range

Hello, I need to count how many values in a range of hours, something like this

=COUNTIFS($C$2:$C$6972;">=H6";$C$2:$C$6972;"<=H7")

The H column goes like

1019893815
1019895015
1019896215
1019898015

This is time and date on seconds (GPS time)

The problem is, if my formula is comparing the cell like the first formula I posted the return is "0", but if I make this

=CONT.SES($C$2:$C$6972;">=1019893815";$C$2:$C$6972;"<=1019895015")

The thing works. But I dont want to type manualy the values. Is the anything I can do?

You need to have cell refs follow an '&'. Like this

=COUNTIFS($C$2:$C$6972;">="&H6;$C$2:$C$6972;"<="&H7)

Thanks a lot!

You're welcome.