Home

Excel 2016 Sum Function

%3CLINGO-SUB%20id%3D%22lingo-sub-633075%22%20slang%3D%22en-US%22%3EExcel%202016%20Sum%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633075%22%20slang%3D%22en-US%22%3E%3CP%3EI%20an%20using%20Excel%202016%20on%20Win%2010%20Plaltform.%3C%2FP%3E%3CP%3EI%20am%20having%20problems%20with%20adding%20Cells%20in%20Two%20Columns%20(%20H34%20%2BG54)%20to%20another%20Cell.%3C%2FP%3E%3CP%3EBoth%20Cells%20are%20Formatted%20as%20Number.%3C%2FP%3E%3CP%3EUsing%20either%20(%3DH34%2BG54)%20or%20%3DSUM(H34%2CG54)%20or%20%3DSUM(H34%3AG54)%20all%20return%20Zero%20(0.00)%3C%2FP%3E%3CP%3EI%20cannot%20identify%20the%20cause%20of%20this.%3C%2FP%3E%3CP%3ECan%20someone%20shed%20some%20light%20on%20what%20I%20might%20be%20doing%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-633075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633191%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Sum%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633191%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F346472%22%20target%3D%22_blank%22%3E%40Nasho23%3C%2FA%3E%26nbsp%3B%2C%20most%20probably%20you%20have%20texts%20in%20your%20cells%2C%20even%20if%20number%20format%20is%20applied.%20You%20may%20check%20from%20any%20empty%20cell%20by%20%3DISTEXT(H34)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633961%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Sum%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633961%22%20slang%3D%22en-US%22%3EDespite%20using%20SUM%2C%20which%20ignores%20text%2C%20your%20formula%20still%20returns%200.%20Such%20presupposes%20that%20both%20H34%20and%20G54%20are%20read%20as%20texts!%20To%20convert%20them%20to%20numbers%2C%20try%20this%20formula%3A%3CBR%20%2F%3E%3DSUM(%E2%80%94H34%2C%E2%80%94G54)%3CBR%20%2F%3EI%20haven%E2%80%99t%20tested%20the%20formula%20because%20I%E2%80%99m%20replying%20to%20you%20via%20my%20mobile%20phone.%20Thus%2C%20please%20allow%20me%20to%20emphasize%20that%20double%20negatives%20precede%20each%20argument%20of%20SUM.%3C%2FLINGO-BODY%3E
Nasho23
Occasional Visitor

I an using Excel 2016 on Win 10 Plaltform.

I am having problems with adding Cells in Two Columns ( H34 +G54) to another Cell.

Both Cells are Formatted as Number.

Using either (=H34+G54) or =SUM(H34,G54) or =SUM(H34:G54) all return Zero (0.00)

I cannot identify the cause of this.

Can someone shed some light on what I might be doing wrong.

2 Replies

@Nasho23 , most probably you have texts in your cells, even if number format is applied. You may check from any empty cell by =ISTEXT(H34)

Despite using SUM, which ignores text, your formula still returns 0. Such presupposes that both H34 and G54 are read as texts! To convert them to numbers, try this formula:
=SUM(—H34,—G54)
I haven’t tested the formula because I’m replying to you via my mobile phone. Thus, please allow me to emphasize that double negatives precede each argument of SUM.
Related Conversations