Percentile with IF statement

[mbriz]

I have a spreadsheet where I am calculating average GPA by month over the course of three years. The data is pulling from a table I have on another spreadsheet. I want to find the 25th percentile for each month. The formula i'm trying to use is:

=PERCENTILE.INC(IF(Table1[TERM_CODE_ENTRY]=A2,IF(Table1[APDC_DATE]"<"&B2)"","")Table1[HS_GPA],0.25)

If you all need more background info, please let me know. Thank you!

 

[mbriz]

To clarify, I have three terms with thousands of records, so it would be difficult to do a percentile formula for each month within the term. For example, I need to calculate the 25th percentile of students who are in term 2013, but also were accepted to the program by a specific date. For example, the average GPA for those who were accepted by 9/1/2012 for term 2013 was 3.45. Now I need the percentile formula so I can drag this formula down across terms and dates.

 

[AhoyNC]

Not sure how your actual data is set up, but maybe this will help you get the right syntax.
Only difference in the formulas below is the one in E2 has the date hard coded and the one in E5 looks to cell E4 for the date.
These are array formulas and must be entered with

Excel Workbook
	A	B	C	D	E	F
1	TERM_CODE_ENTRY	APDC_DATE	HS_GPA
2	2013	6/12/2012	4		3.3
3	2013	6/8/2012	3.8
4	2013	8/13/2012	3.4		9/1/2012
5	2013	7/22/2012	3.3		3.3
6	2013	8/26/2012	2.9
7	2014	7/9/2013	3.7
8	2014	5/29/2013	3.2
9	2014	6/1/2013	2.5
10	2014	8/13/2013	2.1
11	2014	8/14/2013	2.9
12	2014	6/14/2013	4
13
CTRL-SHIFT-ENTER.

 

[mbriz]

Perfect, that worked for me. Thank you so much!

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the forum.