I'm trying to average 4 columns on one worksheet c1:f1 but sometimes all
four cells have have a 0 %. This gives me a div/error which crosses over
to my summary worksheet . I would like E1 to be an average of these four
cells or a blank.

Can anyone help me?

Thank you
Deb