Excel formula result 0

  • Thread starter Thread starter Leelo
  • Start date Start date
L

Leelo

I am trying to add a column figures I am entering =Sum(B5:B52) and getting a
0 result. Can anyone help?
 
The usual problem is that the "numbers" are actually Text and SUM() treats
them as zero.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-demensional frequency distribution 4
Cell address in a range 7
Move and reset valuse using a command Button 1
help copying formulas 1
IF Statement (AND/OR) 2
Formula result showing 0 3
Cell ranges 1
Excel help INDEX MATCH w/ division and subtraction 0

Back
Top