Forum Discussion
Solved
Need help with this error #DIV/0!
Hi, I am using AVERAGEIF to get a specific average in a particular group but I kept getting the error #DIV/0! using the excel application. But each time I use the excel browser, I get the outcome...
In column S you have texts like "$100", not numbers formatted as currency. Select column S, Ctrl+H and replace $ on nothing. It works. After that you may apply currency format to that column.
The DIV/0# error is simply telling you that there are no matches to your criterion. That may simply be a fact or there may be something wrong in your criterion range such as additional blanks or non-printing characters.
Appreciate your response Peter. Thank you!