Forum Discussion
DoubleLLooms
Jul 07, 2024Copper Contributor
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...
- Jul 07, 2024
DoubleLLooms Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.
HansVogelaar
Jul 07, 2024MVP
This is what I see when I open the workbook:
Does the problem persist if you download the workbook and open it?
DoubleLLooms
Jul 07, 2024Copper Contributor
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?
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?
- HansVogelaarJul 07, 2024MVP
DoubleLLooms Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.
- DoubleLLoomsJul 07, 2024Copper Contributor
you're a LEGEND! it was set to "automatic" but when i changed it to "automatic except for data tables" the formula results appeared 🙂 - dont know why considering the raw data is in a table.
thank you.