Expert Solution - Excel SUM Problems

Question description:
This user has given permission to use the problem statement for this blog.

I want to know how to sum the data within the same cell. I know that there is the function name "Sum numbers in a cell", but I couldn't find it on the spreadsheet. thank you so much in advance :)

Solved by M. Q. in 32 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert 27/03/2018 - 07:42

Hi.

User 27/03/2018 - 07:42

Hi :)

Excelchat Expert 27/03/2018 - 07:43

May I help you about this?

User 27/03/2018 - 07:43

I would love to know how to sum the number in the same cell. Trying to find the function name "Sum numbers in a cell", but I couldn't find it on the spreadsheet

Excelchat Expert 27/03/2018 - 07:43

You can use the formula =SUM(range).

Excelchat Expert 27/03/2018 - 07:44

If you try MS EXCEL, try to click Formula tab.

Excelchat Expert 27/03/2018 - 07:45

Here on online excel does not support formula tab.

User 27/03/2018 - 07:45

Arr. I got your point

Excelchat Expert 27/03/2018 - 07:45

Select a blank cell adjacent to the cell you are going to sum numbers inside, type formula =SUMNUMS(A1) into the Formula Bar, and then press the Enter key

User 27/03/2018 - 07:45

Are there anyway I can make it by ant other function?

User 27/03/2018 - 07:47

Not really sure, Am I in the right track? Would you mind to show me how to sum the numbers I put in please?

User 27/03/2018 - 07:50

Hi, Are you still with me?

Excelchat Expert 27/03/2018 - 07:51

There is sum function that can sum each cells.

Excelchat Expert 27/03/2018 - 07:51

But it is new to me to have a single cell with number and space.

User 27/03/2018 - 07:51

Ar, I do uderstand

Excelchat Expert 27/03/2018 - 07:51

That has enable to sum or not?

Excelchat Expert 27/03/2018 - 07:51

However, Do you think there is a feature about this?

User 27/03/2018 - 07:52

I'm not really sure. Just done googling, there a function call "Sum numbers in a cell", but it is in MS excel. That's all I know

User 27/03/2018 - 07:53

Anyway, never tries it before in MS

Excelchat Expert 27/03/2018 - 07:53

=SUM(IF(ISERR(VALUE(MID(A2,ROW($A$1:OFFSET($A$1,LEN(A2)-1,0)),1))),0,VALUE(MID(A2,ROW($A$1:OFFSET($A$1,LEN(A2)-1,0)),1)))),

Excelchat Expert 27/03/2018 - 07:53

Upon google there is a way.

User 27/03/2018 - 07:54

=SUM(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))

User 27/03/2018 - 07:54

Some people talking about this on Goolgle

User 27/03/2018 - 07:54

but, I really have no idea

Excelchat Expert 27/03/2018 - 07:56

Really its part of VBA function.

Excelchat Expert 27/03/2018 - 07:56

Upon research this could be done by VBA.

Excelchat Expert 27/03/2018 - 07:57

Although it is not part of Excel tag question.

Excelchat Expert 27/03/2018 - 07:57

Still Take it.

Excelchat Expert 27/03/2018 - 07:57

Sorry for hear to this.

User 27/03/2018 - 07:58

So, there's no way to do this, right? What do you t hink?

Excelchat Expert 27/03/2018 - 07:59

As far I know that it can be split into other cells.

Excelchat Expert 27/03/2018 - 07:59

And use sum function.

Excelchat Expert 27/03/2018 - 07:59

Behind of it mabe it can be done on VBA

Excelchat Expert 27/03/2018 - 07:59

Maybe it can be done by VBA subject.

Excelchat Expert 27/03/2018 - 08:00

You may tag this question on VBA thanks.

Excelchat Expert 27/03/2018 - 08:00

To add multiple numbers in one cell you must use a vba for it.

User 27/03/2018 - 08:00

That's alright. :) Thank you so much. I will try on that

Excelchat Expert 27/03/2018 - 08:01

Although, VBA is not my subject as for now.

Excelchat Expert 27/03/2018 - 08:01

On expert subject there is excel, vba and maybe gotit will add other subject like SQL and Java.

User 27/03/2018 - 08:02

Arr Too complicated for me now. hahah

Excelchat Expert 27/03/2018 - 08:02

This is VBA.

Excelchat Expert 27/03/2018 - 08:02

Range("A1").function="=SUM(Range(Cells(2,1),Cells(3,2)))"

User 27/03/2018 - 08:02

Better to adjust these numbers to different cells

Excelchat Expert 27/03/2018 - 08:06

On VBA the excel has macro and it uses microsoft Visual basic.

User 27/03/2018 - 08:07

That's al right :) I will try to make it more simple by just move number into diff cell, then

Excelchat Expert 27/03/2018 - 08:08

It simply use SUM function on multiple cells.

User 27/03/2018 - 08:08

I'll go back to that way :)

Excelchat Expert 27/03/2018 - 08:08

With single value on each cell.

Excelchat Expert 27/03/2018 - 08:08

The alternative would be a VBA solution (User Defined Function), or a very complex formula.

Excelchat Expert 27/03/2018 - 08:09

Which you would like to use ?

Excelchat Expert 27/03/2018 - 08:09

Option Explicit Function AddMany(RG As Range) Dim dSUM As Double Dim vNums As Variant Dim C As Range Dim I As Long For Each C In RG vNums = Split(C.Text, vbLf) For I = 0 To UBound(vNums) dSUM = dSUM + --(vNums(I)) Next I Next C AddMany = dSUM End Function

User 27/03/2018 - 08:09

Actually, I would love to make it success by using VBA. However, if it's too much complcated, I will go back to simple way

Excelchat Expert 27/03/2018 - 08:10

Good.

Excelchat Expert 27/03/2018 - 08:10

Have a nice day buddy.

User 27/03/2018 - 08:10

Thanks alot!

Excelchat Expert 27/03/2018 - 08:10

The code tell that in each string

User 27/03/2018 - 08:10

You too. Nice to get your advice!

Excelchat Expert 27/03/2018 - 08:10

it separated by space.

User 27/03/2018 - 08:10

Arr

User 27/03/2018 - 08:10

Alright!

Excelchat Expert 27/03/2018 - 08:10

The variable array is filled

Excelchat Expert 27/03/2018 - 08:11

when it comes to the space it breaks and increment

Excelchat Expert 27/03/2018 - 08:11

the value of array.

Excelchat Expert 27/03/2018 - 08:11

for example

Excelchat Expert 27/03/2018 - 08:11

arr[3]

Excelchat Expert 27/03/2018 - 08:11

arr[0],arr[1], and arr[2].