I have created a spreadshhet and in one column I can enter data and the
"total" is automatically populated as an AVERAGE for the week's stats. It
works fine when I input the data. But when it is left blank (e.g. the column
for Thursday 14, for which I have no data yet) the following text appears in
the Average cell: "#DIV/0!" (without the quotation marks).

Can I hide or delete this so that it looks blank until data is entered
without removing the formula?

Thank you,

Rob,
Teesside,
UK