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?