Using this formula in Z33: =AVERAGE(N33:Y33)
It returns #DIV/0! when N33:Y33 have no entries
I have tried ISERROR & IFERROR at the beginning of the formula but that just flags up an error message
How would I formulate this to eliminate #DIV/0! and show either a blank or a zero in Z32.
Thanks
Bookmarks