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.

Adding 1 everytime something is in a column
 

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 ).

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 ).