Cumulative percentage

Someone posted in another thread that merged cells cause an issue, so I eliminated the merged cells and attached the correct version with sample numbers. Sorry for the mix-up.

Originally Posted by shg

Cumulative percentage? What does that mean? I can't imagine the significance of that.

You mean the average?

Not the average. The running percentage. It seems like an average, but I don't think that an average calculation will get me the desired result. I'm no math whiz, so I could be wrong.

Originally Posted by FDibbins

Actually, I think what you need to do, is sum the 2 sets of values that are giving you the % in the 1st place, and then calc the % based of those 2 totals - that would be the mathematically correct way (averaging % is mathematically wrong, and just adding them uo like my 1st suggestion, is pretty meaningless)

In the other workbook, where you were such a huge help, that is how I arrived at my initial percentages. This one, however, would take data from those workbooks and form an overall summary. So, there are 5 centers...each one completes, on a weekly basis, the workbook from the other thread. Those workbooks get submitted to the Regional Manager who, then, plugs results derived from those calculations into this form to determine the entire region's performance. So, if she had to plug in a significant amount of data, she might be less-likely to use this. Ideally, she just has to plug one number per day per center into this in order to get the overall result.

If I can't calculate it, I will probably just incoporate the totals onto this sheet and calculate the percentage off of that.

I thought of that, but it would mean compiling info from 5 separate files every single week. That, I have no idea how to do.

Each week the name of the file would likely change to something indicative of the date of creation and the center, for example: "12/14/2013 Central"...or something to that affect. Each file would be created, and named, by each individual center with 5 in total for the week. I don't know the Excel abilities of whoever is set to review the files or the reliability of those who will create them weekly, so I think it would end up being more trouble than it is worth......unless there is a fairly easy way to automate it.

Most likely not. I was trying to make it easier for the manager, but she will just have to add a few more numbers. I may ask for help when I get there though...