Average of column entries

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

Try...

=AVERAGE(A1:A100)

Hope this helps!

In article <[email protected]>,
"abfabrob" <[email protected]> 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

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

--
Don Guillett
SalesAid Software
[email protected]
"abfabrob" <[email protected]> wrote in message
news:[email protected]...
> 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

Thank you!!!

"Domenic" wrote:

> Try...
>
> =AVERAGE(A1:A100)
>
> Hope this helps!
>
> In article <[email protected]>,
> "abfabrob" <[email protected]> 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
>

Im no expert, but I would do the following:
If you have Data in A1 TO A5...in A6 enter =count(A1:A5)..This will give you the No of cells with data.
Then in another cell total the date ie =A1:A5...Then in another cell..divide the total count by the number of cell count..
Nodoubt it could be & wil be explained a little better for you.