how to take a number from the same cell in multiple sheets then a.
 

in excell how do I take a number from the same cell in multiple sheets and
then take an average?

how to take a number from the same cell in multiple sheets then a.
 

Hi dinnon

See
http://www.rondebruin.nl/linksum.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"dinnon" wrote in message ...
in excell how do I take a number from the same cell in multiple sheets and
then take an average?

how to take a number from the same cell in multiple sheets then a.
 

=AVERAGE(Sheet1:Sheet10!A1)

If your sheets have unique names rather than the standard Sheet1, Sheet2 etc.
best to insert a dummy sheet at beginning and another at end.

Name these Start and End.

Formula will be =AVERAGE(Start:End!A1)

Any sheets between Start and End will be included.


Gord Dibben MS Excel MVP

On Wed, 14 Mar 2007 11:56:00 -0700, dinnon
wrote:

in excell how do I take a number from the same cell in multiple sheets and
then take an average?