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 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks