Hello,

I have a workbook containing upto 30 worksheets, i.e.
at any given time there could be any number of sheets
from 1 to 30

I'd like to have a function which would average values
in one particular cell across the sheets prior to the call
(from sheet1 to the sheet where the function is called).

Could somebody please get me started on this one.

Thanks in advance,
Mark

Mark,

It is quite simple

=AVERAGE(Sheet2:Sheet30!A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mark Dvorkin" wrote in message
...
Hello,

I have a workbook containing upto 30 worksheets, i.e.
at any given time there could be any number of sheets
from 1 to 30

I'd like to have a function which would average values
in one particular cell across the sheets prior to the call
(from sheet1 to the sheet where the function is called).

Could somebody please get me started on this one.

Thanks in advance,
Mark

embarrassing but very helpful!
Thanks Bob

Bob Phillips wrote:

Mark,

It is quite simple

=AVERAGE(Sheet2:Sheet30!A1)