Xcel Sum function

%3CLINGO-SUB%20id%3D%22lingo-sub-2538344%22%20slang%3D%22en-US%22%3EXcel%20Sum%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2538344%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20followed%20the%20process%20to%20get%20the%20Sum%20of%20a%20range%20of%20currency%20amounts%20but%20the%20total%20arrived%20at%20is%20%220%22%3C%2FP%3E%3CP%3EPlease%20advise%20why%20should%20this%20be%20%220%22.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2538344%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-2538371%22%20slang%3D%22en-US%22%3ERe%3A%20Xcel%20Sum%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2538371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1101357%22%20target%3D%22_blank%22%3E%40hassimyunus1gmailcom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20clarify%20why%20the%20sum%20shouldn't%20be%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%2280%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2280%22%20height%3D%2220%22%3E-8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E%3CSTRONG%3E0%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EThe%20sum%20of%20first%20three%20values%20is%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2538399%22%20slang%3D%22en-US%22%3ERe%3A%20Xcel%20Sum%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2538399%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1101357%22%20target%3D%22_blank%22%3E%40hassimyunus1gmailcom%3C%2FA%3E%26nbsp%3B%20wrote%3A%20%60%60Please%20advise%20why%20should%20this%20be%20%220%22%60%60.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20reason%20might%20be%20your%20bad%20habit%20of%20putting%20quotes%20around%20numbers.%26nbsp%3B%20Zero%20is%200%2C%20not%20%220%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20amounts%20that%20you%20are%20SUMing%20might%20be%20text%2C%20not%20numeric.%26nbsp%3B%20Use%20formulas%20of%20the%20form%20%3DISTEXT(A1)%20to%20confirm%20(or%20disprove)%20that%20A1%20is%20indeed%20text.%26nbsp%3B%20Looks%20can%20be%20deceiving%3B%20and%20the%20format%20of%20the%20cell%20does%20not%20matter.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20they%20are%20indeed%20text%20and%20you%20cannot%20figure%20out%20why%2C%20attach%20an%20example%20Excel%20file%20that%20demonstrates%20the%20problem.%26nbsp%3B%20There%20are%20many%20possible%20reasons.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I have followed the process to get the Sum of a range of currency amounts but the total arrived at is "0"

Please advise why should this be "0". 

2 Replies

@hassimyunus1gmailcom 

Please clarify why the sum shouldn't be 0.

 

-8
5
3
0

The sum of first three values is 0.

 

 

@hassimyunus1gmailcom  wrote: ``Please advise why should this be "0"``.

 

One reason might be your bad habit of putting quotes around numbers.  Zero is 0, not "0".

 

The amounts that you are SUMing might be text, not numeric.  Use formulas of the form =ISTEXT(A1) to confirm (or disprove) that A1 is indeed text.  Looks can be deceiving; and the format of the cell does not matter.  

 

If they are indeed text and you cannot figure out why, attach an example Excel file that demonstrates the problem.  There are many possible reasons.