Forum Discussion

sanggu_'s avatar
sanggu_
Copper Contributor
Oct 11, 2024
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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 11, 2024

    sanggu_ 

    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.

chjenssxu's avatar
chjenssxu
Copper Contributor
Oct 11, 2024
Change your formula into the following one:
=AVERAGEIF(S2:S89,G2:G89,"Youth (<25)")

Have a try.
sanggu_'s avatar
sanggu_
Copper Contributor
Oct 11, 2024
Thank you! It didn't work for me but it's fine. I think the file it self has a problem. Since the same functions works using different data files except that one file.

Resources