Forum Discussion
AntonioCamacho1964
Apr 13, 2022Copper Contributor
SUM function gives null result
I'm using SUM function and it returns 0. 8 12 8 10 0 I don't understand why is it happening.
Detlef_Lewin
Apr 14, 2022Silver Contributor
Your numbers are not numbers but text and SUM() ignores text.
Check with ISNUMBER() or ISTEXT().
Check with ISNUMBER() or ISTEXT().