I need help to get rid of #DIV/0! in a spreadsheet where I am using the following formula:
=AVERAGE(DF34,DI34,DL34,DO34,DR34,DU34,DX34)
If there are no numbers in the specified cells, this formula is returning the value of #DIV/0! and I would like to have it either be 0 or blank.
I have tried the IF and IFERROR function but am not placing this IF formula in the correct position to the =AVERAGE function.
Please HELP!!
Solved by T. Q. in 22 mins