{"id":9703,"date":"2025-01-02T13:13:17","date_gmt":"2025-01-02T13:13:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-countif-thiet-lap-so-thu-tu-thanh-phan-cua-bang-phan-loai\/"},"modified":"2025-01-02T13:13:17","modified_gmt":"2025-01-02T13:13:17","slug":"huong-dan-su-dung-ham-countif-thiet-lap-so-thu-tu-thanh-phan-cua-bang-phan-loai","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-countif-thiet-lap-so-thu-tu-thanh-phan-cua-bang-phan-loai\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m COUNTIF thi\u1ebft l\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 th\u00e0nh ph\u1ea7n c\u1ee7a b\u1ea3ng ph\u00e2n lo\u1ea1i"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft l\u1ea7n n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd \u0111\u1ebfn v\u1edbi m\u1ed9t \u1ee9ng d\u1ee5ng th\u1ef1c ti\u1ec5n c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\"><strong>h\u00e0m COUNTIF<\/strong><\/a> trong vi\u1ec7c l\u1eadp b\u1ea3ng ph\u1ee5c v\u1ee5 m\u1ee5c \u0111\u00edch t\u1ed5ng k\u1ebft b\u00e1o c\u00e1o, \u0111\u00f3 l\u00e0 vi\u1ec7c thi\u1ebft l\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 th\u00e0nh ph\u1ea7n b\u1ea3ng ph\u00e2n lo\u1ea1i.<\/p>\n<p>C\u1ee5 th\u1ec3, ta s\u1ebd b\u1eaft \u0111\u1ea7u t\u1eeb b\u1ea3ng t\u00ednh nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23670\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-1.png\" width=\"284\" height=\"242\" title=\"countif-lap-so-thu-tu-1\"><\/p>\n<p>M\u1ee5c \u0111\u00edch \u1edf \u0111\u00e2y l\u00e0 ta s\u1ebd \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ec3 ph\u00e2n lo\u1ea1i. Sau \u0111\u00f3 t\u00e1ch th\u00e0nh c\u00e1c nh\u00f3m l\u1edbn \u0111\u1ec3 t\u1ed5ng h\u1ee3p v\u00e0\u2026 g\u1eedi c\u00e1c s\u1ebfp\u00a0 \ud83d\ude1b .<\/p>\n<figure id=\"attachment_23671\" aria-describedby=\"caption-attachment-23671\" style=\"width: 793px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23671\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-2.png\" width=\"793\" height=\"456\" title=\"countif-lap-so-thu-tu-2\"><figcaption id=\"caption-attachment-23671\" class=\"wp-caption-text\">Ki\u1ec3u nh\u01b0 n\u00e0y n\u00e8!<\/figcaption><\/figure>\n<p>H\u00e3y c\u00f9ng H\u1ecdc Excel Online gi\u1ea3i quy\u1ebft nh\u00e9. B\u00e0i to\u00e1n n\u00e0y c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft ch\u1ec9 b\u1eb1ng v\u00e0i h\u00e0m \u0111\u01a1n gi\u1ea3n m\u00e0 tr\u1ecdng t\u00e2m l\u00e0 h\u00e0m\u00a0<strong>COUNTIF <\/strong>th\u00f4i \u0111\u1ea5y. C\u00e1c b\u1ea1n tin kh\u00f4ng?<\/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-677690ed21589\" 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\/ham-countif-thiet-lap-so-thu-tu-thanh-phan-bang-phan-loai.html#Su_dung_cac_ham_xu_ly_ky_tu_lay_du_lieu_tu_thong_tin_co_san\" title=\"S\u1eed d\u1ee5ng c\u00e1c h\u00e0m x\u1eed l\u00fd k\u00fd t\u1ef1 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb th\u00f4ng tin c\u00f3 s\u1eb5n\">S\u1eed d\u1ee5ng c\u00e1c h\u00e0m x\u1eed l\u00fd k\u00fd t\u1ef1 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb th\u00f4ng tin c\u00f3 s\u1eb5n<\/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\/ham-countif-thiet-lap-so-thu-tu-thanh-phan-bang-phan-loai.html#Su_dung_ham_COUNTIF_thiet_lap_so_thu_tu_thanh_phan_cua_bang_phan_loai\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNTIF thi\u1ebft l\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 th\u00e0nh ph\u1ea7n c\u1ee7a b\u1ea3ng ph\u00e2n lo\u1ea1i\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF thi\u1ebft l\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 th\u00e0nh ph\u1ea7n c\u1ee7a b\u1ea3ng ph\u00e2n lo\u1ea1i<\/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\/ham-countif-thiet-lap-so-thu-tu-thanh-phan-bang-phan-loai.html#Hoan_thien_bang_tinh_bang_dinh_dang_Su_dung_SUBTOTAL_tinh_tong_thanh_phan\" title=\"Ho\u00e0n thi\u1ec7n b\u1ea3ng t\u00ednh b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng. S\u1eed d\u1ee5ng SUBTOTAL t\u00ednh t\u1ed5ng th\u00e0nh ph\u1ea7n\">Ho\u00e0n thi\u1ec7n b\u1ea3ng t\u00ednh b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng. S\u1eed d\u1ee5ng SUBTOTAL t\u00ednh t\u1ed5ng th\u00e0nh ph\u1ea7n<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-countif-thiet-lap-so-thu-tu-thanh-phan-bang-phan-loai.html#Dinh_dang_bang_tinh\" title=\"\u0110\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh\">\u0110\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-countif-thiet-lap-so-thu-tu-thanh-phan-bang-phan-loai.html#Su_dung_SUBTOTAL_tinh_tong_thanh_phan_bang_tinh\" title=\"S\u1eed d\u1ee5ng SUBTOTAL t\u00ednh t\u1ed5ng th\u00e0nh ph\u1ea7n b\u1ea3ng t\u00ednh\">S\u1eed d\u1ee5ng SUBTOTAL t\u00ednh t\u1ed5ng th\u00e0nh ph\u1ea7n b\u1ea3ng t\u00ednh<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_cac_ham_xu_ly_ky_tu_lay_du_lieu_tu_thong_tin_co_san\"><\/span>S\u1eed d\u1ee5ng c\u00e1c h\u00e0m x\u1eed l\u00fd k\u00fd t\u1ef1 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb th\u00f4ng tin c\u00f3 s\u1eb5n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ea7u ti\u00ean, ta ph\u1ea3i \u201cph\u00e2n nh\u00f3m\u201d s\u1ea3n ph\u1ea9m tr\u01b0\u1edbc \u0111\u00e3. C\u00f3 th\u1ec3 th\u1ea5y r\u00f5 r\u1eb1ng c\u00f3 3 nh\u00f3m \u1edf \u0111\u00e2y bao g\u1ed3m:\u00a0<strong>b\u00fat ch\u00ec, b\u00fat bi, th\u01b0\u1edbc k\u1ebb.<\/strong><\/p>\n<p>Gi\u1edd h\u00e3y t\u1ea1o c\u1ed9t ph\u1ee5 b\u1eb1ng c\u00e1ch click chu\u1ed9t ph\u1ea3i v\u00e0o ch\u1eef\u00a0<strong>A<\/strong> v\u00e0 ch\u1ecdn\u00a0<strong>Insert\u00a0<\/strong>\u0111\u1ec3 t\u1ea1o ra c\u1ed9t m\u1edbi. L\u00e0m thao t\u00e1c n\u00e0y 2 l\u1ea7n \u0111\u1ec3 t\u1ea1o 2 c\u1ed9t m\u1edbi nh\u00e9.<\/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-81.gif\" title=\"ex101_92019-nho-81\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23672\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-3.png\" width=\"339\" height=\"408\" title=\"countif-lap-so-thu-tu-3\"><\/p>\n<p>C\u1ed9t \u0111\u1ea7u ti\u00ean ta s\u1ebd \u0111i\u1ec1n\u00a0<strong>\u201cS\u1ed1 th\u1ee9 t\u1ef1\u201d<\/strong>, c\u1ed9t th\u1ee9 hai l\u00e0\u00a0<strong>\u201cLo\u1ea1i s\u1ea3n ph\u1ea9m\u201d<\/strong>. T\u1ea5t nhi\u00ean c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t nh\u1eefng c\u00e1i t\u00ean hay h\u01a1n v\u00e0 v\u1eafn t\u1eaft h\u01a1n. V\u00e0 k\u00e9o r\u1ed9ng c\u1ed9t ra m\u1ed9t ch\u00fat b\u1eb1ng c\u00e1ch ch\u1ecdn c\u1ed9t mu\u1ed1n m\u1edf r\u1ed9ng, \u0111\u01b0a con tr\u1ecf chu\u1ed9t v\u00e0o l\u1ec1 c\u1ed9t t\u1edbi khi n\u00f3 chuy\u1ec3n nh\u01b0 trong h\u00ecnh, sau \u0111\u00f3 k\u00e9o th\u1ea3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23673\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-4.png\" width=\"531\" height=\"268\" title=\"countif-lap-so-thu-tu-4\"><\/p>\n<p>B\u01b0\u1edbc ti\u1ebfp theo, ta s\u1ebd d\u00f9ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/?s=h%C3%A0m+x%E1%BB%AD+l%C3%BD+k%C3%AD+t%E1%BB%B1\"><strong>c\u00e1c h\u00e0m li\u00ean quan t\u1edbi k\u00fd t\u1ef1, v\u0103n b\u1ea3n<\/strong><\/a> \u0111\u1ec3 l\u1ea5y lo\u1ea1i s\u1ea3n ph\u1ea9m t\u1eeb t\u00ean s\u1ea3n ph\u1ea9m. Trong b\u00e0i n\u00e0y, logic l\u1ea5y chu\u1ed7i s\u1ebd l\u00e0\u00a0<em>t\u1eeb d\u1ea5u c\u00e1ch th\u1ee9 2 \u0111\u1ed5 l\u1ea1i<\/em>.<\/p>\n<ol>\n<li>S\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm ra v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u c\u00e1ch th\u1ee9 nh\u1ea5t theo c\u00fa ph\u00e1p:\u00a0<em>=FIND(\u201d \u201c,C2)<\/em><\/li>\n<li>Sau khi t\u00ecm ra v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u c\u00e1ch th\u1ee9 nh\u1ea5t, ta t\u00ecm \u0111\u1ebfn d\u1ea5u c\u00e1ch th\u1ee9 2 c\u0169ng theo c\u00fa ph\u00e1p:\u00a0<em>=FIND(\u201d \u201c,C3,FIND(\u201d \u201c,C3)+1<\/em><\/li>\n<li>Cu\u1ed1i c\u00f9ng d\u00f9ng h\u00e0m LEFT \u0111\u1ec3 l\u1ea5y chu\u1ed7i k\u00ed t\u1ef1 t\u00ednh t\u1eeb \u0111\u1ea7u \u0111\u1ebfn d\u1ea5u c\u00e1ch: <em>=LEFT(C3,FIND(\u201d \u201c,C3,FIND(\u201d \u201c,C3)+1)-1)<\/em><\/li>\n<\/ol>\n<p>Gi\u1ea3i th\u00edch m\u1ed9t ch\u00fat:<br \/>\nC\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m FIND l\u00e0:<\/p>\n<blockquote>\n<p>=FIND(find_text,within_text,[start_num])<\/p>\n<\/blockquote>\n<p>V\u1edbi\u00a0<strong>find_text<\/strong> l\u00e0 k\u00ed t\u1ef1 c\u1ea7n t\u00ecm ki\u1ebfm,\u00a0<strong>within_text<\/strong> l\u00e0 chu\u1ed7i k\u00ed t\u1ef1 ch\u1ee9a\u00a0<strong>find_text<\/strong>,\u00a0<strong>start_num<\/strong> l\u00e0 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u. K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m FIND s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a\u00a0<strong>find_text<\/strong> trong\u00a0<strong>within_text.\u00a0<\/strong><\/p>\n<p>Khi ti\u1ebfn h\u00e0nh\u00a0FIND l\u1ea7n \u0111\u1ea7u, ta s\u1ebd t\u00ecm \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u c\u00e1ch th\u1ee9 nh\u1ea5t.<\/p>\n<p>Khi ti\u1ebfn h\u00e0nh FIND l\u1ea7n th\u1ee9 hai, t\u1ea1i\u00a0<strong>start_num<\/strong> ta l\u1ea5y v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u c\u00e1ch th\u1ee9 nh\u1ea5t c\u1ed9ng v\u1edbi 1, khi \u0111\u00f3 Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u c\u00e1ch th\u1ee9 hai.<br \/>\nSau \u0111\u00f3 ta d\u00f9ng h\u00e0m LEFT v\u1edbi c\u00f4ng th\u1ee9c\u00a0<em>=LEFT(k\u00ed t\u1ef1 c\u1ea7n l\u1ea5y chu\u1ed7i, s\u1ed1 k\u00ed t\u1ef1 l\u1ea5y t\u1eeb chu\u1ed7i).<\/em> Trong b\u00e0i ta tr\u1eeb \u0111i 1 \u1edf s\u1ed1 k\u00ed t\u1ef1 l\u1ea5y chu\u1ed7i \u0111\u1ec3 kh\u00f4ng l\u1ea5y d\u1ea5u c\u00e1ch v\u00e0o lo\u1ea1i s\u1ea3n ph\u1ea9m.<\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23674\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-5.png\" width=\"505\" height=\"241\" title=\"countif-lap-so-thu-tu-5\"><\/p>\n<p>Sau \u0111\u00f3, ta ti\u1ebfn h\u00e0nh\u00a0<strong>Sort<\/strong> \u0111\u1ec3 ph\u00e2n lo\u1ea1i s\u1ea3n ph\u1ea9m theo c\u00e1c b\u01b0\u1edbc nh\u01b0 h\u00ecnh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-23675\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-6-1024x424-1.png\" width=\"1024\" height=\"424\" title=\"countif-lap-so-thu-tu-6-1024x424-1\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23691\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-7.png\" width=\"507\" height=\"241\" title=\"countif-lap-so-thu-tu-7\"><\/p>\n<p><em>C\u00e1c b\u1ea1n c\u00f3 \u0111\u1ec3 \u00fd l\u00e0 trong t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf th\u00ec ch\u1eb3ng ai l\u00e0m ng\u01b0\u1ee3c nh\u01b0 b\u00e0i h\u01b0\u1edbng d\u1eabn c\u1ea3, khi m\u00e0 nh\u1eadp lo\u1ea1i s\u1ea3n ph\u1ea9m t\u1eeb t\u00ean s\u1ea3n ph\u1ea9m, ph\u1ea3i kh\u00f4ng n\u00e0o? Tuy nhi\u00ean th\u00f4ng qua vi\u1ec7c \u201cng\u01b0\u1ee3c \u0111\u1eddi\u201d n\u00e0y, H\u1ecdc Excel Online mu\u1ed1n n\u00f3i m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t v\u1ec1 c\u00e1c t\u00ecnh hu\u1ed1ng ph\u00e1t sinh c\u0169ng nh\u01b0 c\u00e1c h\u00e0m b\u1ed5 tr\u1ee3 gi\u00fap c\u00e1c b\u1ea1n kh\u00f4ng b\u1ecb th\u1ee5 \u0111\u1ed9ng d\u1ef1a v\u00e0o c\u00e1c khu\u00f4n m\u1eabu c\u00f3 s\u1eb5n, m\u00e0 c\u00f3 th\u1ec3 t\u1ef1 ch\u1ee7 \u0111\u1ed9ng t\u00ecm nhi\u1ec1u h\u01b0\u1edbng gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1.<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNTIF_thiet_lap_so_thu_tu_thanh_phan_cua_bang_phan_loai\"><\/span>S\u1eed d\u1ee5ng h\u00e0m COUNTIF thi\u1ebft l\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 th\u00e0nh ph\u1ea7n c\u1ee7a b\u1ea3ng ph\u00e2n lo\u1ea1i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u00e2y gi\u1edd ta s\u1ebd ti\u1ebfn \u0111\u1ebfn b\u01b0\u1edbc thi\u1ebft l\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 th\u00e0nh ph\u1ea7n c\u1ee7a b\u1ea3ng ph\u00e2n lo\u1ea1i. Y\u00eau c\u1ea7u \u1edf \u0111\u00e2y l\u00e0 m\u1ed7i lo\u1ea1i s\u1ea3n ph\u1ea9m s\u1ebd c\u00f3 b\u1ed9 s\u1ed1 th\u1ee9 t\u1ef1 ri\u00eang.<\/p>\n<p>C\u00f3 th\u1ec3 hi\u1ec3u r\u1eb1ng ta s\u1ebd ti\u1ebfn h\u00e0nh \u0111\u1ebfm t\u1eeb 1 cho \u0111\u1ebfn x t\u01b0\u01a1ng \u1ee9ng v\u1edbi lo\u1ea1i s\u1ea3n ph\u1ea9m. Khi lo\u1ea1i s\u1ea3n ph\u1ea9m thay \u0111\u1ed5i, b\u1ed9 \u0111\u1ebfm s\u1ebd tr\u1edf v\u1ec1 1.<\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n ta l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23692\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-8.png\" width=\"247\" height=\"81\" title=\"countif-lap-so-thu-tu-8\"><\/p>\n<p>T\u1ea1i \u00f4 A2 nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<blockquote>\n<p><em><strong>=COUNTIF($B$2:B2,B2)<\/strong><\/em><\/p>\n<\/blockquote>\n<p>C\u00f3 ngh\u0129a l\u00e0\u00a0<em>v\u1edbi \u0111i\u1ec1u ki\u1ec7n ch\u1ea1y theo t\u1eebng \u00f4 t\u1eeb B2 \u0111\u1ebfn Bx, v\u00f9ng \u0111\u1ebfm s\u1ebd tr\u1ea3i r\u1ed9ng ra t\u1eeb B2:B2, B2:B3\u2026 cho \u0111\u1ebfn B2:Bx.<\/em><\/p>\n<p>Sau \u0111\u00f3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i b\u1eb1ng c\u00e1ch fill:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23693\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-9.png\" width=\"529\" height=\"260\" title=\"countif-lap-so-thu-tu-9\"><\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23694\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-10.png\" width=\"530\" height=\"258\" title=\"countif-lap-so-thu-tu-10\"><\/p>\n<p>V\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 ho\u00e0n th\u00e0nh c\u01a1 b\u1ea3n b\u1ea3ng t\u00ednh r\u1ed3i. T\u1ea5t c\u1ea3 nh\u1eefng y\u00eau c\u1ea7u c\u1ea7n thi\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c x\u1eed l\u00fd trong \u0111\u00e2y!<\/p>\n<p>Tuy nhi\u00ean, ta v\u1eabn c\u00f3 th\u1ec3 l\u00e0m cho n\u00f3 tr\u1edf n\u00ean ho\u00e0n thi\u1ec7n h\u01a1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Hoan_thien_bang_tinh_bang_dinh_dang_Su_dung_SUBTOTAL_tinh_tong_thanh_phan\"><\/span>Ho\u00e0n thi\u1ec7n b\u1ea3ng t\u00ednh b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng. S\u1eed d\u1ee5ng SUBTOTAL t\u00ednh t\u1ed5ng th\u00e0nh ph\u1ea7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_bang_tinh\"><\/span>\u0110\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e3y ch\u0103m ch\u00fat cho \u201cngo\u1ea1i h\u00ecnh\u201d c\u1ee7a b\u1ea3ng t\u00ednh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c \u0111\u1ecbnh d\u1ea1ng n\u00e0o:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23695\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-11-2.png\" width=\"887\" height=\"204\" title=\"countif-lap-so-thu-tu-11-2\"><\/p>\n<p><em>\u0110\u1ea7u ti\u00ean l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t<\/em><\/p>\n<figure id=\"attachment_23696\" aria-describedby=\"caption-attachment-23696\" style=\"width: 533px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23696\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-12.png\" width=\"533\" height=\"217\" title=\"countif-lap-so-thu-tu-12\"><figcaption id=\"caption-attachment-23696\" class=\"wp-caption-text\">N\u1ec1n \u0111en ch\u1eef tr\u1eafng l\u00e0 k\u1ebft h\u1ee3p \u0111\u01a1n gi\u1ea3n nh\u1ea5t. B\u00f4i \u0111\u1eadm ch\u1eef v\u00e0 c\u00f3 th\u1ec3 k\u00e9o font to h\u01a1n<\/figcaption><\/figure>\n<p><em>Ti\u1ebfp theo l\u00e0 th\u00e0nh ph\u1ea7n c\u00e1c c\u1ed9t:<\/em><\/p>\n<figure id=\"attachment_23697\" aria-describedby=\"caption-attachment-23697\" style=\"width: 653px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23697\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-13.png\" width=\"653\" height=\"425\" title=\"countif-lap-so-thu-tu-13\"><figcaption id=\"caption-attachment-23697\" class=\"wp-caption-text\">Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng cell style c\u00f3 s\u1eb5n, ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p m\u00e0u s\u1eafc theo c\u00e1ch ri\u00eang<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_SUBTOTAL_tinh_tong_thanh_phan_bang_tinh\"><\/span>S\u1eed d\u1ee5ng SUBTOTAL t\u00ednh t\u1ed5ng th\u00e0nh ph\u1ea7n b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ch\u1ee9c n\u0103ng SUBTOTAL s\u1ebd ph\u00e2n bi\u1ec7t c\u00e1c th\u00e0nh ph\u1ea7n trong b\u1ea3ng t\u00ednh theo nh\u1eefng ph\u00e2n lo\u1ea1i, \u0111\u1ed3ng th\u1eddi s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ednh to\u00e1n gi\u00fap x\u1eed l\u00fd b\u1ea3ng t\u00ednh nhanh h\u01a1n.<\/p>\n<figure id=\"attachment_23698\" aria-describedby=\"caption-attachment-23698\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-23698\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-14-1024x134-1.png\" width=\"1024\" height=\"134\" title=\"countif-lap-so-thu-tu-14-1024x134-1\"><figcaption id=\"caption-attachment-23698\" class=\"wp-caption-text\">Ch\u1ee9c n\u0103ng SUBTOTAL<\/figcaption><\/figure>\n<p>\u0110\u1ea7u ti\u00ean, ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh. Sau \u0111\u00f3 click v\u00e0o SUBTOTAL. M\u1ed9t h\u1ed9p tho\u1ea1i s\u1ebd hi\u1ec7n ra nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23699\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-15.png\" width=\"938\" height=\"401\" title=\"countif-lap-so-thu-tu-15\"><\/p>\n<p>T\u1ea1i \u0111\u00e2y ta s\u1ebd l\u01b0u \u00fd t\u1edbi nh\u1eefng v\u00f9ng \u0111\u01b0\u1ee3c khoanh \u0111\u1ecf:<\/p>\n<p>\u2013<strong>At each change in<\/strong>: Ph\u00e2n chia theo th\u00e0nh ph\u1ea7n n\u00e0o. Ta ch\u1ecdn ph\u00e2n chia theo\u00a0<strong>Lo\u1ea1i s\u1ea3n ph\u1ea9m.<\/strong><\/p>\n<p>\u2013<strong>Use Function:<\/strong> S\u1eed d\u1ee5ng h\u00e0m n\u00e0o. \u1ede \u0111\u00e2y ta s\u1ebd t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng th\u00e0nh ph\u1ea7n, v\u1eady n\u00ean ch\u1ecdn h\u00e0m\u00a0<strong>SUM.<\/strong><\/p>\n<p>\u2013<strong>Add Subtotal to<\/strong>: S\u1eed d\u1ee5ng h\u00e0m cho c\u1ed9t n\u00e0o. Ta ch\u1ecdn\u00a0<strong>S\u1ed1 l\u01b0\u1ee3ng<\/strong>.<\/p>\n<p>Sau \u0111\u00f3 \u1ea5n\u00a0<strong>OK.<\/strong><\/p>\n<figure id=\"attachment_23700\" aria-describedby=\"caption-attachment-23700\" style=\"width: 728px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23700\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/countif-lap-so-thu-tu-16.png\" width=\"728\" height=\"423\" title=\"countif-lap-so-thu-tu-16\"><figcaption id=\"caption-attachment-23700\" class=\"wp-caption-text\">Ta-daa!!<\/figcaption><\/figure>\n<p>V\u1eady l\u00e0 c\u01a1 b\u1ea3n xong r\u1ed3i \u0111\u00f3 c\u00e1c b\u1ea1n!<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online \u0111\u00e3 h\u01b0\u1edbng d\u1eabn nh\u1eefng b\u01b0\u1edbc c\u01a1 b\u1ea3n nh\u1ea5t v\u1ec1 c\u00e1ch x\u1eed l\u00fd v\u00e0 \u0111\u1ecbnh d\u1ea1ng m\u1ed9t b\u1ea3ng t\u00ednh th\u00e0nh ph\u1ea7n. Hy v\u1ecdng qua b\u00e0i h\u1ecdc n\u00e0y, c\u00e1c b\u1ea1n s\u1ebd c\u00f3 th\u00eam \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c h\u1eefu \u00edch \u0111\u1ec3 \u1ee9ng d\u1ee5ng trong c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t<\/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-81.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9703","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\/9703","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=9703"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9703\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9704"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}