C
Chris26
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
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