I have a smart sheet for job progress I have indicdual lines of % of jobs what formula do I use at the top to get the overall % of all jobs.
Brian,
Are they all weighted equally or is percentage based on total cost, total effort, or total duration?
Simple weighting would be something like
=SUM(range) / COUNT(range)
or
=AVG(range)
You might also be able to leverage weighting using AVGW()
Hope this helps.
Craig
