View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joemc911 joemc911 is offline
external usenet poster
 
Posts: 12
Default 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!