**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.*