View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Learning Excel Learning Excel is offline
external usenet poster
 
Posts: 98
Default Adding 1 everytime something is in a column

I have an empty column that I fill with numbers that could be 2, 30, etc.
( from A1 to A40). In A41 I like to have a total of cells with numbers on it
( not the sum ), in other words, A41=total of cells filled from A1 to A40.
Thanks in advance for the formula ( no VBA please ).
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.