Percentile with mulitple criteria

[muziq2]

Hi,

I'm actually trying to find the 25th, 50th and 75th percentile for
large list. However I need to have it broken out by sex and race.
have the race in one column, the sex in another.

I've tried this formula,

percentile(if(e2:e494="M")*(d2:d494=0),f2:f494),.5)

In the above 0 would be an example race code.

However this formula only picks up the first criteria.

I also need to find the Max, Min and Average of the same subsets. I'
assuming the formulas will be similar. I've only been able to coun
the subsets using the sumproduct formula.

Any help would be greatly appreciated.

Thanks,

Jef

 

[Bernard Liengme]

Slight syntax error: percentile(if( (e2:e494="M")*(d2:d494=0)
,f2:f494),.5)
Each"test" needs to be in parentheses
And remember to enter with SHIFT+CTRL+ENTER
This worked for me on a small dataset

 

[muziq2]

Works like a charm now.

Thanks