Ask Your Question
1

sum does not give the correct answer part of the time. [closed]

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

Deskjocky gravatar image

updated 2020-08-02 14:28:10 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-20 19:11:01.247621

1 Answer

Sort by » oldest newest most voted
1

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

Question Tools

1 follower

Stats

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

Seen: 57 times

Last updated: Apr 14 '15