Search code examples
excelmaxaveragecriteria

Get average of certain groups if CRITERIA IS

I'm trying to check what the average percentage of a KPI is for multiple groups at the same time. It should only be the last three groups I have though. I have made a complete example file that can be used as I find it complicated to explain (with instructions) and if successful, the value in C13 should change to TRUE:

https://1drv.ms/x/s!AjWVkb2UBexjhzWtnniTr8JJel2z

Can anyone help? I'm completely lost as to where to begin.

Solution

  • Sorry. I really complicated this. I could have just added another tenure column that checked if they had worked less than 90 days, if the date of the data I wanted to check was <90 days, then used that in a simple AVERAGEIFS formula. Solved.