View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brandy Brandy is offline
external usenet poster
 
Posts: 52
Default average percentage excluding zeros from several worksheets

Good afternoon,
I am trying to average margin percentages from several worksheets (one cell
per worksheet) into a summary worksheet. i have tried average, averagea, as
well as the average if array function. Particulary with the average if
array, I still receive an message "div/0" if one or more of the cells I am
trying to average has "div/0".

Is there an easier way to do this?

Thanks!