| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count until blank cell
Hi, I want to know how to count the number of cells in a column until i get
to a blank space. Example:I have a certain set of numbers in Column A, All i want is to count the number of cells taht I have in the first set of numbers. In this case that would be the 23, 432, and 523. the count would be 3. But those number will change maybe to be a total of 5. =count(a1:"") ? how can i do it? countifs,? countif? aount? Column A 23 432 523 543 543 345 234 234 -- asdf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells based on whether another cell is blank or not | Excel Worksheet Functions | |||
| cell is blank then dont count range | Excel Discussion (Misc queries) | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Threaded Mode
