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


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