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!
Bookmarks