Results 1 to 3 of 3

Conditional Median Formula

Threaded View

mcfarcry Conditional Median Formula 09-13-2011, 03:52 PM
daddylonglegs Re: Conditional Median Formula 09-13-2011, 04:04 PM
mcfarcry Re: Conditional Median Formula 09-14-2011, 08:43 AM
  1. #1
    Registered User
    Join Date
    10-13-2010
    Location
    New Hampshire
    MS-Off Ver
    Excel 2010
    Posts
    11

    Conditional Median Formula

    I have two columns of data for 1,472 data samples: Column A has numerical identifiers for job types and those numbers are 1 through 29. Column B has elapse times to complete those ID #'s in Column A. I have a table set up with 29 rows for each of the Job ID, 1 through 29 and those ID's are in column A. In the same table in column B, I've placed a conditional median formula that SHOULD calc the median time for each Job ID found in the data table of 1,472 entries. Here's the formula I'm using which I actually found here in another thread:

    =MEDIAN(IF((DATA!$A:$A=1),DATA!$B:$B))

    Unfortunately, I get zero values for all the Job ID numbers. All number formats are correct.

    What am I doing wrong?
    Last edited by mcfarcry; 09-14-2011 at 08:49 AM.

Thread Information

Users Browsing this Thread

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

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