average percentage excluding zeros from several worksheets

[Brandy]

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!