{"id":2138,"date":"2024-12-02T07:03:58","date_gmt":"2024-12-02T07:03:58","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-sumif-trong-excel-ham-tinh-tong-theo-mot-dieu-kien-cho-truoc\/"},"modified":"2024-12-02T07:03:58","modified_gmt":"2024-12-02T07:03:58","slug":"ham-sumif-trong-excel-ham-tinh-tong-theo-mot-dieu-kien-cho-truoc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-sumif-trong-excel-ham-tinh-tong-theo-mot-dieu-kien-cho-truoc\/","title":{"rendered":"H\u00e0m SUMIF trong excel, h\u00e0m t\u00ednh t\u1ed5ng theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">V\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF<\/strong><\/a> trong excel, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c<\/p>\n<p style=\"text-align: justify\">Gi\u1ed1ng v\u1edbi h\u00e0m SUM, h\u00e0m SUMIF c\u0169ng l\u00e0 h\u00e0m t\u00ednh t\u1ed5ng tuy nhi\u00ean h\u00e0m n\u00e0y t\u00ednh t\u1ed5ng theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 sau \u0111\u00e2y s\u1ebd cho c\u00e1c b\u1ea1n\u00a0hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00fa ph\u00e1p: SUMIF(Range,Criteria,Sum_range)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Range:<\/strong> L\u00e0 \u0111\u1ecba ch\u1ec9 d\u00e3y \u00f4 ch\u1ee9a d\u1eef li\u1ec7u.<\/li>\n<li><strong>Criteria:<\/strong>L\u00e0 gi\u00e1 tr\u1ecb \u0111i\u1ec1u ki\u1ec7n (c\u00f3 th\u1ec3 \u1edf d\u1ea1ng bi\u1ec3u th\u1ee9c s\u1ed1, bi\u1ec3u th\u1ee9c k\u00ed t\u1ef1, bi\u1ec3u th\u1ee9c logic) \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p c\u00f9ng ki\u1ec3u d\u1eef li\u1ec7u v\u1edbi Range.<\/li>\n<li><strong>Sum_range:\u00a0<\/strong>L\u00e0 \u0111\u1ecba ch\u1ec9 d\u00e3y \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng c\u1ea7n t\u00ednh t\u1ed5ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><b>V\u00ed d\u1ee5:\u00a0<\/b>T\u00ednh t\u1ed5ng ti\u1ec1n tr\u1ea3 c\u1ee7a nh\u1eefng h\u1ed9 c\u00f3 m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng l\u00e0 S\u1ea3n xu\u1ea5t.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3570\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-3.png\" width=\"600\" height=\"156\" title=\"4-3\"><\/p>\n<p style=\"text-align: justify\">Ta th\u1ef1c hi\u1ec7n nh\u01b0 sau: <strong>=SUMIF(C6:C13;\u201dSxu\u1ea5t\u201d;K6:K13)<\/strong> V\u00ec \u1edf \u0111\u00e2y m\u00ecnh d\u00f9ng Excel 2013 n\u00ean c\u00e1c \u0111\u1ed1i s\u1ed1 c\u00e1ch nhau b\u1edfi d\u1ea5u ; n\u1ebfu nh\u01b0 c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng Excel 2007, 2010 th\u00ec\u00a0nh\u1edb \u0111\u1ed5i th\u00e0nh d\u1ea5u , nh\u00e9 n\u1ebfu kh\u00f4ng l\u00e0 kh\u00f4ng cho ra k\u1ebft qu\u1ea3.<\/p>\n<ul style=\"text-align: justify\">\n<li>K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3571\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-4.png\" width=\"600\" height=\"185\" title=\"5-4\"><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.<\/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-163.gif\" title=\"ex101_92019-nho-163\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Xem th\u00eam: <strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\">C\u00c1CH D\u00d9NG H\u00c0M SUMIF<\/a> <\/strong>TRONG EXCEL \u2013 V\u00cd D\u1ee4 C\u00d4NG TH\u1ee8C<\/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-163.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2139,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2138","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\/2138","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=2138"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2138\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2139"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}