Hello guys,

Can someone teach me on how i can use countif formula into subtotal?

I have a column of time of the day in "h:mm" format and first i countif all less than 1900 and greater than 1900 to separate. But i need to filter it accdg to category.

i have use this formula to count
=COUNTIF($R$3:$R$586,">"&TIME(19,0,0))

how can i apply it to subtotal?

Thanks a lot!!!