| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting the number of cells within a certain hour.
I am having trouble figuring out how to count the number of cells that fall
within a certain timeframe. In column B48:B350, I have time values. Let's say that B48:B68 fall between 3:00 AM and 4:00 AM. What formula could I use to find the answer of 20? The formula I tried, =SUMPRODUCT(--(B48:B350=TIMEVALUE("3:00 AM")),--(B48:B350<TIMEVALUE("4:00 AM"))) returns 0. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
| Counting cells with data | Excel Discussion (Misc queries) | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Threaded Mode
