Thanks for the help these reply's fixed the problem.

Ken.

Hi All,
I have a formula that gives the correct result but has an error in the
cell before any data has been entered into the other cells.
Formula: =AVERAGE(F43:G43)
Error: #DIV/0!
How can I eliminate this error please.

Thank you for your assistance.

Ken.