Forum Discussion
robertreiffphotography
May 14, 2025Copper Contributor
AutoSum Not working
I am having trouble getting my autosum working in the newest Excel on Mac. I have researched here and tried I think all the obvious - the column is set as a numerical cell, the formula looks right, b...
HansVogelaar
May 15, 2025MVP
It looks like the cells have been formatted as Text. Make sure that the entire column is formatted as General or as Number.
Select A2:A56.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Finish.
Next, select F57. Press F2 then Enter to re-enter the formula.