Hi

I have used the following to get the average value from a set of data whilst
ignoring zero values within the data set.

=SUM(K4:AP4)/COUNTIF(K4:AP4,"0")

I would like to use the percentile command on the same set of data. Is there
a way that I can use Percentile and also ignore zero values ?
Many Thanks
Chris