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

Luke M

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.
 
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 to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
How do I expand a funtion's maximum character length? eg CUBESET 2
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
Weighted ranking of a series 3
Statistics question - How many painters do I need to feed? 0
How do I find how many of a certain day are in a given month 6
Formula to fill cells based on Date of Arrival and Date of Departure 1

Top