Forum Discussion
mohome-_18
Mar 08, 2023Copper Contributor
excel formulas
im sorry to bother you, im new at this so please bear with me. i have a simple spread sheet with my income and outgoings in separate columns. Ive tried to autosum as per instructions, ie choose a cel...
HansVogelaar
Mar 08, 2023MVP
- Make sure that the cell with the SUM formula is not formatted as Text, but as General, Number. Currency or Accounting. If you have to change the number format to one of those, press F2 in the cell with the formula, then press Enter.
- Make sure that Show Formulas in the Formula Auditing group of the Formulas tab of the ribbon is not highlighted.