{"id":222,"date":"2022-12-01T20:31:41","date_gmt":"2022-12-01T20:31:41","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/sum-data\/"},"modified":"2022-12-01T20:31:41","modified_gmt":"2022-12-01T20:31:41","slug":"sum-data","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/sum-data\/","title":{"raw":"SUM Data","rendered":"SUM Data"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Use AutoSum button.<\/li>\n<\/ul>\n<\/div>\nOne of the main uses for Excel is to organize and manipulate numerical data. Often you may wish to add up all the numbers in a column or row. Excel has formulas and commands to automatically add your data, and the easiest way to use this feature is the AutoSum button.\n<ol>\n \t<li>Once your numbers are organized in either a row or column, click on the cell where you would like the total sum to display. In the screenshot below this was A13.<\/li>\n \t<li>Click on the AutoSum button from the Editing group of the ribbon.<\/li>\n \t<li>Excel will highlight the cells that it is adding up and will apply the SUM formula.<\/li>\n \t<li>Hit Enter to accept the highlighted cells and see the total value of your data.<\/li>\n<\/ol>\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222221\/sumdata1.png\"><img class=\"aligncenter wp-image-1041\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222221\/sumdata1.png\" alt=\"An excel sheet is open with numbers in column A through row 13. There is an orange arrow pointing to the numbers in row A meaning they have all been selected. There is a green arrow pointing at the sum feature which is being surrounded by a green box. There is a pink arrow pointing at a pink box which shows the result of the sum.\" width=\"800\" height=\"596\"><\/a>\n\nNote that it is possible to SUM several columns (or rows) at once. Select all the cells you wish to display a SUM and click AutoSum. Excel will individually add up the columns.\n\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222308\/sumdata2.png\"><img class=\"aligncenter wp-image-1042\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222308\/sumdata2.png\" alt=\"There is an excel sheet open with numbers in columns A and B through row 14 only discounting row 13. There is a green arrow pointing to cell B14 where the sum of the results from cells B1 through B12 are.\" width=\"800\" height=\"599\"><\/a>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/e06d7eea-0f36-44df-8334-174032c58cd6\n\n<\/div>\nThe AutoSum option can be found in two areas:\n<ul>\n \t<li>It is contained in the Editing group of the ribbon, as shown in the first example above.<\/li>\n \t<li>It can also be found under the Formulas tab.<\/li>\n<\/ul>\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222502\/sumdata3.png\"><img class=\"aligncenter wp-image-1044\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222502\/sumdata3.png\" alt=\"There is an excel sheet open with numbers in columns A and B through row 14 only discounting row 13. There is a green box around the AutoSum dropdown menu under the Formulas tab on the ribbon.\" width=\"800\" height=\"598\"><\/a>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/68945343-e87d-4daa-96d2-c2d6e6761e5d\n\n<\/div>\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/1n5hvzjiDDUtQALmoEdxgvwZmPuWikq5xSw-7eNKTsq0\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Use AutoSum button.<\/li>\n<\/ul>\n<\/div>\n<p>One of the main uses for Excel is to organize and manipulate numerical data. Often you may wish to add up all the numbers in a column or row. Excel has formulas and commands to automatically add your data, and the easiest way to use this feature is the AutoSum button.<\/p>\n<ol>\n<li>Once your numbers are organized in either a row or column, click on the cell where you would like the total sum to display. In the screenshot below this was A13.<\/li>\n<li>Click on the AutoSum button from the Editing group of the ribbon.<\/li>\n<li>Excel will highlight the cells that it is adding up and will apply the SUM formula.<\/li>\n<li>Hit Enter to accept the highlighted cells and see the total value of your data.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222221\/sumdata1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1041\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222221\/sumdata1.png\" alt=\"An excel sheet is open with numbers in column A through row 13. There is an orange arrow pointing to the numbers in row A meaning they have all been selected. There is a green arrow pointing at the sum feature which is being surrounded by a green box. There is a pink arrow pointing at a pink box which shows the result of the sum.\" width=\"800\" height=\"596\" \/><\/a><\/p>\n<p>Note that it is possible to SUM several columns (or rows) at once. Select all the cells you wish to display a SUM and click AutoSum. Excel will individually add up the columns.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222308\/sumdata2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1042\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222308\/sumdata2.png\" alt=\"There is an excel sheet open with numbers in columns A and B through row 14 only discounting row 13. There is a green arrow pointing to cell B14 where the sum of the results from cells B1 through B12 are.\" width=\"800\" height=\"599\" \/><\/a><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_e06d7eea-0f36-44df-8334-174032c58cd6\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/e06d7eea-0f36-44df-8334-174032c58cd6?iframe_resize_id=assessment_practice_id_e06d7eea-0f36-44df-8334-174032c58cd6\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>The AutoSum option can be found in two areas:<\/p>\n<ul>\n<li>It is contained in the Editing group of the ribbon, as shown in the first example above.<\/li>\n<li>It can also be found under the Formulas tab.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222502\/sumdata3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1044\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29222502\/sumdata3.png\" alt=\"There is an excel sheet open with numbers in columns A and B through row 14 only discounting row 13. There is a green box around the AutoSum dropdown menu under the Formulas tab on the ribbon.\" width=\"800\" height=\"598\" \/><\/a><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_68945343-e87d-4daa-96d2-c2d6e6761e5d\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/68945343-e87d-4daa-96d2-c2d6e6761e5d?iframe_resize_id=assessment_practice_id_68945343-e87d-4daa-96d2-c2d6e6761e5d\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1n5hvzjiDDUtQALmoEdxgvwZmPuWikq5xSw-7eNKTsq0\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-222\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>SUM Data in Excel. <strong>Authored by<\/strong>: Shelli Carter. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":503070,"menu_order":8,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"SUM Data in Excel\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"077a2b4b-eaae-49b4-b037-3cd8024b0678, f1ff3031-b13b-43bb-be72-491e0b374408","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-222","chapter","type-chapter","status-publish","hentry"],"part":214,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/222\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/214"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/222\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=222"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=222"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=222"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}