Submit
Improve company productivity with a Business Account.Sign Up
=PERCENTILE.INC(IF(A2:A5<>0,A2:A5),0.99)
Select all Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
We will never share this with anyone. Privacy Policy
Must be at least 4 characters long.
Join and Comment
By clicking you are agreeing to Experts Exchange's Terms of Use.
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.
Perhaps Rgonzo's suggestion will work for you but I think it only gives you the cutoff point. If you want to sum everything above that point as you say then you need to use the percentile within a SUMIF fomula, e.g. if data is in A2:A1000 try
=SUMIF(A2:A1000,">="&PERCE
confirmed with CTRL+SHIFT+ENTER
That assumes you want to exclude zeroes from the calculation.....but you didn't say that, so if zeroes should be included it's just
=SUMIF(A2:A1000,">="&PERCE
which can be entered normally
regards, barry