% Complete Across Multiple Project Plans
I have 7 Project Plan sheets. All of them report a total %Complete for each Project Plan. I would like to add up the %Complete then divide by 7, for an overall %complete across all sheets. (I'm assuming I'd add all the %complete and then divide by 7 - though that may not be mathematically correct, either)
Any thoughts on how to get this done? I've tried to create a new sheet, link that information for each 7 sheets, and then add them up, etc. However, you cannot create a formula for a value that has been linked in.
thanks for your help!
Help Article Resources
Check out the Formula Handbook template!