Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif function for Even and Odd numbers | Excel Worksheet Functions | |||
can't use function 'countif' in named range | Excel Discussion (Misc queries) | |||
two numbers need to show each number in the range btw them | Excel Discussion (Misc queries) | |||
COUNTIF for range of numbers | Excel Discussion (Misc queries) | |||
Using COUNTIF to find numbers within a range greater than the mean | Excel Worksheet Functions |