Querying my sheet
i have these two columns:
ESTIMATION PER HOUR (number)
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,
Help Article Resources
Check out the Formula Handbook template!