Adding 1 everytime something is in a column
Shorter answer I never expected , thanks for your time that I greatly
appreciate, that's more valuable than anything. Thanks JE McGimpsey.
It works perfect !
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.
"JE McGimpsey" wrote:
One way:
=COUNT(A1:A40)
In article ,
Learning Excel wrote:
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 ).
|