Ask Your Question
0

sum does not give the correct answer part of the time.

asked 2015-04-14 21:42:05 +0200

Deskjocky gravatar image

for example line B23 sum of B1 through B22. The correct answer might be 201 But instead it shows 175. Almost like it skips some the lines.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-04-14 23:22:04 +0200

m.a.riosv gravatar image

Please verify that those skipped values weren't introduced as text? Ctrl+F8 can help.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-04-14 21:42:05 +0200

Seen: 49 times

Last updated: Apr 14 '15