I'm using SUM function and it returns 0.8128100I don't understand why is it happening.

Your numbers are not numbers but text and SUM() ignores text.Check with ISNUMBER() or ISTEXT().

Seems you are working with text, so you need to change them to numbers.Change the text to number by changing the cell format to number, or use the function Value( )

Forum Discussion

AntonioCamacho1964

Copper Contributor

Apr 13, 2022

SUM function gives null result

I'm using SUM function and it returns 0.

I don't understand why is it happening.

Formulas and Functions

2 Replies

Jihad Al-Jarady
MCT
Apr 14, 2022
Seems you are working with text, so you need to change them to numbers.
Change the text to number by changing the cell format to number, or use the function Value( )
Detlef_Lewin
Silver Contributor
Apr 14, 2022
Your numbers are not numbers but text and SUM() ignores text.
Check with ISNUMBER() or ISTEXT().