Forum Discussion
Removing DIV ERROR in a cell that has an AVERAGE formula already in it.
I have a survey with several questions in several sections. Responses are selected from a dropdown list (1-10). An average is calculated for each section Example: =AVERAGE(C20:C25). The problem is ...
Use IFERROR().
Search for examples and look at the help page if you are not sure how use it.