Average of column entries

abfabrob · Apr 12, 2005

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

Domenic · Apr 12, 2005

Try...

=AVERAGE(A1:A100)

Hope this helps!

Don Guillett · Apr 12, 2005

IF, at the bottom means the status bar?? right click on it and change

abfabrob · Apr 12, 2005

Thank you!!!

Domenic said:
Try...

=AVERAGE(A1:A100)

Hope this helps!