{"id":9189,"date":"2025-01-01T20:57:57","date_gmt":"2025-01-01T20:57:57","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/criteria-la-gi-cach-viet-criteria-trong-cac-ham-tinh-toan-theo-dieu-kien\/"},"modified":"2025-01-01T20:57:57","modified_gmt":"2025-01-01T20:57:57","slug":"criteria-la-gi-cach-viet-criteria-trong-cac-ham-tinh-toan-theo-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/criteria-la-gi-cach-viet-criteria-trong-cac-ham-tinh-toan-theo-dieu-kien\/","title":{"rendered":"Criteria l\u00e0 g\u00ec? C\u00e1ch vi\u1ebft Criteria trong c\u00e1c h\u00e0m t\u00ednh to\u00e1n theo \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 h\u00e0m nh\u01b0 COUNTIF, <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF<\/strong><\/a>, COUNTIFS, SUMIFS\u2026 ch\u00fang ta th\u1ea5y trong nh\u1eefng h\u00e0m n\u00e0y \u0111\u1ec1u xu\u1ea5t hi\u1ec7n tham s\u1ed1 Criteria. V\u1eady Criteria l\u00e0 g\u00ec? C\u00e1ch vi\u1ebft Criteria th\u1ebf n\u00e0o cho \u0111\u00fang? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> \u0111i t\u00ecm c\u00e2u tr\u1ea3 l\u1eddi cho nh\u1eefng th\u1eafc m\u1eafc \u0111\u00f3 ngay n\u00e0o.<\/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-6775ac54c1f2f\" 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\/criteria-la-gi-cach-viet-criteria-trong-cac-ham-tinh-toan-theo-dieu-kien.html#Criteria_la_gi\" title=\"Criteria l\u00e0 g\u00ec?\">Criteria l\u00e0 g\u00ec?<\/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\/criteria-la-gi-cach-viet-criteria-trong-cac-ham-tinh-toan-theo-dieu-kien.html#Cach_viet_dieu_kien_cho_dung\" title=\"C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n cho\u00a0\u0111\u00fang\">C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n cho\u00a0\u0111\u00fang<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/criteria-la-gi-cach-viet-criteria-trong-cac-ham-tinh-toan-theo-dieu-kien.html#Cach_viet_dieu_kien_dang_Number\" title=\"C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Number\">C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Number<\/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\/criteria-la-gi-cach-viet-criteria-trong-cac-ham-tinh-toan-theo-dieu-kien.html#Cach_viet_dieu_kien_dang_Date\" title=\"C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Date\">C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Date<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/criteria-la-gi-cach-viet-criteria-trong-cac-ham-tinh-toan-theo-dieu-kien.html#Cach_viet_dieu_kien_dang_Text\" title=\"C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Text\">C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Text<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Criteria_la_gi\"><\/span>Criteria l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Criteria c\u00f3 ngh\u0129a\u00a0l\u00e0\u00a0\u0110i\u1ec1u ki\u1ec7n. Criteria th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n trong c\u00e1c h\u00e0m t\u00ednh to\u00e1n theo\u00a0\u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>H\u00e0m COUNTIF\u00a0\u0111\u1ebfm theo 1\u00a0\u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>H\u00e0m COUNTIFS\u00a0\u0111\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo 1\u00a0\u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>H\u00e0m SUMIFS t\u00ednh t\u1ed5ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_viet_dieu_kien_cho_dung\"><\/span>C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n cho\u00a0\u0111\u00fang<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 gi\u00fap c\u00e1c h\u00e0m t\u00ednh\u00a0\u0111\u00fang theo \u00fd mu\u1ed1n, b\u1ea1n c\u1ea7n ph\u1ea3i vi\u1ebft\u00a0\u0111\u00fang\u00a0\u0111i\u1ec1u ki\u1ec7n. Nh\u01b0ng vi\u1ec7c n\u00e0y\u00a0l\u1ea1i ph\u1ee9c t\u1ea1p h\u01a1n b\u1ea1n t\u01b0\u1edfng. B\u1edfi v\u00ec trong\u00a0Excel, d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c chia th\u00e0nh 3 lo\u1ea1i: D\u1eef li\u1ec7u Number (d\u1ea1ng s\u1ed1), d\u1eef li\u1ec7u Date (d\u1ea1ng ng\u00e0y th\u00e1ng th\u1eddi gian), d\u1eef li\u1ec7u d\u1ea1ng Text (chu\u1ed7i k\u00fd t\u1ef1). V\u1edbi m\u1ed7i lo\u1ea1i d\u1eef li\u1ec7u th\u00ec c\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n l\u1ea1i kh\u00e1c nhau. C\u1ee5 th\u1ec3 l\u00e0:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_dieu_kien_dang_Number\"><\/span>C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Number<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25317\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-viet-dieu-kien-dang-number.png\" width=\"748\" height=\"363\" title=\"cach-viet-dieu-kien-dang-number\"><\/p>\n<ul>\n<li>Khi vi\u1ebft tr\u1ef1c ti\u1ebfp, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1ea5u to\u00e1n t\u1eed (l\u00e0 c\u00e1c d\u1ea5u l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, b\u1eb1ng, kh\u00e1c\u2026) vi\u1ebft li\u1ec1n v\u1edbi gi\u00e1 tr\u1ecb\u00a0\u0111i\u1ec1u ki\u1ec7n, sau\u00a0\u0111\u00f3\u00a0\u0111\u1eb7t t\u1ea5t c\u1ea3 trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<li>Khi vi\u1ebft d\u1ea1ng tham chi\u1ebfu, ph\u1ea7n d\u1ea5u to\u00e1n t\u1eed s\u1ebd\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p. Sau\u00a0\u0111\u00f3 n\u1ed1i v\u1edbi tham chi\u1ebfu b\u1edfi d\u1ea5u &amp;<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5 nh\u01b0 sau:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25319\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vi-du-ham-countif-dem-theo-dieu-kien-dang-number-01.png\" width=\"473\" height=\"293\" title=\"vi-du-ham-countif-dem-theo-dieu-kien-dang-number-01\"><\/p>\n<p>\u0110\u1ec3\u00a0\u0111\u1ebfm s\u1ed1 l\u1ea7n c\u00f3 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n l\u1edbn h\u01a1n 50, ch\u00fang ta c\u00f3:<\/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-20.gif\" title=\"ex101_92019-nho-20\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>V\u00f9ng ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 v\u00f9ng S\u1ed1 l\u01b0\u1ee3ng<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ebfm l\u00e0 l\u1edbn h\u01a1n 50<\/li>\n<\/ul>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta d\u00f9ng h\u00e0m COUNTIF nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25320\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vi-du-ham-countif-dem-theo-dieu-kien-dang-number-02.png\" width=\"700\" height=\"327\" title=\"vi-du-ham-countif-dem-theo-dieu-kien-dang-number-02\"><\/p>\n<ul>\n<li>Vi\u1ebft tr\u1ef1c ti\u1ebfp: =COUNTIF(B2:B8,\u201d&gt;50\u2033) trong\u00a0\u0111\u00f3\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 \u201c&gt;50\u201d<\/li>\n<li>Vi\u1ebft tham chi\u1ebfu:\u00a0=COUNTIF(B2:B8,\u201d&gt;\u201d&amp;A12) trong\u00a0\u0111\u00f3\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 \u201c&gt;\u201d&amp;A12 l\u00e0 tham chi\u1ebfu t\u1edbi\u00a0\u00f4 A12<\/li>\n<\/ul>\n<p>C\u1ea3 2 c\u00e1ch vi\u1ebft\u00a0\u0111\u1ec1u ra k\u1ebft qu\u1ea3\u00a0\u0111\u00fang.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_dieu_kien_dang_Date\"><\/span>C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Date<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25318\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-viet-dieu-kien-dang-date.png\" width=\"754\" height=\"333\" title=\"cach-viet-dieu-kien-dang-date\"><\/p>\n<p>Khi vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n li\u00ean quan t\u1edbi ng\u00e0y th\u00e1ng, th\u1eddi gian, b\u1ea1n c\u1ea7n ch\u00fa\u00a0\u00fd l\u00e0\u00a0Excel kh\u00f4ng cho ph\u00e9p vi\u1ebft tr\u1ef1c ti\u1ebfp theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng.<\/p>\n<p>B\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 vi\u1ebft theo 2 c\u00e1ch:<\/p>\n<ul>\n<li>C\u00e1ch 1: Chuy\u1ec3n gi\u00e1 tr\u1ecb th\u1eddi gian v\u1ec1 d\u1ea1ng General (d\u1ea1ng m\u1eb7c\u00a0\u0111\u1ecbnh c\u1ee7a gi\u00e1 tr\u1ecb th\u1eddi gian,\u00a0\u0111\u00f3 l\u00e0 1 con s\u1ed1), sau\u00a0\u0111\u00f3 vi\u1ebft gi\u1ed1ng d\u1ea1ng Number<\/li>\n<li>C\u00e1ch 2: Vi\u1ebft theo d\u1ea1ng tham chi\u1ebfu th\u00ec c\u00f3 th\u1ec3 vi\u1ebft tr\u1ef1c ti\u1ebfp t\u1edbi\u00a0\u00f4 ch\u1ee9a d\u1eef li\u1ec7u th\u1eddi gian.<\/li>\n<\/ul>\n<p>Khi mu\u1ed1n vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n cho 1 y\u1ebfu t\u1ed1 Th\u00e1ng ho\u1eb7c N\u0103m trong khi v\u00f9ng ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n ch\u1ec9 c\u00f3 d\u1eef li\u1ec7u l\u00e0 Ng\u00e0y,\u00a0b\u1ea1n c\u1ea7n ph\u1ea3i t\u00e1ch Th\u00e1ng \u00a0ra Ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng v\u00e0 Ng\u00e0y cu\u1ed1i th\u00e1ng\u00a0\u0111\u1ec3 t\u00ednh.<\/p>\n<p><strong>V\u00ed d\u1ee5 nh\u01b0 sau:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25321\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vi-du-ham-sumif-dem-theo-dieu-kien-dang-date-01.png\" width=\"557\" height=\"288\" title=\"vi-du-ham-sumif-dem-theo-dieu-kien-dang-date-01\"><\/p>\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 l\u01b0\u1ee3ng b\u00e1n trong th\u00e1ng 1 trong khi ch\u1ec9 c\u00f3 c\u1ed9t Ng\u00e0y b\u00e1n, ch\u00fang ta c\u1ea7n ph\u1ea3i t\u1ea1o ra\u00a0\u0111\u01b0\u1ee3c 2 gi\u00e1 tr\u1ecb: Ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng 1 v\u00e0 Ng\u00e0y cu\u1ed1i th\u00e1ng 1.<\/p>\n<p>Sau\u00a0\u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25322\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vi-du-ham-sumif-dem-theo-dieu-kien-dang-date-02.png\" width=\"967\" height=\"310\" title=\"vi-du-ham-sumif-dem-theo-dieu-kien-dang-date-02\"><\/p>\n<ul>\n<li>T\u1ea1i\u00a0\u00f4 B11, b\u1ea1n nh\u1eadp ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng<\/li>\n<li>T\u1ea1i\u00a0\u00f4 B12, b\u1ea1n nh\u1eadp ng\u00e0y cu\u1ed1i th\u00e1ng<\/li>\n<li>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 E11 l\u00e0:<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">=SUMIFS(C2:C8,B2:B8,\u201d&gt;=\u201d&amp;B11,B2:B8,\u201d&lt;=\u201d&amp;B12)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>C2:C8 l\u00e0 v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng, c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng<\/li>\n<li>B2:B8 l\u00e0 v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ea7u ti\u00ean, ch\u00ednh l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n v\u1ec1 Ng\u00e0y b\u00e1n<\/li>\n<li>\u201c&gt;=\u201d&amp;B11 l\u00e0 tham chi\u1ebfu t\u1edbi gi\u00e1 tr\u1ecb\u00a0\u1edf\u00a0\u00f4 B11, l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng<\/li>\n<li>B2:B8 l\u00e0 v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai, ch\u00ednh l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n v\u1ec1 Ng\u00e0y b\u00e1n<\/li>\n<li>\u201c&lt;=\u201d&amp;B12 l\u00e0 tham chi\u1ebfu t\u1edbi gi\u00e1 tr\u1ecb\u00a0\u1edf\u00a0\u00f4 B12,\u00a0nh\u1ecf\u00a0h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y\u00a0cu\u1ed1i\u00a0th\u00e1ng<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_dieu_kien_dang_Text\"><\/span>C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Text<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25323\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-viet-dieu-kien-dang-text.png\" width=\"921\" height=\"235\" title=\"cach-viet-dieu-kien-dang-text\"><\/p>\n<p>Khi vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Text, c\u00f3 m\u1ed9t\u00a0\u0111\u1eb7c th\u00f9 c\u1ee7a d\u1eef li\u1ec7u Text l\u00e0 kh\u00f4ng k\u00e8m v\u1edbi d\u1ea5u to\u00e1n t\u1eed. Thay v\u00e0o\u00a0\u0111\u00f3 l\u1ea1i l\u00e0 nh\u1eefng k\u00fd t\u1ef1\u00a0\u0111\u1ea1i di\u1ec7n cho t\u00ednh ch\u1ea5t b\u1eaft\u00a0\u0111\u1ea7u, k\u1ebft th\u00fac, c\u00f3 ch\u1ee9a k\u00fd t\u1ef1\u2026<\/p>\n<ul>\n<li>K\u00fd t\u1ef1 * \u0111\u1ea1i di\u1ec7n c\u00f3 b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 n\u00e0o, kh\u00f4ng gi\u1edbi h\u1ea1n s\u1ed1 k\u00fd t\u1ef1<\/li>\n<li>K\u00fd t\u1ef1 ? \u0111\u1ea1i di\u1ec7n cho 1 k\u00fd t\u1ef1 b\u1ea5t k\u1ef3<\/li>\n<\/ul>\n<p>L\u01b0u \u00fd th\u1ee9 t\u1ef1 \u0111\u1eb7t k\u00fd t\u1ef1 * ? \u1edf tr\u01b0\u1edbc hay \u1edf sau k\u00fd t\u1ef1 l\u00e0m \u0111i\u1ec1u ki\u1ec7n. B\u1edfi vi\u1ec7c n\u00e0y\u00a0\u1ea3nh h\u01b0\u1edfng l\u1edbn t\u1edbi k\u1ebft qu\u1ea3 c\u1ee7a\u00a0\u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p><strong>H\u00e3y xem v\u00ed d\u1ee5 sau\u00a0\u0111\u00e2y nh\u00e9:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25324\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vi-du-ham-sumif-dem-theo-dieu-kien-dang-text.png\" width=\"750\" height=\"235\" title=\"vi-du-ham-sumif-dem-theo-dieu-kien-dang-text\"><\/p>\n<p>Khi mu\u1ed1n t\u00ednh t\u1ed5ng cho nh\u1eefng s\u1ea3n ph\u1ea9m l\u00e0 SGK, ch\u00fang ta th\u1ea5y\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh l\u00e0 T\u00ean s\u1ea3n ph\u1ea9m s\u1ebd b\u1eaft\u00a0\u0111\u1ea7u v\u1edbi k\u00fd t\u1ef1 SGK.<\/p>\n<p>Nh\u01b0 v\u1eady khi vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n trong h\u00e0m SUMIF, ch\u00fang ta s\u1ebd vi\u1ebft \u201cSGK*\u201d\u00a0\u0111\u1ec3 bi\u1ec3u di\u1ec5n\u00a0\u00fd ngh\u0129a n\u00e0y.<\/p>\n<p>Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5\u00a0\u0111\u01b0\u1ee3c c\u00e1ch vi\u1ebft\u00a0c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n trong c\u00e1c h\u00e0m t\u00ednh to\u00e1n theo\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ee7a\u00a0Excel.\u00a0\u0110\u00e2y\u00a0\u0111\u1ec1u l\u00e0 nh\u1eefng h\u00e0m quan tr\u1ecdng v\u00e0\u00a0\u0111\u01b0\u1ee3c\u00a0\u1ee9ng d\u1ee5ng r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/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-20.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9190,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9189","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\/9189","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=9189"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9189\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9190"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}