Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a range of cell e.g. (C3:C20). I need to count #
of cells that users have entered any data. Is the following worksheet function the correct one ? =@countif(C3:C20),"") If each cell from C3:C20 is blank, I expect it returns 0. If I enter data in C5, C7 & C9, I expect it returns 3. If not, what function should I use, please advise. Thanks again for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting occurance of empty cells | Excel Discussion (Misc queries) | |||
Counting Empty Dates within a Range? | Excel Worksheet Functions | |||
Counting number of days up to an empty cell then start over again | Excel Discussion (Misc queries) | |||
PRODUCT counting empty cells as 1 | Excel Worksheet Functions | |||
counting rows to an empty cell and making a chart | Excel Programming |