Basic sum function returns zero value

  • Thread starter Thread starter Andy Lev
  • Start date Start date
A

Andy Lev

Hello all.

This one is very frustrating!

I'm just trying to do a very basic sum: =SUM(f3:f8), but I can't ge
the result to display anything other than zero (and it certainl
shouldn't be zero).

I've tried all the obvious solutions (checking cell formats, updatin
the worksheet, changing calculation options, etc.) but nothing seems t
work.

Does this sound like a glitch or am I just being stupid?!

Thanks in advance
 
Thanks for looking, but I've found a solution.

I was just being stupid. I rechecked the values in the range and the
all have a space before the first character which when delete
rectifies the problem.

I have no idea where the space came from
 
Hi
are you sure the values in F3:F8 are stored as numbers. what does the
formula
=ISNUMBER(F3)
return (it should return TRUE)
 
Thanks for your post Frank.

The formula you suggested does return true.

The original data was from a multiple response table in an SPSS outpu
file- I think the default formatting has something to do with th
unwanted space.

Cheers again
 
Back
Top