View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Beto Beto is offline
external usenet poster
 
Posts: 24
Default 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