Home/ Questions/Q 5046
Next
In Process
Computing Staff
  • 0
Asked: 2021-11-12T09:42:41+00:00 In:

Add Multiple Numbers Within A Cell

  • 0

I am trying to add multiple numbers within a cell but show the work

example
A
40+20 This column I need to add the 2
in Column A together to show the sum or total of them in
Column B

–

example

Column 1 Heat Race Points
40+20
40+20+30+10
20

I need for the next Column to total these no matter if it is 1 number or 2 numbers or 3 numbers etc.

It can even do the following as long as I can total the last number that is the sum of the strings

example:

Column A
40+20+30=90

Is there a formula that would total just the 90 in the next column B
90 (formula to read the sum of column A)

I need the data all in 1 cell to show the points they receive for each heat and then a total of them in another cell.

I dont have to use a + sign if there is another way I am not that familat with text to columns.

The most important part is that all of the numbers showing their heats from left to right are in 1 cell but I need to total them in another. I hope that makes sense

Thanks

Share

    2 Answers

    1. Hi,
      One other idea:

      Place scores on one worksheet using standard numbers in single cells.
      On a second ‘Display’ worksheet used for displaying results create the single cell displays.

      If Sheet2 has this

      A B C D
      row 2 20 10 5 18

      In cell A2 on the ‘Display’ worksheet enter this:
      =Sheet2!A2&”+”&Sheet2;!B2&”+”&Sheet2;!C2&”+”&Sheet2;!D2

      which looks like this
      20+10+5+18

      In cell B2 on the ‘Display’ worksheet the total is shown with this formula:
      =SUM(Sheet2!A2:D2)
      Now you have the best of both worlds – results displayed in one cell and real numbers that you can use for the total and any other calculations.

      Regards

      • 0

    2. Hi,
      If your requirement is to have all results in one cell, could you instead have what looks like one cell, but is actually several cells.

      Have scores and + signs in a series of cells.
      Resize the columns making alternate columns just wide enough for the + signs and the columns with numbers, just wide enough for the largest number.
      Highlight all the cells and using Format Cells… Borders, Replace the vertical lines between cells with white lines so that they are invisible.
      Retain the horizontal lines and an outside border.

      The SUM function in the next column will work as normal, and the scores will appear to be in single cells.

      To enter + in a cell on its own precede it by a single quote ‘

      You will be able to use the numbers for other functions such as averages, maximums etc.

      Regards

      • 0