How to add or add numbers in one cell in Excel?

  1. Sum the numbers in the same cell with the user function
  2. Easily sum up numbers in one cell in just a few clicks
  3. Easily sum up numbers in one cell with Kutools for Excel
  4. Recommended tools for improving productivity in Excel
  5. Provides viewing and editing using tabs in Microsoft Office, much more powerful than browser tabs

In many cases, you may need to sum all the numbers in a single cell. For example, in cell A1 there is a text string Class 2 Grade 1, and the result of adding these numbers is 1 + 2 = 3. In this article, the methods of adding numbers to one cell with detailed information will be shown.

Sum the numbers in the same cell with the user function

Easily sum up numbers in one cell in just a few clicks

You may be interested in:

Simple division / separation of text lines into separate columns of text and numbers in Excel

click Kutools > Text > Split cells , Kutools for Excel 's Split Cell utility helps you easily split a text string column into separate text columns and numbers in Excel. See Screenshot below:

Kutools for Excel includes more convenient Excel 300 tools. Free, without restrictions, in 60-days. Read more Download free trial

Read more   Download free trial

Sum the numbers in the same cell with the user function

You can sum up numbers in a single cell using a custom function.

1. Click another + F11 to open the Microsoft Visual Basic Application window.

2. In the Microsoft Visual Basic Application window, click Insert > Module , then copy and paste the code below the module window.

VBA: sums of numbers in one cell

Function SumNums (pWorkRng As Range, Optional xDelim As String = "") + VBA.Val (arr (xIndex)) Next End Function

3. After inserting the code, click another + Q to close the Microsoft Visual Basic application window.

4. Select the empty cell next to the cell in which you are going to sum the numbers inside, enter the formula = SUMNUMS (A1) in the Formula Bar , and then press enter key.

5. After getting the result of the first cell, if your cells are continuous, drag the Fill pointer into the cell to cover this formula.

Note. This user-defined function cannot take effect for a number-format cell.

Easily sum up numbers in one cell in just a few clicks

Kutools for Excel Author The commonly used formulas function collects the formula for adding numbers to a single cell. You can easily sum up numbers in one cell (including a cell of a cellular format and a cell of a format of number), without forgetting any formula.

Kutools for Excel : with over 300 handy Excel add-ins, try for free without any restrictions on the 60th day .

1. Select an empty cell to determine the result of the summation. Then click Kutools > Formula Helper > Numbers of amounts in a cell . See screenshot:

2. In the Formula Assistant in the dialog box, enter the address of the cell that contains the numbers you want to add in the Cell or click 2 to select a cell directly, and then click OK , see screen shot:

3. Then you get the result of the specified cell. Drag the fill handle to the cell to get all the results.

Easily sum up numbers in one cell with Kutools for Excel

Kutools for Excel includes more convenient Excel 300 tools. Free, without restrictions, in 60-days. Download the free trial now!

Recommended tools for improving productivity in Excel

Kutools for Excel helps you always shut down ahead of time and stand out from the crowd

  • More than the powerful 300 advanced features designed for 1500 working scenarios, increasing productivity by 70%, give you more time to take care of your family and enjoy life.
  • You no longer need to memorize VBA formulas and codes, give your brain a break.
  • Become an Excel expert in minutes 3. Complex and repetitive operations can be completed in seconds,
  • Reduce thousands of keyboard and mouse operations daily, say goodbye to occupational diseases now.
  • Highly efficient people 110,000 and the choice of world famous companies 300 +.
  • 60-day full featured free trial. 60 day money back guarantee. 2 years of free updates and support.

Provides viewing and editing using tabs in Microsoft Office, much more powerful than browser tabs

  • The Office tab is designed for Word, Excel, PowerPoint, and other Office applications: Publisher, Access, Visio, and Project.
  • Open and create multiple documents in new tabs of the same window, and not in new windows.
  • Increases your productivity by 50% and reduces hundreds of mouse clicks for you every day!