@sum formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1552191%22%20slang%3D%22en-US%22%3E%40sum%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552191%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexcel%20continue%20to%20have%20sum%200%20even%20though%20all%20formula%20are%20correct.%3C%2FP%3E%3CP%3EWhether%20I%20add%20column%20or%20row.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1552191%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1552222%22%20slang%3D%22de-DE%22%3ESubject%3A%20%40sum%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552222%22%20slang%3D%22de-DE%22%3EA%20file%20with%20this%20problem%20would%20be%20an%20advantage%20...%20this%20is%20the%20only%20way%20to%20exclude%20some%20things%2C%20otherwise%20you%20have%20to%20guess%20...%20and%20I'm%20not%20good%20at%20that.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

 

excel continue to have sum 0 even though all formula are correct.

Whether I add column or row.

2 Replies
Highlighted
A file with this problem would be an advantage ... this is the only way to exclude some things, otherwise you have to guess ... and I'm not good at that.

Nikolino
I know I don't know anything (Socrates)
Highlighted

@nyliram2500 

One of possible reasons you have texts instead of numbers, even if they are looks like numbers - SUM() ignores all texts