OOPs.. I meant to say all four cells could on occasion be blank which gives
me a div/error . I would like answer in this case to also be a blank.

"ferde" wrote:

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