{"id":1900,"date":"2015-11-05T15:14:10","date_gmt":"2015-11-05T14:14:10","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1900"},"modified":"2023-11-30T21:50:09","modified_gmt":"2023-11-30T20:50:09","slug":"excel-subtotal-feature","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-subtotal-feature\/","title":{"rendered":"Excel&#8217;s Subtotal Feature"},"content":{"rendered":"<p>Excel\u00b4s Subtotal feature is a great way to automatically\u00a0insert\u00a0a <em>Sum\/Count\/Average\/Max\/Min<\/em> subtotal to your data set with a press of a button.<\/p>\n<p>This feature is located under\u00a0the Excel Data tools menu: <em>Data &gt; Subtotal<\/em><strong><em>. \u00a0<\/em><\/strong>To insert this feature you need to follow these quick steps:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Highlight your data and go to <strong><em>Data &gt; Subtotal<\/em><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel&#039;s Subtotal Feature\"  class=\"alignnone size-full wp-image-19367\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-01.png\" alt=\"Excel&#039;s Subtotal Feature\" width=\"1327\" height=\"580\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-01.png 1327w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-01-300x131.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-01-1024x448.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-01-768x336.png 768w\" sizes=\"(max-width: 1327px) 100vw, 1327px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> This will open up the <strong>Subtotal dialogue box<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-05_14-25-461.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel&#039;s Subtotal Feature\"  class=\"alignnone size-full wp-image-1909\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-05_14-25-461.png\" alt=\"Excel&#039;s Subtotal Feature\" width=\"706\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-05_14-25-461.png 706w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-05_14-25-461-300x139.png 300w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> <strong>At each change:<\/strong>\u00a0Select which column you want to use to separate the data. \u00a0Make sure that the data in the selected column is in ascending\/descending order<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel&#039;s Subtotal Feature\"  class=\"alignnone size-full wp-image-19368\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-03.png\" alt=\"Excel&#039;s Subtotal Feature\" width=\"257\" height=\"331\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-03.png 257w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-03-233x300.png 233w\" sizes=\"(max-width: 257px) 100vw, 257px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> <strong>Use function:<\/strong>\u00a0Select which\u00a0function you want to use for your calculation. \u00a0You can select from<em> Sum, Count, Average, Maximum, Minimum, Product, Count Numbers, StdDev, StdDevp, Var, Varp<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel&#039;s Subtotal Feature\"  class=\"alignnone size-full wp-image-19369\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-04.png\" alt=\"Excel&#039;s Subtotal Feature\" width=\"257\" height=\"331\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-04.png 257w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-04-233x300.png 233w\" sizes=\"(max-width: 257px) 100vw, 257px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> <strong>Add subtotal to:<\/strong>\u00a0Select the column that you want to Subtotal<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel&#039;s Subtotal Feature\"  class=\"alignnone size-full wp-image-19370\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-05.png\" alt=\"Excel&#039;s Subtotal Feature\" width=\"257\" height=\"331\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-05.png 257w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-05-233x300.png 233w\" sizes=\"(max-width: 257px) 100vw, 257px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Press OK and this will add extra lines to your data with the chosen Subtotal<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel&#039;s Subtotal Feature\"  class=\"alignnone size-full wp-image-19371\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-06.png\" alt=\"Excel&#039;s Subtotal Feature\" width=\"257\" height=\"331\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-06.png 257w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-06-233x300.png 233w\" sizes=\"(max-width: 257px) 100vw, 257px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span> <strong>If you want to change the Subtotal<\/strong> (say from a Sum to an Average) all you have to do is click in your data and go to<em> Data &gt; Subtotal<\/em> and it will bring up the Subtotal dialogue box once again. \u00a0Under\u00a0<em>Use function<\/em> select <em>Average<\/em> and press <em>OK<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel&#039;s Subtotal Feature\"  class=\"alignnone size-full wp-image-19372\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-07.png\" alt=\"Excel&#039;s Subtotal Feature\" width=\"520\" height=\"466\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-07.png 520w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/subtotal-07-300x269.png 300w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/gHmqm4eISPc?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=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Subtotals-Feature.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Subtotals-Feature.xlsx<\/span><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/530x300-Pivot.jpg\" alt=\"Excel Pivot Table\" width=\"530\" height=\"300\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u00b4s Subtotal feature is a great way to automatically\u00a0insert\u00a0a Sum\/Count\/Average\/Max\/Min subtotal to your data set with a press of a button. This feature is located under\u00a0the Excel Data tools menu: Data &gt; Subtotal. \u00a0To insert this feature you need to follow these quick steps: STEP 1: Highlight your data and go to Data &gt; Subtotal [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17695,"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,41],"tags":[88],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1900"}],"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=1900"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1900\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17695"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}