While calculating average percentages amongst multiple worksheets is fairly straightforward, the premise seems to be that the data being calculated must be in the same cell on each worksheet, at least, that's what I have gathered from perusing different forums. I have four worksheets; each worksheets consists of an average range of cells, BUT, sheets three and four have a cumulative average percentage. My question is, how could I put together a formula to calculate the cumulative average percentage on each page, BUT, the resulting answer will be in different cells on each worksheet. For example, worksheet 2 (I've named 9-10-18 thru 09-14-18) will show the resulting cumulative percentage for worksheet 1 & 2 in cell Z38, while the resulting cumulative percentage will be in cell Z25 on page 4. Hence, my dilemma.
Calculating the average percentage amongst a range of cells on the same worksheet is easy for me. I just need some direction in calculating average percentages amongst multiple worksheets with the resulting answer falling in different cells on different worksheets. Any help is appreciated. Thanks.
Calculating the average percentage amongst a range of cells on the same worksheet is easy for me. I just need some direction in calculating average percentages amongst multiple worksheets with the resulting answer falling in different cells on different worksheets. Any help is appreciated. Thanks.
