Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking to too many pages in a formula, how do I get around this?
I have excel 2003
I gather data from 13 different groups. the data I gather is in percentages 0 - 100% I have a worksheet for each month. I need a running Year to Date on each group's numbers. On each new worksheet I average the data from each month before to get the year to date, but it won't let me add any more after June because it's more than 7 items. How do I get around this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking to too many pages in a formula, how do I get around this?
How are you structuring your formula? The 7 limit usually refers to amount of
nested formulas. You should be able to contruct your averages in parallel, not serial. Depending on worksheet structure, you might also want to take a look at using 3D references to calculate your SUM/AVERAGE's. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Meenie" wrote: I have excel 2003 I gather data from 13 different groups. the data I gather is in percentages 0 - 100% I have a worksheet for each month. I need a running Year to Date on each group's numbers. On each new worksheet I average the data from each month before to get the year to date, but it won't let me add any more after June because it's more than 7 items. How do I get around this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking to too many pages in a formula, how do I get around th
And if the worksheets aren't structured suitably for 3D references, then a
series of SUMPRODUCT() formulas might do the trick. "Luke M" wrote: How are you structuring your formula? The 7 limit usually refers to amount of nested formulas. You should be able to contruct your averages in parallel, not serial. Depending on worksheet structure, you might also want to take a look at using 3D references to calculate your SUM/AVERAGE's. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Meenie" wrote: I have excel 2003 I gather data from 13 different groups. the data I gather is in percentages 0 - 100% I have a worksheet for each month. I need a running Year to Date on each group's numbers. On each new worksheet I average the data from each month before to get the year to date, but it won't let me add any more after June because it's more than 7 items. How do I get around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking data using 1-10 pages | Excel Discussion (Misc queries) | |||
linking pages of a workbook | Excel Discussion (Misc queries) | |||
linking worksheet pages | Links and Linking in Excel | |||
linking excel pages | Excel Discussion (Misc queries) | |||
Linking multiple pages | Excel Discussion (Misc queries) |