Creating an average based on 3 different sheets
I'm trying to create an average based on 3 different sheets. Right now I have 3 sheets (Tracker, Completed, Dead) these all have a summary calculation to give me the total number of sites for each developer. I'm trying to create a number for each developer that tell me how many sites get completed on average.
Right now I know how many are live and how many die & how many they have completed but I need to get a number of how many get completed based on an average.
Help Article Resources
Check out the Formula Handbook template!