| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
As an example this averages the values in cell A1 in 50 sheets:
=AVERAGE(Sheet1:Sheet50!A1) -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Juan Quiros" <Juan wrote in message ... Excel function AVERAGE allows 1 to 30 arguments for which you want the average. I have a workbook with 50 worksheets. How I can produce a 3D AVERAGE? Please somebody help me!!! Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Hybrid Mode
