#DIV/0! problem

[Shustarful]

I`m running an mean from excel,where is equal to zero there comes this (#DIV/0!)this is the formula that i`m using,so how do i get rid of this,i`m using office 2010 please help guyz=AVERAGEIFS(DATA!$AG:$AG,DATA!$AX:$AX,5,DATA!$AW:$AW,$B$1,DATA!$AW:$AW,$A$4)

[jason.b75]

=iferror(AVERAGEIFS(DATA!$AG:$AG,DATA!$AX:$AX,5,DATA!$AW:$AW,$B$1,DATA!$AW:$AW,$A$4),0)

[dilipandey]

Hi Shustarful,

Welcome to the forum.

you can use iferror function here like:-

=iferror(<your formula>,"")

this will fetch the blank in case the formula output is an error.

If you data source itself has errors and zeros, then that may be a different case which I think is not related here.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Shustarful]

Thanks a lot it does work but what if i want it to be blank when equal to zero

[Pepe Le Mokko]

Replace 0 with " "