{"id":7028,"date":"2024-12-21T16:44:06","date_gmt":"2024-12-21T16:44:06","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cong-thuc-sumifs-tinh-tong-hop-nhap-xuat-ton-bao-cao-kho\/"},"modified":"2024-12-21T16:44:06","modified_gmt":"2024-12-21T16:44:06","slug":"cong-thuc-sumifs-tinh-tong-hop-nhap-xuat-ton-bao-cao-kho","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cong-thuc-sumifs-tinh-tong-hop-nhap-xuat-ton-bao-cao-kho\/","title":{"rendered":"C\u00f4ng th\u1ee9c SUMIFS t\u00ednh t\u1ed5ng h\u1ee3p Nh\u1eadp \u2013 Xu\u1ea5t \u2013 T\u1ed3n b\u00e1o c\u00e1o kho"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ho\u1eb7c \u0111\u00f4i khi b\u1ea1n \u0111ang b\u00f9 \u0111\u1ea7u v\u1edbi vi\u1ec7c nh\u1eadp, xu\u1ea5t h\u00e0ng, b\u1ed7ng s\u1ebfp ph\u00e1n c\u00e2u xanh r\u1eddn: \u201c<em>T\u1ed5ng h\u1ee3p cho anh s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng A xu\u1ea5t trong tu\u1ea7n n\u00e0y, l\u00e0m ngay nh\u00e9 anh \u0111ang c\u1ea7n<\/em>! \u201d . \u00d4 h\u00f4, ngay l\u00e0 ngay th\u1ebf n\u00e0o, c\u1ea3 tu\u1ea7n c\u00f3 \u0111\u1ebfn h\u00e0ng tr\u0103m phi\u1ebfu nh\u1eadp, xu\u1ea5t. C\u00e1i g\u00ec m\u00e0 \u201c<em>ch\u1ec9 xu\u1ea5t h\u00e0ng A<\/em>\u201c, c\u00e1i g\u00ec m\u00e0 \u201c<em>Ch\u1ec9 trong tu\u1ea7n n\u00e0y<\/em>\u201c. Ng\u1ed3i c\u1ed9ng tay \u0111\u1ebfn s\u00e1ng mai c\u0169ng ch\u01b0a xong \u00fd ch\u1ee9, ng\u1ed3i \u0111\u1ea5y m\u00e0 c\u00f3 ngay.<\/p>\n<p>\u0110\u1ea5y, n\u1ebfu ch\u01b0a bi\u1ebft b\u00e0i n\u00e0y, c\u00f3 khi b\u1ea1n s\u1ebd ngh\u0129 nh\u01b0 tr\u00ean. Nh\u01b0ng \u0111\u1ecdc xong b\u00e0i n\u00e0y, b\u1ea1n s\u1ebd ch\u1ec9 m\u1ea5t ch\u01b0a \u0111\u1ebfn 30s \u0111\u1ec3 g\u1eedi k\u1ebft qu\u1ea3 cho s\u1ebfp. WTF? c\u00f3 th\u1eadt kh\u00f4ng v\u1eady?<\/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-6766f055c9fc5\" 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\/cong-thuc-sumifs-tinh-tong-hop-nhap-xuat-ton-bao-cao-kho.html#Yeu_cau_bao_cao_tong_hop_nhap_%E2%80%93_xuat_%E2%80%93_ton\" title=\"Y\u00eau c\u1ea7u b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p nh\u1eadp \u2013 xu\u1ea5t \u2013 t\u1ed3n\">Y\u00eau c\u1ea7u b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p nh\u1eadp \u2013 xu\u1ea5t \u2013 t\u1ed3n<\/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\/cong-thuc-sumifs-tinh-tong-hop-nhap-xuat-ton-bao-cao-kho.html#Cach_su_dung_ham_SUMIFS_trong_bao_cao_NXT\" title=\"C\u00e1ch\u00a0s\u1eed d\u1ee5ng h\u00e0m SUMIFS trong b\u00e1o c\u00e1o NXT\">C\u00e1ch\u00a0s\u1eed d\u1ee5ng h\u00e0m SUMIFS trong b\u00e1o c\u00e1o NXT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-sumifs-tinh-tong-hop-nhap-xuat-ton-bao-cao-kho.html#Nhan_xet\" title=\"Nh\u1eadn x\u00e9t\">Nh\u1eadn x\u00e9t<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Yeu_cau_bao_cao_tong_hop_nhap_%E2%80%93_xuat_%E2%80%93_ton\"><\/span>Y\u00eau c\u1ea7u b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p nh\u1eadp \u2013 xu\u1ea5t \u2013 t\u1ed3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 1 d\u1ea1ng b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p Nh\u1eadp \u2013 Xu\u1ea5t \u2013 T\u1ed3n cho 1 m\u1eb7t h\u00e0ng b\u1ea5t k\u1ef3 \u0111\u01b0\u1ee3c ch\u1ecdn ra t\u1eeb danh s\u00e1ch M\u00e3 h\u00e0ng. Trong \u0111\u00f3 y\u1ebfu t\u1ed1 th\u1eddi gian c\u00f3 th\u1ec3 thay \u0111\u1ed5i t\u00f9y \u00fd:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8075 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bao-cao-nxt-1-1024x399-1.jpg\" width=\"1024\" height=\"399\" title=\"bao-cao-nxt-1-1024x399-1\"><\/p>\n<ul>\n<li>\u0110\u1ed5i th\u1eddi gian =&gt; ra k\u1ebft qu\u1ea3 m\u1edbi<\/li>\n<li>\u0110\u1ed5i m\u00e3 h\u00e0ng =&gt; ra k\u1ebft qu\u1ea3 m\u1edbi<\/li>\n<\/ul>\n<p>Thay v\u00ec ch\u1ec9 1 d\u00f2ng m\u00e3 h\u00e0ng, \u0111\u01b0a t\u1ea5t c\u1ea3 c\u00e1c m\u00e3 h\u00e0ng kh\u00e1c v\u00e0o, filldown c\u00f4ng th\u1ee9c cho t\u1ea5t c\u1ea3 c\u00e1c m\u00e3 h\u00e0ng =&gt; b\u00f9m! c\u00f3 b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p cho c\u1ea3 kho h\u00e0ng lu\u00f4n. Qu\u00e1 tuy\u1ec7t v\u1eddi ph\u1ea3i kh\u00f4ng n\u00e0o? V\u1eady ch\u00fang ta s\u1ebd l\u00e0m \u0111i\u1ec1u \u0111\u00f3 nh\u01b0 th\u1ebf n\u00e0o? C\u00f4ng th\u1ee9c n\u00e0o gi\u00fap l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y? H\u00e3y \u0111\u1ecdc ti\u1ebfp n\u00e0o<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_SUMIFS_trong_bao_cao_NXT\"><\/span>C\u00e1ch\u00a0s\u1eed d\u1ee5ng h\u00e0m SUMIFS trong b\u00e1o c\u00e1o NXT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi ph\u00e2n t\u00edch y\u00eau c\u1ea7u b\u00e1o c\u00e1o, ch\u00fang ta s\u1ebd th\u1ea5y:<\/p>\n<ul>\n<li>Y\u00eau c\u1ea7u l\u00e0 t\u00ednh t\u1ed5ng =&gt; s\u1ebd li\u00ean quan t\u1edbi h\u00e0m t\u00ednh t\u1ed5ng (c\u00f3 ch\u1eef SUM)<\/li>\n<li>C\u00f3 k\u00e8m theo \u0111i\u1ec1u ki\u1ec7n =&gt; s\u1ebd li\u00ean quan t\u1edbi IF<\/li>\n<li>C\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac =&gt; IF s\u1ed1 nhi\u1ec1u, l\u00e0 IFS<\/li>\n<\/ul>\n<p>=&gt; K\u1ebft h\u1ee3p l\u1ea1i, c\u00e1i ta c\u1ea7n bi\u1ebft \u1edf \u0111\u00e2y l\u00e0 h\u00e0m SUMIFS<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-632.gif\" title=\"ex101_92019-nho-632\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-632.gif\" title=\"ex101_92019-nho-632\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>T\u1eeb phi\u00ean b\u1ea3n office 2007 tr\u1edf l\u00ean, excel cung c\u1ea5p cho ch\u00fang ta 1 c\u00f4ng c\u1ee5 r\u1ea5t m\u1ea1nh trong vi\u1ec7c t\u00ednh to\u00e1n d\u1eef li\u1ec7u v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, \u0111\u00f3 l\u00e0\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-tinh-tong-excel.html\">h\u00e0m SUMIFS<\/a><\/p>\n<p><strong>C\u1ea5u tr\u00fac h\u00e0m n\u00e0y nh\u01b0 sau:<\/strong><\/p>\n<blockquote>\n<p>=SUMIFS(sum_range,criteria_range1,criteria1,[criteria_range2,criteria2],\u2026)<\/p>\n<\/blockquote>\n<ul>\n<li>sum_range :\u00a0V\u00f9ng t\u00ednh t\u1ed5ng \/ V\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh<\/li>\n<li>criteria_range1 :\u00a0V\u00f9ng ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n th\u1ee9 nh\u1ea5t<\/li>\n<li>criteria1 :\u00a0\u0110i\u1ec1u ki\u1ec7n th\u1ee9 1 (n\u1eb1m trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n th\u1ee9 1)<\/li>\n<li>criteria_rang2 :\u00a0V\u00f9ng ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai (c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng)<\/li>\n<li>criteria2 :\u00a0\u0110i\u1ec1u ki\u1ec7n th\u1ee9 2 (n\u1eb1m trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n th\u1ee9 2, c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng. N\u1ebfu c\u00f3 Criteria_range2 th\u00ec bu\u1ed9c ph\u1ea3i c\u00f3 Criteria2)<\/li>\n<\/ul>\n<p><em>\u0110i\u1ec1u ki\u1ec7n th\u1ee9 n vi\u1ebft t\u01b0\u01a1ng t\u1ef1 \u0111i\u1ec1u ki\u1ec7n th\u1ee9 2<\/em><\/p>\n<p>=&gt; T\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi tr\u00ean c\u00f9ng 1 d\u00f2ng<\/p>\n<p><strong>Ph\u00e2n t\u00edch c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m<\/strong><\/p>\n<p>Ta g\u1ecdi t\u00ean c\u00e1c v\u00f9ng trong b\u1ea3ng c\u1ea7n t\u00ednh (A2:G22) nh\u01b0 sau: (ch\u1ee9c n\u0103ng \u0111\u1eb7t t\u00ean: Formulas\/Name Manager\/Define Name \u2013 c\u00f4ng vi\u1ec7c n\u00e0y gi\u00fap cho vi\u1ec7c ph\u00e2n t\u00edch c\u00f4ng th\u1ee9c d\u1ec5 hi\u1ec3u h\u01a1n)<\/p>\n<table style=\"width: 548px\">\n<tbody>\n<tr>\n<td style=\"width: 189px\">N\u1ed9i dung<\/td>\n<td style=\"width: 183px\">T\u00ean s\u1eed d\u1ee5ng<\/td>\n<td style=\"width: 166px\">T\u1ecda \u0111\u1ed9<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 189px\">C\u1ed9t M\u00e3 h\u00e0ng<\/td>\n<td style=\"width: 183px\">Cot_MaHang<\/td>\n<td style=\"width: 166px\">$B$3:$B$22<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 189px\">C\u1ed9t T\u00ean h\u00e0ng<\/td>\n<td style=\"width: 183px\">Cot_TenHang<\/td>\n<td style=\"width: 166px\">$C$3:$C$22<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 189px\">C\u1ed9t Ng\u00e0y<\/td>\n<td style=\"width: 183px\">Cot_Ngay<\/td>\n<td style=\"width: 166px\">$E$3:$E$22<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 189px\">C\u1ed9t S\u1ed1 l\u01b0\u1ee3ng nh\u1eadp<\/td>\n<td style=\"width: 183px\">Cot_Nhap<\/td>\n<td style=\"width: 166px\">$F$3:$F$22<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 189px\">C\u1ed9t S\u1ed1 l\u01b0\u1ee3ng xu\u1ea5t<\/td>\n<td style=\"width: 183px\">Cot_Xuat<\/td>\n<td style=\"width: 166px\">$G$3:$G$22<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u1ede \u0111\u00e2y c\u00f3 1 kh\u00e1i ni\u1ec7m l\u00e0 \u201cK\u1ef3\u201d. \u0110\u00e2y l\u00e0 thu\u1eadt ng\u1eef k\u1ebf to\u00e1n, c\u00f3 h\u00e0m \u00fd ch\u1ec9 1 kho\u1ea3ng th\u1eddi gian x\u00e1c \u0111\u1ecbnh, c\u00f3 \u0111i\u1ec3m \u0111\u1ea7u k\u1ef3 v\u00e0 \u0111i\u1ec3m cu\u1ed1i k\u1ef3.<\/p>\n<p>\u0110\u1ea7u k\u1ef3: L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng T\u1eeb ng\u00e0y (\u00d4 J3 trong h\u00ecnh b\u00ean tr\u00ean)<\/p>\n<p>Cu\u1ed1i k\u1ef3: Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng \u0110\u1ebfn ng\u00e0y (\u00d4 J4 trong h\u00ecnh b\u00ean tr\u00ean)<\/p>\n<p>Trong k\u1ef3: Kho\u1ea3ng th\u1eddi gian t\u1eeb J3 \u0111\u1ebfn J4. \u0110\u00e2y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 1 k\u1ef3.<\/p>\n<p><strong>T\u1ed5ng nh\u1eadp trong k\u1ef3 <\/strong><\/p>\n<blockquote>\n<p>=SUMIFS(Cot_Nhap,Cot_MaHang,$C$33,Cot_Ngay,\u201d&gt;=\u201d&amp;$C$31,Cot_Ngay,\u201d&lt;=\u201d&amp;$C$32)<\/p>\n<\/blockquote>\n<table width=\"816\">\n<tbody>\n<tr>\n<td width=\"135\">sum_range<\/td>\n<td width=\"151\">Cot_Nhap<\/td>\n<td colspan=\"6\" width=\"530\">l\u00e0 c\u1ed9t ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng nh\u1eadp, do k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh l\u00e0 T\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng nh\u1eadp<\/td>\n<\/tr>\n<tr>\n<td>criteria_range1<\/td>\n<td>Cot_MaHang<\/td>\n<td colspan=\"6\" rowspan=\"2\">\u0110i\u1ec1u ki\u1ec7n th\u1ee9 1 l\u00e0 m\u00e3 h\u00e0ng ph\u1ea3i l\u00e0 m\u00e3 ch\u1ecdn \u1edf \u00f4 C33<\/td>\n<\/tr>\n<tr>\n<td>criteria1<\/td>\n<td>\u00f4 C33<\/td>\n<\/tr>\n<tr>\n<td>criteria_range2<\/td>\n<td>Cot_Ngay<\/td>\n<td colspan=\"6\" rowspan=\"2\">\u0110i\u1ec1u ki\u1ec7n th\u1ee9 2 l\u00e0 Ng\u00e0y nh\u1eadp ph\u1ea3i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng T\u1eeb ng\u00e0y<\/td>\n<\/tr>\n<tr>\n<td>criteria2<\/td>\n<td>\u00f4 C31 (T\u1eeb ng\u00e0y)<\/td>\n<\/tr>\n<tr>\n<td>criteria_range3<\/td>\n<td>Cot_Ngay<\/td>\n<td colspan=\"6\" rowspan=\"2\">\u0110i\u1ec1u ki\u1ec7n th\u1ee9 3 l\u00e0 Ng\u00e0y nh\u1eadp ph\u1ea3i nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng \u0110\u1ebfn ng\u00e0y<\/td>\n<\/tr>\n<tr>\n<td>criteria3<\/td>\n<td>\u00f4 C32 (\u0110\u1ebfn ng\u00e0y)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>L\u01b0u \u00fd: C\u00f9ng l\u00e0 \u0111i\u1ec1u ki\u1ec7n ng\u00e0y, nh\u01b0ng c\u00f3 2 n\u1ed9i dung n\u00ean ph\u1ea3i t\u00e1ch ra th\u00e0nh 2 \u0111i\u1ec1u ki\u1ec7n. Kh\u00f4ng \u0111\u01b0\u1ee3c gh\u00e9p l\u00e0m 1 s\u1ebd kh\u00f4ng \u0111\u00fang<\/p>\n<p><strong>T\u1ed5ng xu\u1ea5t trong k\u1ef3 <\/strong><\/p>\n<blockquote>\n<p>=SUMIFS(Cot_Xuat,Cot_MaHang,$C$33,Cot_Ngay,\u201d&gt;=\u201d&amp;$C$31,Cot_Ngay,\u201d&lt;=\u201d&amp;$C$32)<\/p>\n<\/blockquote>\n<p><strong>T\u1ed3n \u0111\u1ea7u k\u1ef3<\/strong><\/p>\n<p>T\u1ed3n \u0111\u1ea7u k\u1ef3 \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0: T\u1ed5ng nh\u1eadp cho t\u1edbi tr\u01b0\u1edbc k\u1ef3 n\u00e0y (tr\u01b0\u1edbc th\u1eddi \u0111i\u1ec3m \u0111\u1ea7u k\u1ef3)\u00a0\u2013 T\u1ed5ng xu\u1ea5t cho t\u1edbi tr\u01b0\u1edbc\u00a0k\u1ef3 n\u00e0y (tr\u01b0\u1edbc th\u1eddi \u0111i\u1ec3m \u0111\u1ea7u k\u1ef3)<\/p>\n<p style=\"padding-left: 30px\"><strong>T\u1ed5ng nh\u1eadp \u0111\u1ea7u k\u1ef3<\/strong> =SUMIFS(Cot_Nhap,Cot_MaHang,$C$33,Cot_Ngay,\u201d&lt;\u201c&amp;$C$31)<\/p>\n<p style=\"padding-left: 30px\"><strong>T\u1ed5ng xu\u1ea5t \u0111\u1ea7u k\u1ef3<\/strong> =SUMIFS(Cot_Xuat,Cot_MaHang,$C$33,Cot_Ngay,\u201d&lt;\u201c&amp;$C$32)<\/p>\n<p style=\"padding-left: 30px\"><strong>T\u1ed3n \u0111\u1ea7u k\u1ef3<\/strong> = SUMIFS(Cot_Nhap,Cot_MaHang,$C$33,Cot_Ngay,\u201d&lt;\u201c&amp;$C$31)-SUMIFS(Cot_Xuat,Cot_MaHang,$C$33,Cot_Ngay,\u201d&lt;\u201c&amp;$C$31)<\/p>\n<p><strong>T\u1ed3n cu\u1ed1i k\u1ef3<\/strong><\/p>\n<p>T\u1ed3n cu\u1ed1i k\u1ef3 \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0: T\u1ed3n \u0111\u1ea7u k\u1ef3 + T\u1ed5ng nh\u1eadp trong k\u1ef3 \u2013 T\u1ed5ng xu\u1ea5t trong k\u1ef3<\/p>\n<p>\u1ede \u0111\u00e2y ta \u0111\u00e3 t\u00ednh \u0111\u01b0\u1ee3c c\u1ee5 th\u1ec3 c\u1ea3 3 ch\u1ec9 ti\u00eau tr\u00ean, do \u0111\u00f3 ch\u1ec9 c\u1ea7n l\u1ea5y c\u00e1c v\u1ecb tr\u00ed \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh l\u00e0 \u0111\u01b0\u1ee3c.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhan_xet\"><\/span>Nh\u1eadn x\u00e9t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Sumifs l\u00e0 1 c\u00f4ng th\u1ee9c hay, m\u1ea1nh m\u1ebd, d\u1ec5 s\u1eed d\u1ee5ng. \u00c1p d\u1ee5ng \u0111\u01b0\u1ee3c trong r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p. Th\u1eadm ch\u00ed c\u00f3 th\u1ec3 thay th\u1ebf ho\u00e0n to\u00e0n cho h\u00e0m sumif.<\/li>\n<li>L\u01b0u \u00fd l\u00e0 SUMIFS ch\u1ec9 d\u00f9ng \u0111\u01b0\u1ee3c tr\u00ean phi\u00ean b\u1ea3n office 2007 tr\u1edf l\u00ean.<\/li>\n<li>Trong c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd kho, \u0111\u00f4i khi h\u00e0m n\u00e0y c\u00f2n \u0111\u01b0\u1ee3c d\u00f9ng thay th\u1ebf cho h\u00e0m \u0111\u1ebfm (<a href=\"http:\/\/blog.ezworkapp.com\/ham-countifs-dem-theo-nhieu-dieu-kien.html\">countif \/ countifs)<\/a><\/li>\n<li>H\u00e0m n\u00e0y th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng Nh\u1eadp \/ Xu\u1ea5t \/ T\u1ed3n trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p.<\/li>\n<li>H\u00e0m t\u01b0\u01a1ng \u0111\u01b0\u01a1ng: <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">SUMPRODUCT<\/a>. Nh\u01b0ng so v\u1ec1 t\u1ed1c \u0111\u1ed9 v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng th\u00ec SUMIFS c\u00f3 nhi\u1ec1u l\u1ee3i th\u1ebf h\u01a1n.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u h\u00e0m n\u00e2ng cao trong Excel c\u0169ng nh\u01b0 s\u1eed d\u1ee5ng t\u1ed1t h\u01a1n c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, c\u00e1c b\u1ea1n h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2wasFJG\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/a> c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, gi\u00fap b\u1ea1n ph\u00e1t tri\u1ec3n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng. \u0110\u1eb7c bi\u1ec7t kh\u00f3a h\u1ecdc n\u00e0y kh\u00f4ng gi\u1edbi h\u1ea1n th\u1eddi gian h\u1ecdc t\u1eadp, n\u00ean b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc tho\u1ea3i m\u00e1i v\u00e0 xem l\u1ea1i b\u1ea5t c\u1ee9 khi n\u00e0o.<\/p>\n<p>Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. 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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-632.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7029,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7028","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7028","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=7028"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7028\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7029"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}