Results 1 to 4 of 4

MEDIAN with IF function not working

Threaded View

  1. #1
    Registered User
    Join Date
    02-28-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    MEDIAN with IF function not working

    Hey guys, new here. Visited a lot, but just joined and this is my first post.

    I'm using this formula in several columns of a cross-tab, and it seems to be working in most, but not a couple.

    So this works: {=MEDIAN(IF(working!O:O>3,working!E:E))}
    Yet this doesn't: {=MEDIAN(IF(working!O:O<4,working!E:E))}

    And yes, there are results that meet that IF requirement. Workbook is attached. Help is appreciated.
    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 with IF not working?
    By chriskopf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2013, 02:59 PM
  2. [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
  3. median if function
    By jlogan987 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2007, 12:24 PM
  4. median function
    By flyingmeatball in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-17-2006, 12:58 PM
  5. median function
    By flyingmeatball in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-17-2006, 11:40 AM

Tags for this Thread

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