Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find average of values from multiple sheets?
how can i find average of values to a field present in 10 different sheets of
the same workbook. the fields may or may not be located in the same cell position, so a lookup before average is necessary. thanks in advance for all help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find average of values from multiple sheets?
To do an average of cells on 10 different sheets, use something like:
=(sheet1!a2+sheet2!a5+sheet3!d7+...+sheet10!d87)/10 It's unclear what you mean by "a lookup before average is necessary". If you need more help, post back. Regards, Fred. "Shadab Malik" <Shadab wrote in message ... how can i find average of values to a field present in 10 different sheets of the same workbook. the fields may or may not be located in the same cell position, so a lookup before average is necessary. thanks in advance for all help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Over Multiple Sheet Tabs with Multiple Values | Excel Worksheet Functions | |||
Average same cell in multiple sheets | Excel Discussion (Misc queries) | |||
Finding the average across multiple sheets | Excel Worksheet Functions | |||
Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
Find values from cells in multiple sheets | Excel Worksheet Functions |