I have attached a sample of data sheet.
trial.xlsx
Could someone help me with a formula that will filter columns E & F and then give me the average of Col I. For example, I want the average of Col I when E=520 & F=ALB. Many thanks
I have attached a sample of data sheet.
trial.xlsx
Could someone help me with a formula that will filter columns E & F and then give me the average of Col I. For example, I want the average of Col I when E=520 & F=ALB. Many thanks
=averageifs(i:i,e:e,520,f:f,"alb")
Thanks very much
No problem. Happy to help.
Don't forget to mark the thread as SOLVED if you're happy with the solution.
BSB.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks