Forum Discussion
AVERAGE or SUM Formula returning 0
DoubleLLooms Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.
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?
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
This is what I see when I open the workbook:
Does the problem persist if you download the workbook and open it?
- 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?DoubleLLooms Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.