Adding 1 everytime something is in a column

L

Learning Excel

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

Learning Excel

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 !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is function to select only not empty cells in a column (like SHIFT+END+ArrowDown or UP) 7
MAX() of a range of negative values? 7
formula average 3
Function IN VBA 3
VB Code 14
Lookup for cells with text in them 4
Formula 6
sumif and complex sum_range formulae 2

Top