=if(c7=0,"",if(iserror(average(h7:h11)),"",average (h7:h11)))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"japc90" escreveu:

=IF(C7=0,"",AVERAGE(H7:H11))

This formula is not working and I am not sure what I am doing wrong. I
want the cell to remain blank and not show an error message when the
related cells are blank. It is blank when the other cells are empty but
it stays blank even when I enter values into the other cells.

Probably a simple fix but I can't get it to work.

All help is appreciated. Thank you.