{"id":23221,"date":"2021-04-20T09:48:08","date_gmt":"2021-04-20T02:48:08","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=23221"},"modified":"2021-10-19T16:40:24","modified_gmt":"2021-10-19T09:40:24","slug":"ham-sumif-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-sumif-trong-excel\/","title":{"rendered":"H\u00e0m Sumif trong Excel: C\u00fa Ph\u00e1p v\u00e0 C\u00e1ch S\u1eed D\u1ee5ng \u0110\u01a1n Gi\u1ea3n"},"content":{"rendered":"<p>H\u00e0m Sumif trong Excel ch\u1eafc h\u1eb3n l\u00e0 h\u00e0m \u0111\u00e3 qu\u00e1 quen thu\u1ed9c v\u1edbi d\u00e2n v\u0103n ph\u00f2ng hi\u1ec7n nay, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng ng\u01b0\u1eddi l\u00e0m k\u1ebf to\u00e1n. H\u00e0m Sumif hay c\u00f2n g\u1ecdi h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh. Tuy nhi\u00ean v\u1edbi nh\u1eefng ng\u01b0\u1eddi m\u1edbi s\u1eed d\u1ee5ng excel th\u00ec s\u1eed d\u1ee5ng h\u00e0m kh\u00e1 l\u00e0 kh\u00f3 kh\u0103n. Tuy nhi\u00ean b\u1ea1n c\u0169ng \u0111\u1eebng qu\u00e1 lo l\u1eafng, trong b\u00e0i vi\u1ebft n\u00e0y Ben s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumif m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t.<\/p>\n<figure id=\"attachment_16564\" aria-describedby=\"caption-attachment-16564\" style=\"width: 632px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-16564 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-2.jpg\" alt=\"H\u00e0m Sumif trong Excel\" width=\"632\" height=\"313\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-2.jpg 632w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-2-300x149.jpg 300w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><figcaption id=\"caption-attachment-16564\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumif trong excel<\/figcaption><\/figure>\n<h2><strong>I. C\u00fa ph\u00e1p h\u00e0m Sumif trong Excel\u00a0<\/strong><\/h2>\n<p>H\u00e0m Sumif \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m to\u00e1n h\u1ecdc trong Excel, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 th\u1ecfa m\u00e3n, kh\u1edbp v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 cho. Ngo\u00e0i ra h\u00e0m Sumif c\u0169ng h\u1ed7 tr\u1ee3 c\u00e1c to\u00e1n t\u1eed logic (bao g\u1ed3m &gt;, &lt;, &lt;&gt;, =) c\u0169ng nh\u01b0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (*,?).<\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m Sumif Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong>=SUMIF(range, criteria, [sum_range])<\/strong><\/p>\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n<p><strong>1. Range<\/strong> (tham s\u1ed1 b\u1eaft bu\u1ed9c): L\u00e0 ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 ch\u00fang ta mu\u1ed1n \u0111\u00e1nh gi\u00e1 theo ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 cho trong tham s\u1ed1 Criteria.<\/p>\n<p><strong>2. Criteria<\/strong> (tham s\u1ed1 b\u1eaft bu\u1ed9c): L\u00e0 ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0:<\/p>\n<p>&#8211; Gi\u00e1 tr\u1ecb s\u1ed1 (c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 nguy\u00ean, s\u1ed1 th\u1eadp ph\u00e2n, ng\u00e0y gi\u1edd ho\u1eb7c gi\u00e1 tr\u1ecb logic, ch\u1eb3ng h\u1ea1n nh\u01b0 10, 01\/01\/2018 ho\u1eb7c TRUE.<\/p>\n<p>&#8211; Chu\u1ed7i v\u0103n b\u1ea3n, ch\u1eb3ng h\u1ea1n nh\u01b0 BenComputer.<\/p>\n<p>&#8211; Ho\u1eb7c bi\u1ec3u th\u1ee9c, ch\u1eb3ng h\u1ea1n &#8220;&gt;12&#8221; ho\u1eb7c &#8220;&lt;&gt;0&#8221;, &#8230; .<\/p>\n<p><strong>3. Sum_range<\/strong> (tham s\u1ed1 t\u00f9y ch\u1ecdn): L\u00e0 m\u1ea3ng c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 (ho\u1eb7c c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1) \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng n\u1ebfu ph\u1ea1m vi t\u01b0\u01a1ng \u1ee9ng \u0111\u00e1p \u1ee9ng, th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n (ti\u00eau ch\u00ed) \u0111\u00e3 cho. Trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu tham s\u1ed1 sum_range b\u1ecb b\u1ecf qua, c\u00e1c gi\u00e1 tr\u1ecb tham s\u1ed1 Range s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng.<\/p>\n<figure id=\"attachment_39171\" aria-describedby=\"caption-attachment-39171\" style=\"width: 671px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-39171 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/ham-sumif-trong-excel.jpg\" alt=\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \" width=\"671\" height=\"408\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/ham-sumif-trong-excel.jpg 671w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/ham-sumif-trong-excel-300x182.jpg 300w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><figcaption id=\"caption-attachment-39171\" class=\"wp-caption-text\">H\u00e0m Sumif t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<h2><strong>II. V\u00ed d\u1ee5 v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a H\u00e0m Sumif<\/strong><\/h2>\n<p>V\u00ed d\u1ee5 b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh Excel c\u00e1c lo\u1ea1i th\u1ef1c ph\u1ea9m v\u00e0 b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a nh\u00f3m tr\u00e1i c\u00e2y trong b\u1ea3ng t\u00ednh. B\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> Trong b\u1ea3ng t\u00ednh Excel b\u1ea1n nh\u1eadp v\u00e0o \u00f4 tham chi\u1ebfu c\u1ea7n cho hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb h\u00e0m sau: <strong>=SUMIF(B2:B8,&#8221;Tr\u00e1i c\u00e2y&#8221;,E2:E8).\u00a0<\/strong><\/li>\n<\/ul>\n<p>Trong \u0111\u00f3: <strong>SUMIF<\/strong> l\u00e0 h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/p>\n<p><strong>B2:B8 <\/strong>l\u00e0 v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb<\/p>\n<p><strong>&#8220;Tr\u00e1i c\u00e2y&#8221;<\/strong> l\u00e0 \u0111i\u1ec1u ki\u1ec7n y\u00eau c\u1ea7u c\u1ee7a b\u00e0i to\u00e1n<\/p>\n<p><strong>E2:E8 <\/strong>l\u00e0 v\u00f9ng d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3<\/p>\n<figure id=\"attachment_39161\" aria-describedby=\"caption-attachment-39161\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-39161 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/ham-sumif.jpg\" alt=\"H\u00e0m Sumif\" width=\"800\" height=\"358\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/ham-sumif.jpg 800w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/ham-sumif-300x134.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/ham-sumif-768x344.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/ham-sumif-750x336.jpg 750w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-39161\" class=\"wp-caption-text\">Nh\u1eadp h\u00e0m v\u00e0o \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3<\/figcaption><\/figure>\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<figure id=\"attachment_39166\" aria-describedby=\"caption-attachment-39166\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-39166 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/cach-dung-ham-sumif.jpg\" alt=\"C\u00e1ch d\u00f9ng h\u00e0m sumif\" width=\"800\" height=\"342\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/cach-dung-ham-sumif.jpg 800w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/cach-dung-ham-sumif-300x128.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/cach-dung-ham-sumif-768x328.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/04\/cach-dung-ham-sumif-750x321.jpg 750w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-39166\" class=\"wp-caption-text\">Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3<\/figcaption><\/figure>\n<h2><strong>III. S\u1eeda l\u1ed7i h\u00e0m Sumif trong Excel kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt<\/strong><\/h2>\n<p>Nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i h\u00e0m sumif trong Excel kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt c\u00f3 th\u1ec3 l\u00e0 do b\u1ea1n ch\u01b0a k\u00edch ho\u1ea1t t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i h\u00e0m sumif kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt, gi\u1ea3i ph\u00e1p l\u00e0 k\u00edch ho\u1ea1t t\u00ednh n\u0103ng n\u00e0y.<\/p>\n<p><em>Th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/em><\/p>\n<p><strong><em>B\u01b0\u1edbc 1<\/em><\/strong>: Tr\u00ean Excel 2007, click ch\u1ecdn <strong>n\u00fat Office<\/strong> r\u1ed3i click ch\u1ecdn <strong>Excel Options<\/strong>. Tr\u00ean Excel 2010, click ch\u1ecdn <strong>File<\/strong> =&gt; <strong>Options.<\/strong><\/p>\n<p><strong><em>B\u01b0\u1edbc 2<\/em><\/strong>: Tr\u00ean h\u1ed9p tho\u1ea1i Excel Options, t\u00ecm v\u00e0 click ch\u1ecdn <strong>Formulas<\/strong> \u1edf khung b\u00ean tr\u00e1i.<\/p>\n<p><em><strong>B\u01b0\u1edbc 3<\/strong>:<\/em> Trong m\u1ee5c <strong>Calculation Option<\/strong>s, t\u00ecm v\u00e0 \u0111\u00e1nh t\u00edch ch\u1ecdn t\u00f9y ch\u1ecdn<strong> Automatic<\/strong>.<\/p>\n<figure id=\"attachment_16565\" aria-describedby=\"caption-attachment-16565\" style=\"width: 632px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-16565 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-2.jpg\" alt=\"H\u00e0m Sumif trong Excel\" width=\"632\" height=\"485\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-2.jpg 632w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-2-300x230.jpg 300w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><figcaption id=\"caption-attachment-16565\" class=\"wp-caption-text\">S\u1eeda l\u1ed7i h\u00e0m sumif trong Excel kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt<\/figcaption><\/figure>\n<p><em><strong>B\u01b0\u1edbc 4<\/strong>:<\/em> Cu\u1ed1i c\u00f9ng click ch\u1ecdn <strong>OK<\/strong> \u0111\u1ec3 l\u01b0u l\u1ea1i thay \u0111\u1ed5i v\u00e0 ki\u1ec3m tra xem l\u1ed7i h\u00e0m sumif trong Excel c\u00f2n hay kh\u00f4ng.<br \/>\nNgo\u00e0i ra n\u1ebfu l\u1ed7i h\u00e0m sumif v\u1eabn c\u00f2n, gi\u1ea3i ph\u00e1p ti\u1ebfp theo l\u00e0 ki\u1ec3m tra c\u00f4ng th\u1ee9c, c\u00fa ph\u00e1p h\u00e0m Excel xem \u0111\u00fang hay ch\u01b0a.<\/p>\n<h2><strong>IV. M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m Sumif<\/strong><\/h2>\n<p>C\u00f3 nhi\u1ec1u nguy\u00ean nh\u00e2n khi\u1ebfn h\u00e0m sumif trong Excel b\u1ecb l\u1ed7i, kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3. C\u1ee5 th\u1ec3:<\/p>\n<ol>\n<li>N\u1ebfu h\u00e0m sumif tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A ho\u1eb7c c\u00e1c l\u1ed7i kh\u00e1c t\u01b0\u01a1ng t\u1ef1, r\u1ea5t c\u00f3 th\u1ec3 c\u00f4ng th\u1ee9c h\u00e0m sumif Excel m\u00e0 b\u1ea1n \u0111ang s\u1eed d\u1ee5ng ch\u01b0a ch\u00ednh x\u00e1c. \u0110\u1ec3 \u0111\u00e1nh gi\u00e1 c\u00f4ng th\u1ee9c, \u0111\u1ea7u ti\u00ean ch\u1ecdn c\u00f4ng th\u1ee9c h\u00e0m Excel c\u1ee7a b\u1ea1n v\u00e0 click ch\u1ecdn <strong>tab Formula<\/strong> tr\u00ean thanh Ribbon. T\u1ea1i \u0111\u00e2y t\u00ecm v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn<strong> Evaluate Formula<\/strong>, t\u00f9y ch\u1ecdn n\u00e0y n\u1eb1m trong m\u1ee5c <strong>Auditing.<\/strong><\/li>\n<li>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p c\u00f4ng th\u1ee9c h\u00e0m Excel kh\u00f4ng b\u1ecb l\u1ed7i m\u00e0 l\u00e0 do b\u1ea1n c\u1eadp nh\u1eadt trang t\u00ednh, d\u1eabn \u0111\u1ebfn h\u00e0m sumif trong Excel kh\u00f4ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u00e3 c\u1eadp nh\u1eadt. Nh\u1ea5n ph\u00edm F9 \u0111\u1ec3 Excel t\u00ednh to\u00e1n l\u1ea1i c\u00f4ng th\u1ee9c sau m\u1ed7i l\u1ea7n t\u00ednh.<\/li>\n<\/ol>\n<hr \/>\n<p>Nh\u01b0 v\u1eady b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t s\u1ed1 c\u00e1ch s\u1eeda l\u1ed7i<strong> h\u00e0m sumif trong Excel <\/strong>kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt<strong>.<\/strong> B\u1ea1n c\u00f3 \u0111ang ph\u1ea3i \u0111\u1ed1i m\u1eb7t v\u1edbi l\u1ed7i Excel n\u00e0y, \u0111\u1eebng qu\u00ean chia s\u1ebb \u00fd ki\u1ebfn c\u1ee7a b\u1ea1n cho Ben Computer nh\u00e9.<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean trang \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1ch c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Value trong Excel nh\u00e9.<\/p>\n<p><em>M\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft li\u00ean quan Excel hay:<\/em><\/p>\n<ul>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-tinh-so-ngay\/\">Chia s\u1ebb c\u00e1ch vi\u1ebft h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y trong Excel nhanh ch\u00f3ng kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/khoa-file-excel\/\">Chia s\u1ebb 3 c\u00e1ch kh\u00f3a file excel nhanh ch\u00f3ng cho nh\u1eefng ai ch\u01b0a bi\u1ebft<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/chen-anh-vao-excel\/\">Chia s\u1ebb 3 c\u00e1ch ch\u00e8n \u1ea3nh v\u00e0o Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Sumif trong Excel ch\u1eafc h\u1eb3n l\u00e0 h\u00e0m \u0111\u00e3 qu\u00e1 quen thu\u1ed9c v\u1edbi d\u00e2n v\u0103n ph\u00f2ng hi\u1ec7n nay, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng ng\u01b0\u1eddi l\u00e0m k\u1ebf to\u00e1n. H\u00e0m Sumif hay c\u00f2n g\u1ecdi h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh. Tuy nhi\u00ean v\u1edbi nh\u1eefng [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":23222,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-23221","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/23221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=23221"}],"version-history":[{"count":3,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/23221\/revisions"}],"predecessor-version":[{"id":39173,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/23221\/revisions\/39173"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/23222"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=23221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=23221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=23221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}