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!!!
Bookmarks