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

constructing array using non-adjacent columns 0
Adding consistant cells. 4
Excel does not accept text format! 0
Help with an Excel macro please? 6
Cell values to an array, then array transpose to another workbook 8
Lookup for cells with text in them 4
Excel - Wich Function should I use? 1
Copy addition formula of non-consecutive horizontal cells 2

Top