# Solved How to sum the dollar & cents in excel?

December 7, 2015 at 23:44:04
Specs: Windows 7
 Example:-A1 \$12.66B1 12 (Dollar)C1 66 (Cent)A2 \$13.95B2 13 (Dollar)C2 95 (Cent)If I want to sum the amount of "B1, B2, C1, C2", what formula should I use?I can't sum the as the dollar and cent are on different column.Anyone can help me?

See More: How to sum the dollar & cents in excel?

#1
December 8, 2015 at 07:30:45
 Try this:=(B1+B2)+(C1+C2)/100For longer lists, this might make more sense:=SUM(B1:B100)+SUM(C1:C100)/100or=SUM(SUM(B1:B2),SUM(C1:C2)/100)This will also work, based on the Order of Operations that Excel follows, but it is a bit cumbersome. I'm just tossing it out for general information.=B1+C1/100+B2+C2/100message edited by DerbyDad03

Report •

#2
December 8, 2015 at 23:57:29
 Thanks DerbyDad03!I managed to sum the amount based on your formula provided.What if the calculation need to be done according to dollar & cent column separately?Formula which I used as below:-Column "Dollar" : =sum(B1:B2) result equal to "25" (it should be 26)Column "Cent" : =sum(C1:C2)/100 result equal to "1.61" (it should be 61)Is there any formula can be used, so that whichever number >1 in column "Cent" will automatically add to column "Dollar"?

Report •

#3
December 9, 2015 at 12:04:01