Countif function to show how often numbers within a range are pres
I use a sheet to track when I receive items, once per day, and I log the time
in 24 HR format using numbers, no formatting. I want to be able to count how
many times in a row (Month) the number is between two numbers to help me
identify if I get the items in morning, afternoon, evening. I think I would
use countif but I don't know how to have it count each time the number in the
cell is between the hours I determine. I think it would look like:
countif(range,<1:1159) or something similar but I can't figure it out.
Any help would be greatly appreciated! Thanks in advance!
|