FORMULAS

Brian Barr

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.

J. Craig Williams

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