Assume your range is A1:B7
use this formula
Press ctrl+shift +enter after modification![]()
=AVERAGE(IF(A1:A7=17,B1:B7))
Assume your range is A1:B7
use this formula
Press ctrl+shift +enter after modification![]()
=AVERAGE(IF(A1:A7=17,B1:B7))
I need your support to add reputations if my solution works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks