Formula to measure moving averages
Hi there. I’m trying to find out if I can use a formula to calculate the average project time for the last 10 projects of a specific category.
I have a sheet that is collecting project data which includes the category and the total time spent. What i need to do is calculate the average total time spent for the last 10 projects of a specific category.
any help gratefully received
Help Article Resources
Check out the Formula Handbook template!