Operations Across Sheets

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
 
T

Thomas

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Is this possible?? 3
drag across multiple data sets 4
Help with time function 4
Max Price and Min Price paid for an item - Rephrsed 4
Vlookup across several sheets 3
Conditional SUM across multiple worksheets 0
Automatically add a column to summary sheet if another worksheet i 2
Functions on filtered data 1

Top