{"id":7662,"date":"2024-12-21T18:12:23","date_gmt":"2024-12-21T18:12:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-tinh-tong-nhung-o-chua-cong-thuc-trong-excel\/"},"modified":"2024-12-21T18:12:23","modified_gmt":"2024-12-21T18:12:23","slug":"huong-dan-tinh-tong-nhung-o-chua-cong-thuc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-tinh-tong-nhung-o-chua-cong-thuc-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u00ednh t\u1ed5ng nh\u1eefng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/inh-tong-nhung-o-chua-cong-thuc-trong-excel.html\"><strong>t\u00ednh t\u1ed5ng nh\u1eefng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c trong Excel<\/strong><\/a> th\u00f4ng qua m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67670506c9878\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/inh-tong-nhung-o-chua-cong-thuc-trong-excel.html#Tinh_tong_nhung_o_chua_cong_thuc_voi_ham_ISFORMULA\" title=\"T\u00ednh t\u1ed5ng nh\u1eefng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m ISFORMULA\">T\u00ednh t\u1ed5ng nh\u1eefng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m ISFORMULA<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/inh-tong-nhung-o-chua-cong-thuc-trong-excel.html#Ket_hop_ISFORMULA_voi_SUMPRODUCT_tinh_tong_o_chua_cong_thuc\" title=\"K\u1ebft h\u1ee3p ISFORMULA v\u1edbi SUMPRODUCT t\u00ednh t\u1ed5ng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c\">K\u1ebft h\u1ee3p ISFORMULA v\u1edbi SUMPRODUCT t\u00ednh t\u1ed5ng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_tong_nhung_o_chua_cong_thuc_voi_ham_ISFORMULA\"><\/span>T\u00ednh t\u1ed5ng nh\u1eefng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m ISFORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc h\u1ebft, ta s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ham-isformula-kiem-tra-cong-thuc.html\"><strong>h\u00e0m\u00a0ISFORMULA<\/strong><\/a>:<\/p>\n<p><em>H\u00e0m ISFORMULA s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0\u00a0<strong>TRUE<\/strong>\u00a0\u0111\u1ed1i v\u1edbi tham chi\u1ebfu ch\u1ee9a c\u00f4ng th\u1ee9c,\u00a0<strong>FALSE<\/strong>\u00a0v\u1edbi tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1ee3c l\u1ea1i.<\/em><\/p>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ISFORMULA l\u00e0:\u00a0<em><strong>=ISFORMULA(tham chi\u1ebfu)<\/strong><\/em><\/p>\n<p>Trong \u0111\u00f3 <strong>tham chi\u1ebfu\u00a0<\/strong>l\u00e0 gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp, tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb ho\u1eb7c t\u00ean \u0111\u01b0\u1ee3c \u0111\u1eb7t.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_hop_ISFORMULA_voi_SUMPRODUCT_tinh_tong_o_chua_cong_thuc\"><\/span>K\u1ebft h\u1ee3p ISFORMULA v\u1edbi SUMPRODUCT t\u00ednh t\u1ed5ng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 c\u1ee7a ta trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30780 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/isformula-sumproduct-1.png\" alt=\"huong-dan-tinh-tong-nhung-o-chua-cong-thuc-trong-excel-1\" width=\"353\" height=\"282\" title=\"isformula-sumproduct-1\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-686.gif\" title=\"ex101_92019-nho-686\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Nh\u1eefng nh\u00e2n vi\u00ean c\u00f3 doanh thu \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>Calculation\u00a0<\/strong>l\u00e0 nh\u1eefng nh\u00e2n vi\u00ean c\u00f3 doanh thu \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o b\u1eb1ng c\u00f4ng th\u1ee9c. T\u00ednh t\u1ed5ng doanh thu nh\u1eefng nh\u00e2n vi\u00ean \u0111\u00f3.<\/p>\n<p>C\u00f4ng th\u1ee9c trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u1ee7a ta nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em><strong>=SUMPRODUCT(v\u00f9ng doanh thu * ISFORMULA(v\u00f9ng doanh thu))<\/strong><\/em><\/p>\n<\/blockquote>\n<p>C\u1ee5 th\u1ec3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ta nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<p><em>=SUMPRODUCT(B2:B9*ISFORMULA(B2:B9))<\/em><\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c trong h\u00ecnh d\u01b0\u1edbi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30781 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/isformula-sumproduct-2.png\" alt=\"huong-dan-tinh-tong-nhung-o-chua-cong-thuc-trong-excel-2\" width=\"526\" height=\"361\" title=\"isformula-sumproduct-2\"><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 t\u00ednh t\u1ed5ng ch\u1ec9 nh\u1eefng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c. Trong tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1ee3c l\u1ea1i, \u0111\u1ec3 t\u00ednh t\u1ed5ng nh\u1eefng \u00f4 kh\u00f4ng ch\u1ee9a c\u00f4ng th\u1ee9c ta l\u1ed3ng v\u00e0o h\u00e0m NOT:<\/p>\n<p><em>=SUMPRODUCT(B2:B9*NOT(ISFORMULA(B2:B9)))<\/em><\/p>\n<p>V\u1eady l\u00e0 vi\u1ec7c t\u00ednh t\u1ed5ng trong Excel \u0111\u00e3 kh\u00f4ng c\u00f2n g\u00ec v\u01b0\u1edbng m\u1eafc \u0111\u00fang kh\u00f4ng, k\u1ec3 c\u1ea3 d\u00f3 l\u00e0 nh\u1eefng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c. C\u00e1c b\u1ea1n h\u00e3y tham kh\u1ea3o ngay <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\"><strong>Kh\u00f3a h\u1ecdc Excel<\/strong> <\/a>c\u1ee7a ch\u00fang t\u00f4i \u0111\u1ec3 c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c l\u00fd th\u00fa t\u01b0\u01a1ng t\u1ef1 nh\u01b0 th\u1ebf n\u00e0y nh\u00e9!<\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-isformula-kiem-tra-cong-thuc.html\"><strong>Gi\u1edbi thi\u1ec7u h\u00e0m ISFORMULA trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/dem-cac-dieu-kien-loai-tru-sumproduct.html\"><strong>\u0110\u1ebfm c\u00e1c \u0111i\u1ec1u ki\u1ec7n lo\u1ea1i tr\u1eeb v\u1edbi SUMPRODUCT<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/4-tuyet-chieu-tra-cuu-voi-vlookup-index-match-sumproduct-va-names-range-trong-excel.html\"><strong>4 tuy\u1ec7t chi\u00eau tra c\u1ee9u trong Excel<\/strong><\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-686.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7663,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7662","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7662","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=7662"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7662\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7663"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}