I need help to get rid of #DIV/0! in a spreadsheet where I am using the following formula:
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.
Solved by T. Q. in 22 mins