Adding columns

[John M]

using cell A1 for example where total will appear )
each time I put info into any cell below a1 i would like a1 to add1
so if I were to have info in the first 12 cells below, ai should read 12 and
add 1 each time I add data to that column

 

[Domenic]

=SUMPRODUCT((A2:A100<>"")*1)

or

=SUM(IF(A2:A100<>"",1,0))
entered using CTRL+SHIFT+ENTER

Hope this helps!

 

[Frank Kabel]

Hi
try
=COUNTA(A2:A1000)
in cell A1

 

[Jason Morin]

=COUNTA(A2:A65536)

HTH
Jason
Atlanta, GA

 

[John M]

Thanks Domenic,,,,your a life saver

=SUMPRODUCT((A2:A100<>"")*1)

or

=SUM(IF(A2:A100<>"",1,0))
entered using CTRL+SHIFT+ENTER

Hope this helps!