Results 1 to 10 of 10

Using Median IF to calculate the median for a specific criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-23-2013
    Location
    La Crosse, Wi
    MS-Off Ver
    Excel 2010
    Posts
    113

    Using Median IF to calculate the median for a specific criteria

    I have two columns of values (ONI - Column D and Temps - Column E). I need to calculate the median of Temps when the ONI is in the 0.5 and 0.9 range, 1.0 and 1.4 range, and 1.5 and greater. Below is the formula that I am using to calculate the median temperature when the ONI is in the 0.5 and 0.9 range.

    =MEDIAN(IF(($D$5:$D$26>=0.5*($D$5:$D$26<=0.9)),$E$5:$E$26))

    It is producing differing values than if I just manually calculate the median for these cells.

    =MEDIAN(E5:E14)

    What am I doing wrong in my first formula?

    Thanks for any help!
    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] calculate a MEDIAN using multiple criteria?
    By MetricsShiva in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  2. calculate a MEDIAN using multiple criteria?
    By MetricsShiva in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 09:05 AM
  3. [SOLVED] calculate a MEDIAN using multiple criteria?
    By MetricsShiva in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  4. calculate a MEDIAN using multiple criteria?
    By MetricsShiva in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  5. [SOLVED] calculate a MEDIAN using multiple criteria?
    By MetricsShiva in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-19-2005, 12:05 PM

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