Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Would it be possible to count the number of empty cells in a column,
that fall between the first occupied cell and the last occupied cell in a range. For example if A5:A20 can be populated, but the first occupied cell is A8 and the last occupied cell is A12, I wish to count only those cells that are <blank between A8:A12 Another example would be if the first occupied cell was A13 and the last occupied cell is A15, I wish to count only those cells that are <blank between A13:A15 If you could visualise the above being Clock in / Out times, I wish to know what part of the day there is no job allocated Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
VBA help Range Count | Excel Discussion (Misc queries) | |||
Using a count in a range name | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |