Thread: Averages
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
markmcd markmcd is offline
external usenet poster
 
Posts: 23
Default Averages

Could someone please advise me a nice simple formula for giving an average
for non zero entries. The average function in Excel provides an average of a
list of numbers including numbers that are zero. I need the average of just a
series of numbers where zeros are not considered in the result.