+ Reply to Thread
Results 1 to 2 of 2

HELP -Is there a way to combine QUARTILE function with COUNTIFS that has multiple criteria

  1. #1
    Registered User
    Join Date
    01-25-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    HELP -Is there a way to combine QUARTILE function with COUNTIFS that has multiple criteria

    Good afternoon!

    I have been searching for a solution for the last couple of days. I have a excel file with 30+ headers with subsequent data to follow. The file I am working with has 6995 rows and using my COUNTIFS criteria (very extensive to paste - but my criteria works - using for other charts). I get the 475 who meet the criteria below (used PIVOT table to check my numbers - dead on). Of the 475 student that are now identified meeting the criteria, I now need to apply the QUARTILE function based on the Data from the SAT MATH, SAT READING and ACT COMP columns.

    Because I have not been able to figure out how to apply the two functions together, I'm currently using PIVOT tables to filter my criteria. Once I receive the output, I double click to retrieve and have a separate spreadsheet for only those students. I then use the QUARTILE function at the end of the columns to get my numbers which I then manually enter in my charts.

    Because I have to retrieve this data each term, I have begun the daunting task and have now created charts with embedded formulas to automate my processes. My processes are working perfectly except for this particular chart. HELP, HELP, HELP!!!! Or is there a different way to retrieve?

    Same of data attached. I have left the QUARTILE numbers and can be viewed at the end of the report.

    Is there a way to
    COUNTIFS CRITERIA
    1) Student is a First Time Freshman
    2) Student in a Traditional track
    3) Student in Term 12FALL
    4) Student either in a FT or PT capacity (NA's (blanks) not included)

    QUARTILE CRITERIA - The scores are based on the COUNTIFS CRITERIA
    1) SAT SCORE - MATH (25, 50, 75TH)
    2) SAT SCORE - READING (25, 50, 75TH)
    3) ACT ACORE - COMP (25, 50, 75TH)
    Attached Files Attached Files
    Last edited by cvercrus; 08-02-2013 at 11:36 AM. Reason: change title - Needing help vice appears I'm giving a solution

  2. #2
    Registered User
    Join Date
    01-25-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: HELP -Is there a way to combine QUARTILE function with COUNTIFS that has multiple crit

    I was able to solve my problem. I used the following QUARTILE.INC with nested IF statements with specific criteria. I realized that I wasn't trying to count the criteria but simply filter using my needed criteria.

    =QUARTILE.INC(IF('ADM U2012-F2012'!D:D="12FALL",IF('ADM U2012-F2012'!I:I="FF",IF('ADM U2012-F2012'!H:H="TU",IF('ADM U2012-F2012'!BJ:BJ>0,'ADM U2012-F2012'!BJ:BJ)))),1)

+ 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. Replies: 4
    Last Post: 03-30-2013, 08:36 AM
  2. Multiple criteria arrays in countifs function resulting in incorrect answer
    By laurenmoney in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-28-2013, 12:57 PM
  3. [SOLVED] Countifs function with multiple criteria in same column
    By sam99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2012, 09:10 AM
  4. Replies: 3
    Last Post: 06-01-2012, 02:06 PM
  5. Quartile Across Multiple sheets Given Criteria
    By ben10 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-28-2011, 01:25 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