Formula for avg labor rates

Options

Hello!

I am trying to get an overall average of the amount of labor hours it takes to install equipment per quantity installed.

Here is a screenshot of the following columns I am trying to gather the average from.

I want to get the average labor hours per qty installed per equipment. In this case it would be the average of two with two different quantities. But I would like a formula that I could replicate for other equipment type.

Please help! Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!