Linking to too many pages in a formula, how do I get around this?

  • Thread starter Thread starter Meenie
  • Start date Start date
M

Meenie

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?
 
And if the worksheets aren't structured suitably for 3D references, then a
series of SUMPRODUCT() formulas might do the trick.
 
Back
Top