Need help with a problem here. For the attached table, I need to get the AVERAGE of values in column labeled C when the value in column A is "x" and the value in column B is "a" or "b" or "d" or "r" or "t". I think I have to use some combination of averageifs and index/match but I'm not sure how. Any help would be appreciated. Thank you.
Last edited by opsanalysis07; 10-08-2014 at 01:55 AM.
Forgot, for the attached file the answer should return 13
Last edited by opsanalysis07; 10-08-2014 at 01:50 AM.
=AVERAGE(IF((Table1[A]="x")*(Table1[B]={"a","b","d","r","t"}),Table1[C]))
CTRL + SHIFT + ENTER
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Thanks for the feedback:D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks