Excel formula result 0

L

Leelo

I am trying to add a column figures I am entering =Sum(B5:B52) and getting a
0 result. Can anyone help?
 
G

Gary''s Student

The usual problem is that the "numbers" are actually Text and SUM() treats
them as zero.
 
P

PCLIVE

Chances are that what looks like numbers...are actually text. Test one of
the cells that appears to have a number in it.
To test B11:

=ISNUMBER(B11)

Returns True if B1 is a number and False if it is not.

HTH,
Paul
 
Top