HOW TO REMOVE #DIVIDE BY ZERO AND MAKE CELL BLANK

08/02/19 Edited 12/09/19

I am trying to average a customer feedback section of my sheet.  But if the cells where the data to be averaged will come from, the result section shows #Divide by Zero.  I use the formula =AVG([column1:column2]).  What's the formula I need to use for this?  I saw in the other community discussion that I can use IFERROR but I don't know how to place it in the formula.

Please refer to below screenshot.

Thanks in advance for the answer.

AVG problem.PNG

Comments

Sign In or Register to comment.