I'm getting incorrect sum when adding numbers using sum function

asked 2017-11-14 17:45:01 +0100

Genki gravatar image

updated 2017-11-14 17:54:06 +0100

b2 through b5 are numbers. B6 contains formula =sum(b2,b3,b4,b5). Result in B6 does not equal the sum of b2:b5.

Also tried =sum(b2:b5)

edit: two of the cells show black when I turn on value highlighting. But there is no apostrophe in front of the value in those cells.

edit retag flag offensive close merge delete

Comments

You have answered your own question; it would seem that some cells are formatted as text and thus won't be included in the result of your SUM function.

robleyd gravatar imagerobleyd ( 2017-11-14 23:13:28 +0100 )edit