Median with IF not working?

Hello - I have reviewed numerous other posts and cannot seem to get this formula to work

=MEDIAN(IF(B2:B16,C1,A2:A16))

or

=MEDIAN(IF(B2:B16,"=Single Family",A2:A16))

See attached file.

I am using Excel for Mac 2011

Thanks,
Chris.

Hello
I think its the syntax of your IF statement that's wrong, try:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Entered as an Array - Ctrl+Shift+Enter.

Hope this helps.
DBY

DBY - Thank you very much. Solved!