Help with finding a low, average, and high based on another cell range

[jp12687]

Hello,

looking for a calculation where in 3 different cells I can get a low, average, and high from a range.

It will be the Q column that has all the pricing

the E column will have a specifier/category separator

I want to be able to find the Low, Average, and High of Q based on the designator in E

An example of a designator would be the characters "3-4mm" so I'd want every row that has that in row E then have a cell that gives it Low, Average, and High

thanks!

[jeffreybrown]

How about...

Low =IFERROR(AGGREGATE(15,6,$Q$2:$Q$26/($E$2:$E$26="3-4mm"),1),"")
High =IFERROR(AGGREGATE(14,6,$Q$2:$Q$26/($E$2:$E$26="3-4mm"),1),"")
Average =AVERAGEIF($E$2:$E$26,"3-4mm",$Q$2:$Q$26)

[jp12687]

So the average one is working— the high/low seem to be returning empty cell....

[jeffreybrown]

Well on my test data it works. Can you share a sample that you are working with? Not a picture, a workbook please!

[jeffreybrown]

Please keep all correspondence on the forum.