+ Reply to Thread
Results 1 to 3 of 3

Median with IF not working?

Hybrid View

  1. #1
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Median with IF not working?

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

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

    =MEDIAN(IF(B2:B16="Single Family",A2:A16))
    Entered as an Array - Ctrl+Shift+Enter.

    Hope this helps.
    DBY

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

    Re: Median with IF not working?

    DBY - Thank you very much. Solved!

+ Reply to Thread

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