Aggregate Function - Multiple Criteria

[ExcelKid_10]

Hello-

I am just starting to use the Aggregate Function and encountering some problems. I have a table in Excel that I am using as my data source from which I am selecting using 3 string values as criteria in my aggregation. I have been able to get percentiles calculated using aggregate but cannot get my Max/Min/Count to work using the same criteria. I have done plenty of searches and have come up blank so wondering if someone could take a look at my formula and let me know what I am doing wrong.

These ones work:
75th Percentile:
AGGREGATE(17,6,IndexData[Yield to Worst]/((IndexData[Sector Level 4]=$B$2)*(IndexData[Composite Rating]=$A4)*(IndexData[MatBucket]=$B$1)),3)

25th Percentile:
AGGREGATE(17,6,IndexData[Yield to Worst]/((IndexData[Sector Level 4]=$B$2)*(IndexData[Composite Rating]=$A4)*(IndexData[MatBucket]=$B$1)),1)

However, these ones do not and I get a #VALUE!
Count:
AGGREGATE(2,6,IndexData[Yield to Worst]/((IndexData[Sector Level 4]=$B$2)*(IndexData[Composite Rating]=$A4)*(IndexData[MatBucket]=$B$1)))

Max:
AGGREGATE(4,6,IndexData[Yield to Worst]/(IndexData[Sector Level 4]=$B$2)*(IndexData[Composite Rating]=$A4)*(IndexData[MatBucket]=$B$1))

Min:
AGGREGATE(5,6,IndexData[Yield to Worst]/((IndexData[Sector Level 4]=$B$2)*(IndexData[Composite Rating]=$A4)*(IndexData[MatBucket]=$B$1)))

Thanks in Advance for your help!
EK

 

[des.lavender]

I know this is very old but I just managed to work around the issue with MAX.

This is what I did, using the LARGE function:

=AGGREGATE(14,6,(K4:K12)/((LEFT(C4:C12,2)="LD")+(C4:C12="RAT")),1)</SPAN>

I hope this might prove useful to someone else who's been tearing their hair out!!!