Average across selected worksheets
 

Hi there,
I have 12 worksheets (months) with a total in a single cell on each sheet,
I'd like to average them on a summary sheet so I have one overall figure.

Any guidance would be greatly appreciated.

Thanks

Stephanie

Average across selected worksheets
 

Try this:

=AVERAGE(Jan:Dec!A1)

--
Biff
Microsoft Excel MVP


"Stephanie" wrote in message
...
Hi there,
I have 12 worksheets (months) with a total in a single cell on each sheet,
I'd like to average them on a summary sheet so I have one overall figure.

Any guidance would be greatly appreciated.

Thanks

Stephanie