Forum Discussion

DoubleLLooms's avatar
DoubleLLooms
Copper Contributor
Jul 07, 2024
Solved

AVERAGE or SUM Formula returning 0

Hi, I have Excel on Mac and been struggling with a simple AVERAGE and SUM formula which keeps returning 0. I checked the data types, checked for texts with no luck. I notice the formula builder retu...
excel
Excel on Mac
Formulas and Functions
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Jul 07, 2024

    DoubleLLooms Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.

HansVogelaar's avatar
HansVogelaar
MVP
Jul 07, 2024

DoubleLLooms 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

  • DoubleLLooms's avatar
    DoubleLLooms
    Copper Contributor
    Jul 07, 2024

    HansVogelaar 

     

    thanks for reaching out.

    its actually a publically available spreadsheet from a YouTube channel so its fine.

    i do wonder if it could be a local setting causing the issue.

    so in the spreadsheet, theres the main 'Data' sheet and then a Sheet2 where i was hoping to practice in but not getting anywhere when simple formulas aren't working. i have copied it into my onedrive and the link below.

     

    https://1drv.ms/x/s!ApjTGnOwWzLEhg7v2KQBfhLRRt9i?e=cMuvRe 

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jul 07, 2024

      DoubleLLooms 

      This is what I see when I open the workbook:

      Does the problem persist if you download the workbook and open it?

      • DoubleLLooms's avatar
        DoubleLLooms
        Copper Contributor
        Jul 07, 2024
        HansVogelaar

        i saw this too.. on excel online. its the exact same workbook i have locally.. could it be something in the excel setting on my mac then?

Resources