Hi All!
Im trying to get the average number of a certain range, but only if it meets a certain criteria. I have looked at other examples but somehow i don't get it to work.
So I want the average of the blue columns. But only if the Red column is a certain name. And if its possible I want to do the formula on a seperate sheet??
Does anyone have any ideas how to make this work?