{"id":11001,"date":"2021-12-06T22:32:04","date_gmt":"2021-12-06T22:32:04","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=11001"},"modified":"2021-12-06T22:32:22","modified_gmt":"2021-12-06T22:32:22","slug":"solved-how-to-sum-the-dollar-cents-in-excel","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/how-to-sum-the-dollar-cents-in-excel\/20112.html","title":{"rendered":"Solved How To Sum The Dollar &#038; Cents In Excel?"},"content":{"rendered":"<p>Example:-<br \/>\nA1 $12.66<br \/>\nB1 12 (Dollar)<br \/>\nC1 66 (Cent)<\/p>\n<p>A2 $13.95<br \/>\nB2 13 (Dollar)<br \/>\nC2 95 (Cent)<\/p>\n<p>If I want to sum the amount of &#8220;B1, B2, C1, C2&#8221;, what formula should I use?<\/p>\n<p>I can&#8217;t sum the as the dollar and cent are on different column.<\/p>\n<p>Anyone can help me?<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":6},"question-category":[53],"question_tags":[],"class_list":["post-11001","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/11001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=11001"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=11001"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=11001"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=11001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}