Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging across all worksheets except one
Hello,
I want to find the average value of one cell in every sheet in a workbook, and display it on another sheet (preferably in the same cell). If this is put in the same cell, that means that one sheet must be left out of the averaging. This is for a budget, so I will be constantly adding sheets, and will not know the total number of sheets, so I want to call out something like "= average[ cell() in all sheets except 'Summary']." Anyone have suggestions for how to code this? Thanks a bunch! Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Averaging across worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Trouble with Averaging across several worksheets | Excel Worksheet Functions |