{"id":86393,"date":"2025-06-20T21:26:00","date_gmt":"2025-06-21T01:26:00","guid":{"rendered":"https:\/\/bugaluu.com\/sapiosexual\/get-percentage-of-total-excel-formula-exceljet\/"},"modified":"2025-06-20T21:26:00","modified_gmt":"2025-06-21T01:26:00","slug":"get-percentage-of-total-excel-formula-exceljet","status":"publish","type":"post","link":"https:\/\/bugaluu.com\/sapiosexual\/get-percentage-of-total-excel-formula-exceljet\/","title":{"rendered":"Get percentage of total &#8211; Excel formula | Exceljet"},"content":{"rendered":"<p>To calculate the percent of a total (i.e. calculate a percent distribution), you can use a formula that simply divides a given amount by the total. In the example shown, the formula in D6 is: =C6\/total where total is the named range C15.<\/p>\n<p><a href=\"https:\/\/exceljet.net\/formulas\/get-percentage-of-total\" target=\"_blank\" class=\"\">https:\/\/exceljet.net\/formulas\/get-percentage-of-total<\/a>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To calculate the percent of a total (i.e. calculate a percent distribution), you can use a formula that simply divides a given amount by the&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-86393","post","type-post","status-publish","format-standard","hentry","category-sapiosexual","wpcat-1-id"],"_links":{"self":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/86393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/comments?post=86393"}],"version-history":[{"count":0,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/86393\/revisions"}],"wp:attachment":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/media?parent=86393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/categories?post=86393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/tags?post=86393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}