Hello,

I want to find the average value of one cell in every sheet in a
workbook, and display it on another sheet (preferably in the same
cell). If this is put in the same cell, that means that one sheet must
be left out of the averaging.

This is for a budget, so I will be constantly adding sheets, and will
not know the total number of sheets, so I want to call out something
like "= average[ cell() in all sheets except 'Summary']."


Anyone have suggestions for how to code this? Thanks a bunch!

Rob

I'm not sure I fully understand the question but if you simply want the
average of the same cell in multiple worksheets then this will average A1 in
all worksheets.

=AVERAGE(Sheet1:Sheet10!A1)

Repalace sheet1 with the first sheet and sheet 10 with the last sheets in
the book that you want to average

Mike

" wrote:

Hello,

I want to find the average value of one cell in every sheet in a
workbook, and display it on another sheet (preferably in the same
cell). If this is put in the same cell, that means that one sheet must
be left out of the averaging.

This is for a budget, so I will be constantly adding sheets, and will
not know the total number of sheets, so I want to call out something
like "= average[ cell() in all sheets except 'Summary']."


Anyone have suggestions for how to code this? Thanks a bunch!

Rob

Hi Rob

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

--

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


wrote in message oups.com...
Hello,

I want to find the average value of one cell in every sheet in a
workbook, and display it on another sheet (preferably in the same
cell). If this is put in the same cell, that means that one sheet must
be left out of the averaging.

This is for a budget, so I will be constantly adding sheets, and will
not know the total number of sheets, so I want to call out something
like "= average[ cell() in all sheets except 'Summary']."


Anyone have suggestions for how to code this? Thanks a bunch!

Rob