Basic sum function returns zero value

[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

 

[Andy Lev]

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

 

[Frank Kabel]

Hi
are you sure the values in F3:F8 are stored as numbers. what does the
formula
=ISNUMBER(F3)
return (it should return TRUE)

 

[Andy Lev]

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