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?

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?

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?