Removing #DIV/O! when completing an average

[Lwamp]

I have attached a sample workbook, as you can tell I am coming up with a Div0 on the lines that don't have data enter yet. I am wanting the line to just come up blank if the average can't be completed.

[Phuocam]

Try this:

=IFERROR( Your formula,"")

[Lwamp]

I've tried that but can't get it to work since I'm trying to average cells J2 and P2 into cell D2.

[Sam Capricci]

change your formula in C1 to this =IFERROR(SUM(D2/1.46),0) then copy down. that'll get rid of the div/0 error.
also change your formula in D1 to this... =IFERROR(AVERAGE(P2,J2),"") or this =IFERROR(AVERAGE(P2,J2),0) too.

[Sam Capricci]

Thank you for the rep!