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.