Forum Discussion
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...
DoubleLLooms Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.
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?
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.
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.