Try...

=AVERAGE(A1:A100)

Hope this helps!

In article ,
"abfabrob" wrote:

I have a column of numbers and at the bottom I want the cell to display the
average NOT the total. Can this be done?

Thank you,

Rob,
Teesside,
UK