Hello Maryren,
Based on your profile, you are using Excel 2007, so take a look on AVERAGEIFS.
=AVERAGEIFS(AverageColumn,Location,"A",Number,123)
If you need compatibility with pre 2007 versions, could use this Array Formula with CTRL+SHIFT+ENTER
=AVERAGE(IF(Location="A",IF(Number=123,AverageColumn)))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
I've tried the formula below and it does not work, guessing I don't have it written correctly:
=AVERAGE(IF(A1:A6="A",IF(B2:B6="123",C2:C6))), using Crtl+Shift+Enter, it returns an error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks