Quartile Calculation Based on Category

[TeamOSupremeO]

I have read several other posts on this topic, but am still stuck.

I have about 8000 rows of data with columns A-O providing data elements for each row. I'd like to calculate the quartiles for Column J, but do so based on the field that is located in Column O. Column O has 6 different categories, and I would like to have quartiles for each category.

Ideally, I'd like to have a summary page that shows the quartiles for each category.

Here is the array formula I have tried, which has returned #N/A. In this example, I am looking for the 3rd quartile of the "Texas" category.

{=QUARTILE(IF('MASTER'!O2:O8000="Texas",'MASTER'!J2:J8000),3)}

Thank you!

 

[DRSteele]

Welcome to the forum.

Your column J must have a formula reporting an error. This mock-up works just fine.

Book1
	H	I	J	K	L	M	N	O
1	68.5		jay					oh
2								tobasco
3			68					texas
4			36					texas
5			61					texas
6								texas
7			83					texas
8			78					texas
9			22					tobasco
10			30
11			FALSE					texas
12			69					texas
13			24					3
14			17					texas
15			pepper					texas
16			26					texas
17			90
18			30					texas
19			61					texas
20			45					TRUE
master

Cell Formulas
Range	Formula
H1	{=QUARTILE(IF(O2:O20="texas",J2:J20),3)}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[TeamOSupremeO]

Thank you, DRSteele. Yes, that is accurate. I had several #N/A values in my column O. I converted all #N/As to "Not Valid" text and the formula worked just fine.

Kind regards!

 

[DRSteele]

Thuper. You're welcome.