|re: "Column "Dollar" : =sum(B1:B2) result equal to "25" (it should be 26)"|
No, it should be 25, you just want it to be 26.
re: "Column "Cent" : =sum(C1:C2)/100 result equal to "1.61" (it should be 61)"
No, it should be 1.61, you just want it to be 61
These formulas should work for 2 cells:
If want to SUM a longer list, then these will work for 2 or more cells:
This SUMS the Dollar cells and then adds in the integer portion of the SUM of the Cents cells.
This extracts the last 2 digits of the SUM of the Cents cells. However, the RIGHT function creates a Text string. To turn it back into a Number, we need to multiply the result by 1 (or add 0, etc.) Excel is smart enough to know that if you perform a mathematical operation on the Text representation of a Number, you must want a Number as the result.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.