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.

Hi, I am trying to get a sum of three separate cells in excel by typing "=H45+H23+H37"...and eventhough only one of the cells shows "0.00", and the remaining two cells have positive balance, the result I get is "0.00".................
Solved by K. L. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/05/2018 - 11:33
Hello
User 10/05/2018 - 11:33
Hi
Excelchat Expert 10/05/2018 - 11:33
So, you are not getting the desired result in SUM operation. right?
User 10/05/2018 - 11:34
right, it comes back with zero...
User 10/05/2018 - 11:35
when I add the two cells that both have positive balance, it adds them up....but as soon as I try to add the third cell, which has 0.00 it brings up 0.00 as the result...
Excelchat Expert 10/05/2018 - 11:35
Okay, may I see the file? It can happen if the values you are trying to sum are not formatted as number.
Excelchat Expert 10/05/2018 - 11:35
Okay, then it is not formatting issue.
User 10/05/2018 - 11:35
sorry I cannot show you the file
Excelchat Expert 10/05/2018 - 11:35
I understand. Al least you can show me the data in question, right?
User 10/05/2018 - 11:36
checked- everything formatted as a number
Excelchat Expert 10/05/2018 - 11:36
Would you be able to copy paste the values in the preview window?
User 10/05/2018 - 11:38
I do not have access to the preview window
User 10/05/2018 - 11:38
website access denied- that's what I see
Excelchat Expert 10/05/2018 - 11:38
Please refresh your browser window.
User 10/05/2018 - 11:38
it has been blocked by my employer, refreshing won't do anything
Excelchat Expert 10/05/2018 - 11:39
That is a problem.
Excelchat Expert 10/05/2018 - 11:39
So, since you can't share the file, we have to do it by trial and error method.
User 10/05/2018 - 11:39
thanks
Excelchat Expert 10/05/2018 - 11:39
Is that going to be a problem?
Excelchat Expert 10/05/2018 - 11:40
Okay. So, tell me how many cells you are trying to sum? only those 3 or there are more?
User 10/05/2018 - 11:41
3
User 10/05/2018 - 11:41
first cell is a sum of 2 other cells...
User 10/05/2018 - 11:41
2nd cell is a sum for another 3 cells..
User 10/05/2018 - 11:41
and then 3rd cell the same- is a sum of other cells
Excelchat Expert 10/05/2018 - 11:41
okay.
User 10/05/2018 - 11:42
I need to see a total sum of those 3 cells
User 10/05/2018 - 11:42
each of them is formatted as number
Excelchat Expert 10/05/2018 - 11:42
understood.
Excelchat Expert 10/05/2018 - 11:42
So, we will do the sum with the help of IF function.
Excelchat Expert 10/05/2018 - 11:43
=IF(H45=0,0,H45)+IF(H23=0,0,H23)+IF(H37=0,0,H37)
Excelchat Expert 10/05/2018 - 11:43
Please try this.
User 10/05/2018 - 11:44
unfortunately...didn't change anything
Excelchat Expert 10/05/2018 - 11:44
Do you see an error message?
User 10/05/2018 - 11:44
no
User 10/05/2018 - 11:45
0.00
User 10/05/2018 - 11:45
just like before
Excelchat Expert 10/05/2018 - 11:45
There might be a circular dependency. Please tell me which other cells are being added to these cells.
User 10/05/2018 - 11:46
I tried to add those 3 cells and get the result in other cells but they also give me 0.00
User 10/05/2018 - 11:46
H23 =SUM(H21:H22)
User 10/05/2018 - 11:46
H37 =SUM(H34:H36)
User 10/05/2018 - 11:46
H45 =SUM(H40:H44)
Excelchat Expert 10/05/2018 - 11:47
Nothing wrong here.
User 10/05/2018 - 11:47
Ok, I changed the formula in H37
User 10/05/2018 - 11:48
to =H34+H35+H36
User 10/05/2018 - 11:48
and now my result finally works!
User 10/05/2018 - 11:48
It works with the formula I got from you
User 10/05/2018 - 11:48
=IF(H45=0,0,H45)+IF(H23=0,0,H23)+IF(H37=0,0,H37)
Excelchat Expert 10/05/2018 - 11:48
wow, I was seating over it.
User 10/05/2018 - 11:49
thanks for your time and effort
User 10/05/2018 - 11:49
are you based in states?
Excelchat Expert 10/05/2018 - 11:49
I'm happy that I was able to give you a solution.
Excelchat Expert 10/05/2018 - 11:49
No, I'm from another country.
Excelchat Expert 10/05/2018 - 11:49
anything else?
User 10/05/2018 - 11:50
no, thanks, was just curious
User 10/05/2018 - 11:50
sorry...
Excelchat Expert 10/05/2018 - 11:50
not a problem.
Excelchat Expert 10/05/2018 - 11:50
The session will end in 2 minutes.
Excelchat Expert 10/05/2018 - 11:50
A 5 star rating will be much appreciated.
User 10/05/2018 - 11:50
No, I will end it now, thanks.
Excelchat Expert 10/05/2018 - 11:50
Thanks.
Excelchat Expert 10/05/2018 - 11:50
Have a great day ahead!

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