Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averages from different worksheets
Hello:
I want to calculate an average based upon the following scenario: I have an Excel workbook with 5 individual worksheets In each worksheet I have a number located in D28. I want to calculate the average of these 5 numbers located in these different worksheet in my workbook. (in this example the numbers are located in D28 in each worksheet, but they may not be in the same spot in the future) I can calculate averages with no problem if the numbers are in the same worksheet, but I am having problems calculating the average if the numbers are in different worksheets. What is the best way to handle this? Thanks for your time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averages from different worksheets
Your formula would look something like this :
=AVERAGE(Sheet3!D28,Sheet2!D28,Sheet1!D28) " wrote: Hello: I want to calculate an average based upon the following scenario: I have an Excel workbook with 5 individual worksheets In each worksheet I have a number located in D28. I want to calculate the average of these 5 numbers located in these different worksheet in my workbook. (in this example the numbers are located in D28 in each worksheet, but they may not be in the same spot in the future) I can calculate averages with no problem if the numbers are in the same worksheet, but I am having problems calculating the average if the numbers are in different worksheets. What is the best way to handle this? Thanks for your time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averages from different worksheets
When you say sheet 1, 2, 3, etc. am I supposed to use the actual name
I have given the sheet or literally use sheet 1, sheet2, sheet 3, etc. wrote: Hello: I want to calculate an average based upon the following scenario: I have an Excel workbook with 5 individual worksheets In each worksheet I have a number located in D28. I want to calculate the average of these 5 numbers located in these different worksheet in my workbook. (in this example the numbers are located in D28 in each worksheet, but they may not be in the same spot in the future) I can calculate averages with no problem if the numbers are in the same worksheet, but I am having problems calculating the average if the numbers are in different worksheets. What is the best way to handle this? Thanks for your time. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averages from different worksheets
Assuming the sheets are called Sheet1, Sheet2, etc., put D28 in a cell, say
B1, and use =SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&ROW(1:5)&"'!"& B1),"<"))/ SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&ROW(1:5)&"'!" &B1),"<")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... Hello: I want to calculate an average based upon the following scenario: I have an Excel workbook with 5 individual worksheets In each worksheet I have a number located in D28. I want to calculate the average of these 5 numbers located in these different worksheet in my workbook. (in this example the numbers are located in D28 in each worksheet, but they may not be in the same spot in the future) I can calculate averages with no problem if the numbers are in the same worksheet, but I am having problems calculating the average if the numbers are in different worksheets. What is the best way to handle this? Thanks for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Merge Worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |