Average of top 25% answers

Hi everyone!

I have trouble finding a formula to find the average of the top 25% and top 75% answers for several columns of data.

I have a sample of averages in a column, where some of the answers are 0 and the amount of answers varies. Therefor I need a formula which I can use for every column.

For example I want to find the average of the top 25% answers in the area of I4 to I32:

I have tried the formula =AVERAGE.IF(I4:I32;">"&QUARTILE(I4:I32;3)), the formula works but I get #DIVISION/0! error.

Do you guys have any suggestions to solve this?

Thank you in advance!

try
=AVERAGE(INDEX(LARGE($C$3:$C$31,ROW(INDIRECT("1:"&CEILING(COUNT($C$3:$C$31)*25%,1)))),0))
=AVERAGE(INDEX(LARGE($C$3:$C$31,ROW(INDIRECT("1:"&CEILING(COUNT($C$3:$C$31)*75%,1)))),0))

if you do it manually also you can get the same answer - as the top 75% are 100