Excel is fussing because you’re not telling what cells to sum. You need a range of cells in your formula. Instead of =SUM (), you need something like =SUM (N2:. N20) or whatever your range is.
Have done the following: Click on cell to show total., click auto Sum > cursor through the row of cells to be added. Press Enter and this formula comes into the cell instead of the total of the numbers in the cells.
Periodically, you may encounter numbers in Excel that you can’t sum or use arithmetically. A common cause for this is numbers formatted as text. Often, reports exported from other programs, such as an accounting package, will be formatted as text or they might contain embedded spaces.
How to fix numbers that don’t add up in Excel?
How to Fix Excel Numbers That Don’t Add Up To fix numbers that are seen as text, follow these steps: Right-click a blank cell, and click Copy Select the cells that contain the “text” numbers.
How do I add a sum to a cell in Excel?
Have just set up a brand new spreadsheet with lots of cells to add. Have done the following: Click on cell to show total. , click auto Sum > cursor through the row of cells to be added. Press Enter and this formula comes into the cell instead of the total of the numbers in the cells.
Is it impossible to sum numbers in Excel?
Re: Impossible to sum numbers in Excel 1 Go to Data Tab. 2 Click on Text to Columns and click on Finish in the next window which pops up which is Text to Columns wizard window.
One idea is that Put a 1 in a spare cell and select and copy that number. Select your numbers and then right click | paste special | select multiply and click OK and try your sum formula. If this response answers your question then please mark as answer. Was this reply helpful? Sorry this didn’t help. Thanks for your feedback.
Can I use Excel with autosum?
I’ve been using Excel with Auto. Sum for many years. Recently installed Office 365 and pre-existing spreadsheets are working as usual. Have just set up a brand new spreadsheet with lots of cells to add.
Why won’t the sum function work on a text?
But if you format a text as a NUMBER it will still be a text and the SUM function will not work. Say you have ” 10″ in A1. This a is a text. Try entering the formula =VALUE (A1) to make the text that looks like a number into a real number.