View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default need help with a formula

Try

=COUNTA(A:A)

Mike

"LJ" wrote:

I have a column that data will be entered in and I need to have a cell that
will increase numerically with the number of cells that have a number in it
in the column. for example there are five cells with data. the summary cell
should say 5 when I enter another cell of data the summary cell should change
to 6