Excel addition formula results in 0

%3CLINGO-SUB%20id%3D%22lingo-sub-2960346%22%20slang%3D%22en-US%22%3EExcel%20addition%20formula%20results%20in%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2960346%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20summary%20worksheet%20showing%20currency%20sums%20from%20other%20worksheets%20in%20the%20file.%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20do%20addition%20of%20various%20cells%20such%20as%3A%26nbsp%3B%20%26nbsp%3B%3DE51%2BM51%2BP51%20the%20result%20shows%20as%20a%200%3C%2FP%3E%3CP%3EEach%20of%20those%20cells%20shows%20a%20positive%20number%20that%20is%20not%20zero%3C%2FP%3E%3CP%3EThe%20row%20above%20uses%20the%20same%20formula%20%3DE50%2BM50%2BP51%20and%20shows%20a%20proper%20sum%3C%2FP%3E%3CP%3EThis%20seems%20to%20be%20a%20recent%20problem%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20run%20error%20check%20and%20do%20not%20seem%20to%20be%20able%20to%20find%20any%20problems%20in%20my%20formulas%20or%20data%3C%2FP%3E%3CP%3Eany%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2960346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2960390%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20addition%20formula%20results%20in%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2960390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1217012%22%20target%3D%22_blank%22%3E%40GLSmith06%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMake%20sure%20that%20E51%2C%20M51%20and%20P51%20are%20real%20numbers%20and%20not%20text%20values%20that%20look%20like%20numbers.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a summary worksheet showing currency sums from other worksheets in the file.

When I try to do addition of various cells such as:   =E51+M51+P51 the result shows as a 0

Each of those cells shows a positive number that is not zero

The row above uses the same formula =E50+M50+P51 and shows a proper sum

This seems to be a recent problem 

I have run error check and do not seem to be able to find any problems in my formulas or data

any ideas?

1 Reply

@GLSmith06 

Make sure that E51, M51 and P51 are real numbers and not text values that look like numbers.