All solutions SUM Expert Solution – Excel SUM Problems

Excel - SUM Function Problem - Expert Solution

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].
Excelchat Expert 27/03/2018 - 08:12
when space detected the if condition tell to break .
Excelchat Expert 27/03/2018 - 08:12
20 50 20
Excelchat Expert 27/03/2018 - 08:12
something like that.
Excelchat Expert 27/03/2018 - 08:12
or you can do is just split it .
Excelchat Expert 27/03/2018 - 08:12
Filled value on each cells.
Excelchat Expert 27/03/2018 - 08:13
Then use =SUM(number1..).
Excelchat Expert 27/03/2018 - 08:13
:)
User 27/03/2018 - 08:13
Umm I will try my best. :) For my learning as well in this case
User 27/03/2018 - 08:13
Thanks s lot!
Excelchat Expert 27/03/2018 - 08:13
Good luck.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc