{"id":10499,"date":"2025-01-14T10:31:09","date_gmt":"2025-01-14T10:31:09","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-4-cach-khac-nhau-de-dem-so-o-trong-trong-excel\/"},"modified":"2025-01-14T10:31:09","modified_gmt":"2025-01-14T10:31:09","slug":"huong-dan-4-cach-khac-nhau-de-dem-so-o-trong-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-4-cach-khac-nhau-de-dem-so-o-trong-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 4 c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ed1 \u00f4 tr\u1ed1ng n\u1eb1m xen l\u1eabn trong 1 v\u00f9ng b\u1ea3ng t\u00ednh? V\u1ea5n \u0111\u1ec1 n\u00e0y kh\u00f4ng kh\u00f3 nh\u01b0 b\u1ea1n t\u01b0\u1edfng. V\u00e0 H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n 4 c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng trong Excel. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u n\u00e0o:<\/p>\n<p>\u0110\u1ec3 minh h\u1ecda c\u1ee5 th\u1ec3 cho b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta h\u00e3y xem v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19337\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/dem-o-trong-de-bai.png\" width=\"275\" height=\"288\" title=\"dem-o-trong-de-bai\"><\/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-67863cec947c8\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-khac-nhau-de-dem-so-o-trong-trong-excel.html#Cach_thu_1_Dung_ham_COUNTBLANK\" title=\"C\u00e1ch th\u1ee9 1: D\u00f9ng h\u00e0m COUNTBLANK\">C\u00e1ch th\u1ee9 1: D\u00f9ng h\u00e0m COUNTBLANK<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-khac-nhau-de-dem-so-o-trong-trong-excel.html#Cach_thu_2_Dung_ham_COUNTIF\" title=\"C\u00e1ch th\u1ee9 2: D\u00f9ng h\u00e0m COUNTIF\">C\u00e1ch th\u1ee9 2: D\u00f9ng h\u00e0m COUNTIF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-khac-nhau-de-dem-so-o-trong-trong-excel.html#Cach_thu_3_Tinh_tong_so_o_co_so_ky_tu_bang_0\" title=\"C\u00e1ch th\u1ee9 3:\u00a0T\u00ednh t\u1ed5ng s\u1ed1 \u00f4 c\u00f3 s\u1ed1 k\u00fd t\u1ef1 b\u1eb1ng 0\">C\u00e1ch th\u1ee9 3:\u00a0T\u00ednh t\u1ed5ng s\u1ed1 \u00f4 c\u00f3 s\u1ed1 k\u00fd t\u1ef1 b\u1eb1ng 0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-khac-nhau-de-dem-so-o-trong-trong-excel.html#Cach_thu_4_Logic_bu_tru\" title=\"C\u00e1ch th\u1ee9 4: Logic b\u00f9 tr\u1eeb\">C\u00e1ch th\u1ee9 4: Logic b\u00f9 tr\u1eeb<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_1_Dung_ham_COUNTBLANK\"><\/span>C\u00e1ch th\u1ee9 1: D\u00f9ng h\u00e0m COUNTBLANK<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00fang v\u1edbi t\u00ean g\u1ecdi, <a href=\"http:\/\/blog.ezworkapp.com\/ham-countblank-huong-dan-su-dung-ham-countblank-trong-excel.html\">CountBlank<\/a> ngh\u0129a l\u00e0 \u0111\u1ebfm \u00f4 tr\u1ed1ng. V\u00f9ng c\u1ea7n \u0111\u1ebfm l\u00e0 v\u00f9ng A2:B7<\/p>\n<p>C\u00e1ch vi\u1ebft nh\u01b0 sau:<\/p>\n<p>T\u1ea1i \u00f4 E2 \u0111\u1eb7t c\u00f4ng th\u1ee9c =COUNTBLANK(A2:B7)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19338\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/dem-o-trong-countblank.png\" width=\"935\" height=\"233\" title=\"dem-o-trong-countblank\"><\/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\/2025\/01\/ex101_92019-nho-179.gif\" title=\"ex101_92019-nho-179\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-countblank-huong-dan-su-dung-ham-countblank-trong-excel.html\">H\u00e0m COUNTBLANK, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m countblank trong Excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_2_Dung_ham_COUNTIF\"><\/span>C\u00e1ch th\u1ee9 2: D\u00f9ng h\u00e0m COUNTIF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-countif-trong-excel-dem-neu-khong-phai-la-o-trong-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html\">CountIF<\/a> l\u00e0 h\u00e0m \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n. \u1ede y\u00eau c\u1ea7u n\u00e0y l\u00e0 \u0111\u1ebfm \u00f4 tr\u1ed1ng, n\u00ean c\u00f3 th\u1ec3 coi \u00f4 tr\u1ed1ng l\u00e0 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>Trong Excel quy \u01b0\u1edbc \u00f4 tr\u1ed1ng l\u00e0 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb r\u1ed7ng, \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n b\u1eb1ng hai d\u1ea5u nh\u00e1y k\u00e9p li\u1ec1n nhau.<\/p>\n<p>T\u1ea1i \u00f4 E3 vi\u1ebft c\u00f4ng th\u1ee9c =COUNTIF(A2:B7,\u201d\u201d)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19339\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/dem-o-trong-countif.png\" width=\"937\" height=\"235\" title=\"dem-o-trong-countif\"><\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-countif-trong-excel-dem-neu-khong-phai-la-o-trong-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html\">C\u00e1ch d\u00f9ng h\u00e0m COUNTIF trong Excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_3_Tinh_tong_so_o_co_so_ky_tu_bang_0\"><\/span>C\u00e1ch th\u1ee9 3:\u00a0T\u00ednh t\u1ed5ng s\u1ed1 \u00f4 c\u00f3 s\u1ed1 k\u00fd t\u1ef1 b\u1eb1ng 0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u00d4 tr\u1ed1ng c\u00f2n \u0111\u01b0\u1ee3c hi\u1ec3u theo 1 ngh\u0129a kh\u00e1c l\u00e0 \u00f4 c\u00f3 s\u1ed1 k\u00fd t\u1ef1 b\u1eb1ng 0. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong 1 \u00f4.\u00a0K\u1ebft h\u1ee3p h\u00e0m LEN v\u1edbi h\u00e0m SUMPRODUCT \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 \u00f4 c\u00f3 k\u00fd t\u1ef1 b\u1eb1ng 0 nh\u01b0 sau:<\/p>\n<p>T\u1ea1i \u00f4 E4 vi\u1ebft c\u00f4ng th\u1ee9c =SUMPRODUCT((LEN(A2:B7)=0)*1)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19340\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/dem-o-trong-sumproduct-len.png\" width=\"936\" height=\"233\" title=\"dem-o-trong-sumproduct-len\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_4_Logic_bu_tru\"><\/span>C\u00e1ch th\u1ee9 4: Logic b\u00f9 tr\u1eeb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00f9ng A2:B7 ch\u1ec9 c\u00f3 2 lo\u1ea1i: C\u00f3 d\u1eef li\u1ec7u v\u00e0 kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u (\u00f4 tr\u1ed1ng). S\u1ed1 \u00f4 c\u00f3 d\u1eef li\u1ec7u + S\u1ed1 \u00f4 tr\u1ed1ng = T\u1ed5ng s\u1ed1 \u00f4 trong v\u00f9ng.<\/p>\n<p>Do \u0111\u00f3 c\u00f3 th\u1ec3 suy lu\u1eadn theo h\u01b0\u1edbng b\u00f9 tr\u1eeb: N\u1ebfu l\u1ea5y t\u1ed5ng s\u1ed1 \u00f4 tr\u1eeb \u0111i s\u1ed1 \u00f4 c\u00f3 d\u1eef li\u1ec7u th\u00ec s\u1ebd ra s\u1ed1 \u00f4 tr\u1ed1ng.<\/p>\n<p>X\u00e1c \u0111\u1ecbnh t\u1ed5ng s\u1ed1 \u00f4 trong v\u00f9ng: T\u1ed5ng s\u1ed1 h\u00e0ng * T\u1ed5ng s\u1ed1 c\u1ed9t (v\u00ec v\u00f9ng n\u00e0y li\u1ec1n nhau).<\/p>\n<ul>\n<li>\u0110\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 h\u00e0ng ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m ROWS<\/li>\n<li>\u0110\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 c\u1ed9t s\u1eed d\u1ee5ng h\u00e0m COLUMNS<\/li>\n<li>\u0110\u1ebfm s\u1ed1 \u00f4 c\u00f3 k\u00fd t\u1ef1: D\u00f9ng h\u00e0m COUNTA<\/li>\n<\/ul>\n<p>T\u1ea1i \u00f4 E5 vi\u1ebft c\u00f4ng th\u1ee9c\u00a0=ROWS(A2:B7)*COLUMNS(A2:B7)-COUNTA(A2:B7)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19345\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/dem-o-trong-row-column-counta.png\" width=\"935\" height=\"233\" title=\"dem-o-trong-row-column-counta\"><\/p>\n<p>R\u1ea5t \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o? Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft th\u00eam v\u1ec1 c\u00e1ch v\u1eadn d\u1ee5ng linh ho\u1ea1t c\u00e1c h\u00e0m trong excel \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c y\u00eau c\u1ea7u theo nhi\u1ec1u c\u00e1ch kh\u00e1c nhau.<\/p>\n<p>Tham kh\u1ea3o: <a href=\"http:\/\/blog.ezworkapp.com\/cach-dem-o-trong-excel-dung-ham-count-va-counta.html\">C\u00e1ch \u0111\u1ebfm \u00f4 trong Excel d\u00f9ng h\u00e0m COUNT v\u00e0 COUNTA<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2lqeudI\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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\/2025\/01\/ex101_92019-nho-179.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10500,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10499","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\/10499","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=10499"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10499\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10500"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}