Average, avoid column or cells where error

Hi

It would have helped if you had uploaded the workbook rather than a picture (as per the advice in the forum rules), pictures are rarely much use to us.

What I meant was, with the formula that is returning DIV/0! or indeed any other error result, put the formula in an =IFERROR() function.

i.e. =IFERROR(your_formula,"")