Hello
I think its the syntax of your IF statement that's wrong, try:
or![]()
=MEDIAN(IF(B2:B16=C1,A2:A16))
Entered as an Array - Ctrl+Shift+Enter.![]()
=MEDIAN(IF(B2:B16="Single Family",A2:A16))
Hope this helps.
DBY
Hello
I think its the syntax of your IF statement that's wrong, try:
or![]()
=MEDIAN(IF(B2:B16=C1,A2:A16))
Entered as an Array - Ctrl+Shift+Enter.![]()
=MEDIAN(IF(B2:B16="Single Family",A2:A16))
Hope this helps.
DBY
DBY - Thank you very much. Solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks