Ask Your Question

The formula is set to add about 70 cells, but the total comes to Zero, why? [closed]

asked 2013-08-11 15:04:14 +0200

akhan gravatar image

1256.23 1583.25 256.48 23.60 2.57

0 why is the total coming to 0, what is wrong?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-06 07:36:55.461910


I hope you understand that it is impossible to provide answer to such question. You mentioned 70 cells, but provided 5 numbers. You didn't say how did you try to sum these numbers... etc... The best thing is to upload somewhere example file and to put it here in comments.

Ljiljan gravatar imageLjiljan ( 2013-08-11 16:47:13 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-08-11 16:13:19 +0200

Pedro gravatar image

Maybe the values are formatted as text. What is the decimal separator for your country? Is it a point or a comma? If you share an example file it could help.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-08-11 15:04:14 +0200

Seen: 67 times

Last updated: Aug 11 '13