{"id":340,"date":"2014-09-25T18:39:00","date_gmt":"2014-09-25T16:39:00","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=340"},"modified":"2024-02-06T16:02:44","modified_gmt":"2024-02-06T15:02:44","slug":"excel-total-row-calculations","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-total-row-calculations\/","title":{"rendered":"Excel Table: Row Calculations"},"content":{"rendered":"<p>One of the most powerful feature of an Excel Table is the use of <span style=\"color: #000000;\">formulas <\/span>to calculate its Column contents.\u00a0 To activate this you need to click in your Table and go to the <em>Table Tools<\/em> tab in the Ribbon.\u00a0 From there you simply need to activate the <em>Total Rows<\/em> check box.<\/p>\n<p>This will add a <em>Totals Row<\/em> at the bottom of your Table and by clicking in any of the boxes, a list of <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a> will appear! \u00a0You can use the default formulas like <em>Average, Count, Count Numbers, Max, Min, Sum<\/em> plus you can click on <em>More Functions<\/em> which will let you choose any of Excel\u00b4s many formulas.\u00a0 Try it out by downloading the workbook below.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/GuAwl4oJj5Q?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"color: #0000ff;\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Total-Row.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Total-Row.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Select any cell in your table. Go to\u00a0<em><strong>Table Tools &gt; Design &gt; Table Style Options &gt; Total Row<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Row Calculations\"  class=\"alignnone size-full wp-image-19872\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-01.jpg\" alt=\"Excel Table: Row Calculations\" width=\"890\" height=\"568\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-01.jpg 890w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-01-300x191.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-01-768x490.jpg 768w\" sizes=\"(max-width: 890px) 100vw, 890px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> A new row has been added. Select <strong>Count<\/strong> for the <strong>REGION column<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Row Calculations\"  class=\"alignnone size-full wp-image-19873\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-02.jpg\" alt=\"Excel Table: Row Calculations\" width=\"732\" height=\"539\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-02.jpg 732w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-02-300x221.jpg 300w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Select <b>Max <\/b>for the <strong>ORDER DATE column<\/strong><br \/>\n.<br \/>\n<img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Row Calculations\"  class=\"alignnone size-full wp-image-19874\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-03.jpg\" alt=\"Excel Table: Row Calculations\" width=\"725\" height=\"526\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-03.jpg 725w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-03-300x218.jpg 300w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Select <b>Sum <\/b>for the <strong>SALES column<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Row Calculations\"  class=\"alignnone size-full wp-image-19875\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-04.jpg\" alt=\"Excel Table: Row Calculations\" width=\"712\" height=\"533\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-04.jpg 712w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-04-300x225.jpg 300w\" sizes=\"(max-width: 712px) 100vw, 712px\" \/><\/p>\n<p>Now you have your updated values! They get updated automatically as you add new rows and change values!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Row Calculations\"  class=\"alignnone size-full wp-image-19877\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-06.jpg\" alt=\"Excel Table: Row Calculations\" width=\"723\" height=\"369\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-06.jpg 723w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Row-Calculations-06-300x153.jpg 300w\" sizes=\"(max-width: 723px) 100vw, 723px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the most powerful feature of an Excel Table is the use of formulas to calculate its Column contents.\u00a0 To activate this you need to click in your Table and go to the Table Tools tab in the Ribbon.\u00a0 From there you simply need to activate the Total Rows check box. This will add [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17512,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,36],"tags":[88,97],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/340"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=340"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/340\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17512"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}