Hi Everyone,
Need some help please. I need to gain an average from a range that spans multiple rows and columns based on criteria that is within different rows and columns.
I have tried the below formula but now appreciate AVERAGEIFS cant handle this requirement without some further integrated formula?
=AVERAGEIFS($F$6:$CH$15,$F$5:$CH$5,">="&$B$7,$F$5:$CH$5,"<"&$B$11,$E$6:$E$15,$B$15)
Attached is a sample sheet
Formula:
Please Login or Register to view this content.
Change B15 to "5-Type" and B19 to "7-Type"
Last edited by JohnTopley; 08-01-2024 at 05:01 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Works perfectly, thank you very much. Thread marked as solved
You're welcome and thank you for rep.
Power Query
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks