Using Average IF formula for eliminating the #DIV/O error.

[andersonsma]

Issue: I have five columns , cell: C2, D2, E2, F2, G2, with percentages. Average (C2:G2) to get that % average, but if all cells are blank , Excel returns #DIV/0 error. I would like Excel to return 0% , if all cells are blank.
What is this formula?

[jason.b75]

Try

=IFERROR(AVERAGE(C2:G2),0)

[andersonsma]

that works! Thanks :-)