Operations Across Sheets

  • Thread starter Thread starter Zyvind
  • Start date Start date
Z

Zyvind

Hi,
I want to summarize, calculate averages, min, max, etc
ACROSS several sheets in a workbook.
I used to be able to do this very easily in Lotus 1-2-3.
Hoow do I do this in Excel?
Thanks for any input
 
The same way you do it if they were all on one sheet with one
exception.In the formula you must refer to the sheetname you are getting
the value from.
=AVERAGE(Sheet1!A1,Sheet2!A1,Sheet3!A1)
 
Back
Top