Forum Discussion

Copper Contributor

Jan 20, 2022

Strange SUM-Problem

Hello, Excel specialists, I have a strange problem: =S2+23 delivers 20 correctly, however =SUMME(S2:S3) delivers 0.00?? The cells are set to be numbers. What could be wrong??

excel

Detlef_Lewin

Silver Contributor

Jan 20, 2022

Hi

Check S2 and S3 with ISNUMBER(). If the result is FALSE then it is text - no matter what the format is.