How to display cells with content

[Beermonster]

How do I display a count for cells that have numbers in, for example if I have A1-A20 and cells A1-A6 are the only ones to have something in I want another cell to return the value 6

[Ace_XL]

Try..

=COUNTA(a1:a20)

[BadlySpelledBuoy]

=counta(a1:a20) will count non blank cells in a range

or

=count(a1:a20) will count numeric values in a range

[Beermonster]

Thanks, I've been looking for ages for on how to do that, easy when you know how