View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jimmy O[_2_] Jimmy O[_2_] is offline
external usenet poster
 
Posts: 1
Default Calculating average of percentages

I have a column of percentage values some of which are zeros. I wish to
calculate an average of the percentage values but also wish to exclude all
zero values from the average formula but I'm not sure how to write an
argument to do this. Any help is appreciated.