Querying my sheet

Hello,

i have these two columns:

ESTIMATION PER HOUR (number)

RESOLUTION (numbers)

I want to query the sum of all ESTKM2/H matching if RES=5 and divide it by the number of items matching this query. In the end i want to calculate the mean of estimation among all resolution 5 jobs.

The result would be something like= the mean of resolution "5" jobs is taking "X" hours,

Thanks!!!!

Alberto

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!