I think I need an array formula for this, but I haven't been able to figure that part out.
Example: column A has whole number values, column B has percents.
My equation is: =AverageIf(A6:A50,">"&Percentile(B6:B50,0.9))
I'm trying to take the top 10th percentile of the percentage column and return the average of the whole number column, but if the whole number has an N/A then I get the Div/0 error. How do I fix this?
Second Question: column A has whole numbers, column B has percents, column C has word values (Cat, Dog, Bird)
How do I write an equation that will only return the average of column A for only the top 10th percentile (from column B) and only include Cats?
Example: column A has whole number values, column B has percents.
My equation is: =AverageIf(A6:A50,">"&Percentile(B6:B50,0.9))
I'm trying to take the top 10th percentile of the percentage column and return the average of the whole number column, but if the whole number has an N/A then I get the Div/0 error. How do I fix this?
Second Question: column A has whole numbers, column B has percents, column C has word values (Cat, Dog, Bird)
How do I write an equation that will only return the average of column A for only the top 10th percentile (from column B) and only include Cats?