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

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?
 
J

JLatham

And if the worksheets aren't structured suitably for 3D references, then a
series of SUMPRODUCT() formulas might do the trick.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding only part of a column of data 3
How do I expand a funtion's maximum character length? eg CUBESET 1
VLOOKUP & Dates: Why is this Formula working? 1
How to replace a cell's formula with a non-zero calculated value? 1
How do I SUM several worksheet to a final worksheet? 3
How do I sum column C based on a value in Column A? 2
How do I count instances of a reference? 1
How do I find how many of a certain day are in a given month 6

Top