Results 1 to 3 of 3

Median with IF not working?

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    United States
    MS-Off Ver
    Excel for Mac 2011
    Posts
    2

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Median Ifs, need to find median $ amount per deal for each year
    By xenomorph8472 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-13-2012, 02:01 PM
  2. Median If
    By fjboogert in forum Excel General
    Replies: 0
    Last Post: 05-09-2012, 09:27 AM
  3. [SOLVED] Median and If
    By esmcic in forum Excel General
    Replies: 5
    Last Post: 05-04-2012, 03:00 PM
  4. Median
    By tomribeiropereira in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 03-02-2011, 06:29 PM
  5. median
    By jlogan987 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2007, 11:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1