No AVERAGEIFS so I tried AVG(COLLECT) but can't get it to work with multiple criteria
Hi, I'm trying to calculate the average of the operational speed [plants/h] only if the [job type] is "Grafting TOM" (cells highlighted in yellow) and also IF [week NO] is a certain value: so basically the average speed for each week for each job type.
This formula will be on a different Metrics sheet on the same folder (sheet attached below), I'm working on generating on this sheet the average of each specific job type (on the column [tasks]) for each week listed on this metric sheet.
I've tried AVG(COLLECT) formula as well for few hours but it seems that I'm missing something here, can't get it working.
Anyone could help giving me some hints to get over this?
Help Article Resources
Check out the Formula Handbook template!