Tính tổng các ô liền kề trong 1 cột ta sử dụng phím tắt Alt = Enter. Chỉ sử dụng 3 phím đơn giản như này:

Phím tắt tính tổng trong Excel
Và kết quả chúng ta được như này:

Chúc các bạn thành công. Các bạn có thêm cách khác comment bên dưới nhé!
-1 ) { htmlTag.className += ' ie10'; } if ( !!navigator.userAgent.match(/Trident.*rv\:11\./) ) { htmlTag.className += ' ie11'; } if ( navigator.userAgent.indexOf("Edge") > -1 ) { htmlTag.className += ' ieEdge'; } if ( /(iPad|iPhone|iPod)/g.test(navigator.userAgent) ) { htmlTag.className += ' td-md-is-ios'; } var user_agent = navigator.userAgent.toLowerCase(); if ( user_agent.indexOf("android") > -1 ) { htmlTag.className += ' td-md-is-android'; } if ( -1 !== navigator.userAgent.indexOf('Mac OS X') ) { htmlTag.className += ' td-md-is-os-x'; } if ( /chrom(e|ium)/.test(navigator.userAgent.toLowerCase()) ) { htmlTag.className += ' td-md-is-chrome'; } if ( -1 !== navigator.userAgent.indexOf('Firefox') ) { htmlTag.className += ' td-md-is-firefox'; } if ( -1 !== navigator.userAgent.indexOf('Safari') && -1 === navigator.userAgent.indexOf('Chrome') ) { htmlTag.className += ' td-md-is-safari'; } if( -1 !== navigator.userAgent.indexOf('IEMobile') ){ htmlTag.className += ' td-md-is-iemobile'; } })(); var tdLocalCache = {}; ( function () { "use strict"; tdLocalCache = { data: {}, remove: function (resource_id) { delete tdLocalCache.data[resource_id]; }, exist: function (resource_id) { return tdLocalCache.data.hasOwnProperty(resource_id) && tdLocalCache.data[resource_id] !== null; }, get: function (resource_id) { return tdLocalCache.data[resource_id]; }, set: function (resource_id, cachedData) { tdLocalCache.remove(resource_id); tdLocalCache.data[resource_id] = cachedData; } }; })(); var td_viewport_interval_list=[{"limitBottom":767,"sidebarWidth":228},{"limitBottom":1018,"sidebarWidth":300},{"limitBottom":1140,"sidebarWidth":324}]; var td_animation_stack_effect="type0"; var tds_animation_stack=true; var td_animation_stack_specific_selectors=".entry-thumb, img, .td-lazy-img"; var td_animation_stack_general_selectors=".td-animation-stack img, .td-animation-stack .entry-thumb, .post img, .td-animation-stack .td-lazy-img"; var tdc_is_installed="yes"; var td_ajax_url="https:\/\/tinhhoacongnghe.com\/wp-admin\/admin-ajax.php?td_theme_name=Newspaper&v=11.4"; var td_get_template_directory_uri="https:\/\/tinhhoacongnghe.com\/wp-content\/plugins\/td-composer\/legacy\/common"; var tds_snap_menu="snap"; var tds_logo_on_sticky=""; var tds_header_style="2"; var td_please_wait="Vui l\u00f2ng ch\u1edd..."; var td_email_user_pass_incorrect="Ng\u01b0\u1eddi d\u00f9ng ho\u1eb7c m\u1eadt kh\u1ea9u kh\u00f4ng ch\u00ednh x\u00e1c!"; var td_email_user_incorrect="Email ho\u1eb7c t\u00e0i kho\u1ea3n kh\u00f4ng ch\u00ednh x\u00e1c!"; var td_email_incorrect="Email kh\u00f4ng \u0111\u00fang!"; var td_user_incorrect="Username incorrect!"; var td_email_user_empty="Email or username empty!"; var td_pass_empty="Pass empty!"; var td_pass_pattern_incorrect="Invalid Pass Pattern!"; var td_retype_pass_incorrect="Retyped Pass incorrect!"; var tds_more_articles_on_post_enable="show"; var tds_more_articles_on_post_time_to_wait=""; var tds_more_articles_on_post_pages_distance_from_top=0; var tds_theme_color_site_wide="#4ac5db"; var tds_smart_sidebar="enabled"; var tdThemeName="Newspaper"; var td_magnific_popup_translation_tPrev="Tr\u01b0\u1edbc (Left arrow key)"; var td_magnific_popup_translation_tNext="Ti\u1ebfp (Right arrow key)"; var td_magnific_popup_translation_tCounter="%curr% c\u1ee7a %total%"; var td_magnific_popup_translation_ajax_tError="Kh\u00f4ng th\u1ec3 t\u1ea3i n\u1ed9i dung t\u1ea1i %url%"; var td_magnific_popup_translation_image_tError="Kh\u00f4ng th\u1ec3 t\u1ea3i \u1ea3nh #%curr%"; var tdBlockNonce="674e8e4262"; var tdsDateFormat="l , d-m-Y H:i:s"; var tdDateNamesI18n={"month_names":["Th\u00e1ng M\u1ed9t","Th\u00e1ng hai","Th\u00e1ng ba","Th\u00e1ng t\u01b0","Th\u00e1ng n\u0103m","Th\u00e1ng s\u00e1u","Th\u00e1ng b\u1ea3y","Th\u00e1ng t\u00e1m","Th\u00e1ng ch\u00edn","Th\u00e1ng m\u01b0\u1eddi","Th\u00e1ng m\u01b0\u1eddi m\u1ed9t","Th\u00e1ng m\u01b0\u1eddi hai"],"month_names_short":["Th1","Th2","Th3","Th4","Th5","Th6","Th7","Th8","Th9","Th10","Th11","Th12"],"day_names":["Ch\u1ee7 Nh\u1eadt","Th\u1ee9 hai","Th\u1ee9 ba","Th\u1ee9 t\u01b0","Th\u1ee9 n\u0103m","Th\u1ee9 s\u00e1u","Th\u1ee9 b\u1ea3y"],"day_names_short":["CN","T2","T3","T4","T5","T6","T7"]}; var td_ad_background_click_link=""; var td_ad_background_click_target="";