Problem with calculations

[Panda120]

Hey, I have a weird problem with summing/adding up. Instead of returning a value, a dash is returned (as if all the values are zero). I've even tried adding the cells individually, and the same happens. All the cells are in the same format (namely accounting). When adding then up individually I discovered that the two cells that were added after the others are the culprits, even though these two cells are still in the same format and I can't think of any possible reason why, if they are added to the total sum, a zero value is returned. Any suggestions?

 

[jtakw]

Hi,

Check for Text values in those problem cells.

Book1
	F	G	H	I
2	-	9	FALSE	TRUE
3	9.00	9	TRUE	FALSE
Sheet98

Cell Formulas
Range	Formula
H2	=ISNUMBER(G2)
H3	=ISNUMBER(G3)
I2	=ISTEXT(G2)
I3	=ISTEXT(G3)
F2	=SUM(G2)
F3	=SUM(G3)