## Forum Discussion

philip369

Dec 05, 2019Copper Contributor

# Impossible to sum numbers in Excel

I hope someone can help with this because I am pulling my hair out. When I try to sum numbers in a column, at the bottom of the page it gives me a count and not a sum. When I try to Autosum, it g...

HansVogelaar

MVP

Activate the Formulas tab of the ribbon and look at the Formula Auditing group.

You'll notice that the 'Show Formulas' button is highlighted.

Click this button to turn it off. You should now see the result of the formula.

philip369

Apr 27, 2023Copper Contributor

Thanks! That worked!!!

Now why is that the default?

Now why is that the default?

- HansVogelaarApr 27, 2023MVP
'Show Formulas' is off by default. Perhaps you turned it on by accident - the keyboard shortcut is Ctrl+`