{"id":456900,"date":"2025-05-24T20:42:40","date_gmt":"2025-05-24T13:42:40","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=456900"},"modified":"2025-05-24T20:42:40","modified_gmt":"2025-05-24T13:42:40","slug":"ham-sumif-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/","title":{"rendered":"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft"},"content":{"rendered":"<p><strong data-start=\"131\" data-end=\"156\">H\u00e0m SUMIF trong Excel<\/strong> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u1ef1c k\u1ef3 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong b\u1ea3ng t\u00ednh. Thay v\u00ec ph\u1ea3i l\u1ecdc d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng r\u1ed3i c\u1ed9ng t\u1eebng gi\u00e1 tr\u1ecb b\u1eb1ng tay, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng t\u00ednh t\u1ed5ng theo m\u1ed9t ti\u00eau ch\u00ed x\u00e1c \u0111\u1ecbnh. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m th\u1ed1ng k\u00ea ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel, gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng SUMIF, t\u1eeb c\u00fa ph\u00e1p c\u01a1 b\u1ea3n \u0111\u1ebfn c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3, \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c th\u1ef1c t\u1ebf.<\/p>\n<h2><b>H\u00e0m SUMIF trong Excel l\u00e0 g\u00ec?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">SUMIF trong Excel l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n <\/span><b>t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u<\/b><span style=\"font-weight: 400;\"> m\u00e0 <\/span><b>th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3<\/b><span style=\"font-weight: 400;\">. H\u00e0m n\u00e0y gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn v\u00e0 nhanh ch\u00f3ng t\u00ednh t\u1ed5ng m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i l\u1ecdc th\u1ee7 c\u00f4ng ho\u1eb7c ph\u00e2n t\u00edch t\u1eebng gi\u00e1 tr\u1ecb m\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u1ee5 th\u1ec3, SUMIF cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng ch\u1ec9 cho nh\u1eefng gi\u00e1 tr\u1ecb trong ph\u1ea1m vi m\u00e0 \u0111\u00e1p \u1ee9ng <\/span><b>m\u1ed9t \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh<\/b><span style=\"font-weight: 400;\">. \u0110i\u1ec1u ki\u1ec7n n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1, v\u0103n b\u1ea3n, ho\u1eb7c m\u1ed9t ph\u00e9p so s\u00e1nh.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-01.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-01-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-01-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-456903 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-01.jpg\" alt=\"ham-sumif-trong-excel-01\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-01.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-01-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-01-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>C\u00f4ng d\u1ee5ng c\u1ee7a SUMIF:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh t\u1ed5ng c\u00e1c kho\u1ea3n doanh thu, chi ti\u00eau, ho\u1eb7c l\u01b0\u01a1ng c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean trong m\u1ed9t ph\u00f2ng ban, ho\u1eb7c nh\u1eefng m\u1ee5c ti\u00eau \u0111\u00e1p \u1ee9ng m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ed5ng h\u1ee3p c\u00e1c s\u1ed1 li\u1ec7u c\u1ee7a s\u1ea3n ph\u1ea9m, khu v\u1ef1c b\u00e1n h\u00e0ng, hay c\u00e1c th\u1eddi k\u1ef3 kh\u00e1c nhau trong b\u00e1o c\u00e1o t\u00e0i ch\u00ednh, b\u00e1o c\u00e1o b\u00e1n h\u00e0ng\u2026<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Nh\u1edd c\u00f3 SUMIF, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng \u0111\u01b0a ra c\u00e1c ph\u00e2n t\u00edch t\u1eeb d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i vi\u1ebft c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p. H\u00e0m n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi x\u1eed l\u00fd c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u00e0 y\u00eau c\u1ea7u t\u00ednh to\u00e1n t\u1ed5ng h\u1ee3p tr\u00ean m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng l\u1edbn c\u00e1c gi\u00e1 tr\u1ecb.<\/span><\/p>\n<h2><b>C\u00f4ng th\u1ee9c h\u00e0m SUMIF trong Excel chu\u1ea9n x\u00e1c<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">SUMIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi (range) n\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 <\/span><b>th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3<\/b><span style=\"font-weight: 400;\">. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m h\u1eefu \u00edch nh\u1ea5t khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u c\u00f3 t\u00ednh ph\u00e2n lo\u1ea1i ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n l\u1ecdc.<\/span><\/p>\n<p><b>C\u00fa ph\u00e1p c\u1ee7a SUMIF:<\/b><span style=\"font-weight: 400;\"> =SUMIF(range, criteria, [sum_range])<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-02.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-02-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-02-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-456904 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-02.jpg\" alt=\"ham-sumif-trong-excel-02\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-02.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-02-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-02-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Trong \u0111\u00f3:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>range<\/b><span style=\"font-weight: 400;\">: V\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n. \u0110\u00e2y l\u00e0 ph\u1ea1m vi ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n s\u1ebd so s\u00e1nh v\u1edbi \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>criteria<\/b><span style=\"font-weight: 400;\">: \u0110i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ec3 l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi range. \u0110i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n, to\u00e1n t\u1eed so s\u00e1nh (nh\u01b0 &gt;, &lt;, =), ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 kh\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>sum_range<\/b><span style=\"font-weight: 400;\"> (t\u00f9y ch\u1ecdn): V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng. N\u1ebfu kh\u00f4ng c\u00f3, Excel s\u1ebd t\u00ednh t\u1ed5ng tr\u1ef1c ti\u1ebfp tr\u00ean range.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: criteria c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, bi\u1ec3u th\u1ee9c logic (&gt;, &lt;, =), v\u0103n b\u1ea3n, tham chi\u1ebfu \u00f4 ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n nh\u01b0 *, ?.<\/span><\/p>\n<h2><b>C\u00e1c v\u00ed d\u1ee5 minh h\u1ecda c\u00e1ch d\u00f9ng h\u00e0m SUMIF trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c hi\u1ec3u c\u00fa ph\u00e1p l\u00e0 ch\u01b0a \u0111\u1ee7, b\u1ea1n c\u1ea7n luy\u1ec7n t\u1eadp v\u1edbi c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf \u0111\u1ec3 \u00e1p d\u1ee5ng nhu\u1ea7n nhuy\u1ec5n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 v\u00ed d\u1ee5 ti\u00eau bi\u1ec3u:<\/span><\/p>\n<h3><b>V\u00ed d\u1ee5 1: T\u00ednh t\u1ed5ng doanh thu c\u1ee7a s\u1ea3n ph\u1ea9m &#8220;A&#8221;<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 doanh thu c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m nh\u01b0 sau:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>S\u1ea3n ph\u1ea9m<\/b><\/td>\n<td><b>Doanh thu<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">A<\/span><\/td>\n<td><span style=\"font-weight: 400;\">5,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">B<\/span><\/td>\n<td><span style=\"font-weight: 400;\">3,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">A<\/span><\/td>\n<td><span style=\"font-weight: 400;\">7,500<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">C<\/span><\/td>\n<td><span style=\"font-weight: 400;\">4,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">A<\/span><\/td>\n<td><span style=\"font-weight: 400;\">6,000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">B\u1ea1n mu\u1ed1n t\u00ednh <\/span><b>t\u1ed5ng doanh thu c\u1ee7a s\u1ea3n ph\u1ea9m &#8220;A&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 1:<\/b><span style=\"font-weight: 400;\"> Ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 t\u1ed5ng doanh thu c\u1ee7a s\u1ea3n ph\u1ea9m &#8220;A&#8221;. V\u00ed d\u1ee5: \u00f4 <\/span><b>C1<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-03-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-03-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-03-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-456906 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-03-1.jpg\" alt=\"ham-sumif-trong-excel-03\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-03-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-03-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-03-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>B\u01b0\u1edbc 2:<\/b><span style=\"font-weight: 400;\"> C\u00f4ng th\u1ee9c <b>h\u00e0m SUMIF trong Excel <\/b><\/span><span style=\"font-weight: 400;\">\u0111\u1ec3 t\u00ednh t\u1ed5ng doanh thu c\u1ee7a s\u1ea3n ph\u1ea9m &#8220;A&#8221; s\u1ebd nh\u01b0 sau: =SUMIF(A2:A6, &#8220;A&#8221;, B2:B6)<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-04.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-04-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-04-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-456913 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-04.jpg\" alt=\"ham-sumif-trong-excel-04\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-04.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-04-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-04-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>B\u01b0\u1edbc 3: <\/b><span style=\"font-weight: 400;\">Sau khi nh\u1eadp c\u00f4ng th\u1ee9c <b>h\u00e0m SUMIF <\/b>tr\u00ean v\u00e0 nh\u1ea5n <\/span><b>Enter<\/b><span style=\"font-weight: 400;\">, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 <\/span><b>18,500<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-05.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-05-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-05-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-456914 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-05.jpg\" alt=\"ham-sumif-trong-excel-05\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-05.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-05-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-05-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Gi\u1ea3i th\u00edch chi ti\u1ebft c\u00f4ng th\u1ee9c h\u00e0m SUMIF trong Excel:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>A2:A6<\/b><span style=\"font-weight: 400;\">: \u0110\u00e2y l\u00e0 ph\u1ea1m vi b\u1ea1n mu\u1ed1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n (t\u1ee9c l\u00e0 c\u1ed9t &#8220;S\u1ea3n ph\u1ea9m&#8221;). Excel s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb &#8220;A&#8221; trong ph\u1ea1m vi n\u00e0y.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>&#8220;A&#8221;<\/b><span style=\"font-weight: 400;\">: \u0110\u00e2y l\u00e0 <\/span><b>\u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\"> b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng. H\u00e0m s\u1ebd ch\u1ec9 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t &#8220;Doanh thu&#8221; (c\u1ed9t B) n\u1ebfu gi\u00e1 tr\u1ecb trong c\u1ed9t &#8220;S\u1ea3n ph\u1ea9m&#8221; l\u00e0 &#8220;A&#8221;.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>B2:B6<\/b><span style=\"font-weight: 400;\">: \u0110\u00e2y l\u00e0 ph\u1ea1m vi t\u00ednh t\u1ed5ng (t\u1ee9c l\u00e0 c\u1ed9t &#8220;Doanh thu&#8221;). Excel s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t n\u00e0y cho nh\u1eefng s\u1ea3n ph\u1ea9m th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u00e0 &#8220;A&#8221;.<\/span><\/li>\n<\/ul>\n<p><b>Chi ti\u1ebft t\u00ednh to\u00e1n:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u00f2ng 2: S\u1ea3n ph\u1ea9m l\u00e0 &#8220;A&#8221;, doanh thu l\u00e0 5,000.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u00f2ng 3: S\u1ea3n ph\u1ea9m l\u00e0 &#8220;A&#8221;, doanh thu l\u00e0 7,500.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u00f2ng 5: S\u1ea3n ph\u1ea9m l\u00e0 &#8220;A&#8221;, doanh thu l\u00e0 6,000.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">T\u1ed5ng doanh thu c\u1ee7a s\u1ea3n ph\u1ea9m &#8220;A&#8221; l\u00e0:\u00a0 <\/span><b>5,000 + 7,500 + 6,000 = 18,500<\/b><\/p>\n<h3><b>V\u00ed d\u1ee5 2: T\u00ednh t\u1ed5ng \u0111i\u1ec3m l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 8 v\u1edbi h\u00e0m SUMIF trong Excel<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 \u0111i\u1ec3m s\u1ed1 c\u1ee7a c\u00e1c h\u1ecdc sinh nh\u01b0 sau:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>H\u1ecdc sinh<\/b><\/td>\n<td><b>\u0110i\u1ec3m<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>Nam<\/b><\/td>\n<td><span style=\"font-weight: 400;\">7<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Lan<\/b><\/td>\n<td><span style=\"font-weight: 400;\">9<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>B\u00ecnh<\/b><\/td>\n<td><span style=\"font-weight: 400;\">8<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Hoa<\/b><\/td>\n<td><span style=\"font-weight: 400;\">10<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Minh<\/b><\/td>\n<td><span style=\"font-weight: 400;\">6<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">B\u1ea1n mu\u1ed1n t\u00ednh <\/span><b>t\u1ed5ng \u0111i\u1ec3m c\u1ee7a c\u00e1c h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m t\u1eeb 8 tr\u1edf l\u00ean<\/b><span style=\"font-weight: 400;\"> (t\u1ee9c l\u00e0 \u0111i\u1ec3m l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 8).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-06.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-06-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-06-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-457386 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-06.jpg\" alt=\"ham-sumif-trong-excel-06\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-06.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-06-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-06-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>C\u00f4ng th\u1ee9c h\u00e0m SUMIF trong Excel:<\/b><span style=\"font-weight: 400;\"> =SUMIF(B2:B6, &#8220;&gt;=8&#8221;)<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-07.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-07-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-07-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-457387 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-07.jpg\" alt=\"ham-sumif-trong-excel-07\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-07.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-07-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-07-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Gi\u1ea3i th\u00edch:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>B2:B6<\/b><span style=\"font-weight: 400;\">: \u0110\u00e2y l\u00e0 ph\u1ea1m vi m\u00e0 Excel s\u1ebd ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 c\u1ed9t &#8220;\u0110i\u1ec3m&#8221;.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>&#8220;&gt;=8&#8221;<\/b><span style=\"font-weight: 400;\">: \u0110i\u1ec1u ki\u1ec7n l\u00e0 \u0111i\u1ec3m ph\u1ea3i <\/span><b>l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 8<\/b><span style=\"font-weight: 400;\">. B\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft \u0111i\u1ec1u ki\u1ec7n n\u00e0y d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n (chu\u1ed7i k\u00fd t\u1ef1) ho\u1eb7c c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t \u00f4 tham chi\u1ebfu (v\u00ed d\u1ee5: &#8220;&gt;=&#8221;&amp;C1 n\u1ebfu \u00f4 C1 ch\u1ee9a gi\u00e1 tr\u1ecb 8).<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Sau khi nh\u1eadp c\u00f4ng th\u1ee9c <b>h\u00e0m SUMIF trong Excel <\/b>v\u00e0 nh\u1ea5n <\/span><b>Enter<\/b><span style=\"font-weight: 400;\">, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 <\/span><b>27<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-08.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-08-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-08-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-457388 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-08.jpg\" alt=\"ham-sumif-trong-excel-08\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-08.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-08-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-08-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Chi ti\u1ebft t\u00ednh to\u00e1n:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u1ecdc sinh <\/span><b>Lan<\/b><span style=\"font-weight: 400;\"> c\u00f3 \u0111i\u1ec3m 9, th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u1ecdc sinh <\/span><b>B\u00ecnh<\/b><span style=\"font-weight: 400;\"> c\u00f3 \u0111i\u1ec3m 8, th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u1ecdc sinh <\/span><b>Hoa<\/b><span style=\"font-weight: 400;\"> c\u00f3 \u0111i\u1ec3m 10, th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u1eady t\u1ed5ng \u0111i\u1ec3m c\u1ee7a c\u00e1c h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 8 l\u00e0:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span> <b>9 + 8 + 10 = 27<\/b><\/p>\n<h3><b>V\u00ed d\u1ee5 3: D\u00f9ng h\u00e0m SUMIF trong Excel t\u00ednh t\u1ed5ng l\u01b0\u01a1ng c\u1ee7a nh\u00e2n vi\u00ean \u1edf ph\u00f2ng &#8220;K\u1ebf to\u00e1n&#8221;<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 t\u00ean nh\u00e2n vi\u00ean, ph\u00f2ng ban v\u00e0 l\u01b0\u01a1ng nh\u01b0 sau:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>T\u00ean nh\u00e2n vi\u00ean<\/b><\/td>\n<td><b>Ph\u00f2ng ban<\/b><\/td>\n<td><b>L\u01b0\u01a1ng (VN\u0110)<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Nam<\/span><\/td>\n<td><span style=\"font-weight: 400;\">K\u1ebf to\u00e1n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">10,000,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Lan<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Marketing<\/span><\/td>\n<td><span style=\"font-weight: 400;\">8,000,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">B\u00ecnh<\/span><\/td>\n<td><span style=\"font-weight: 400;\">K\u1ebf to\u00e1n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">12,000,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Hoa<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Nh\u00e2n s\u1ef1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">7,500,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Minh<\/span><\/td>\n<td><span style=\"font-weight: 400;\">K\u1ebf to\u00e1n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">11,000,000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">B\u1ea1n mu\u1ed1n t\u00ednh <\/span><b>t\u1ed5ng l\u01b0\u01a1ng c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean l\u00e0m \u1edf ph\u00f2ng &#8220;K\u1ebf to\u00e1n&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> =SUMIF(B2:B6, &#8220;K\u1ebf to\u00e1n&#8221;, C2:C6)<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-09-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-09-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-09-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-457390 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-09-1.jpg\" alt=\"ham-sumif-trong-excel-09\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-09-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-09-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-09-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c h\u00e0m SUMIF trong Excel:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>B2:B6<\/b><span style=\"font-weight: 400;\">: \u0110\u00e2y l\u00e0 ph\u1ea1m vi m\u00e0 Excel s\u1ebd ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n (c\u1ed9t &#8220;Ph\u00f2ng ban&#8221;). Excel s\u1ebd t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb &#8220;K\u1ebf to\u00e1n&#8221; trong ph\u1ea1m vi n\u00e0y.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>&#8220;K\u1ebf to\u00e1n&#8221;<\/b><span style=\"font-weight: 400;\">: \u0110i\u1ec1u ki\u1ec7n l\u00e0 ph\u00f2ng ban ph\u1ea3i l\u00e0 &#8220;K\u1ebf to\u00e1n&#8221;. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 thay th\u1ebf \u0111i\u1ec1u ki\u1ec7n n\u00e0y b\u1eb1ng m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb &#8220;K\u1ebf to\u00e1n&#8221;, v\u00ed d\u1ee5: C1 ch\u1ee9a &#8220;K\u1ebf to\u00e1n&#8221; v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd l\u00e0 =SUMIF(B2:B6, C1, C2:C6).<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>C2:C6<\/b><span style=\"font-weight: 400;\">: \u0110\u00e2y l\u00e0 ph\u1ea1m vi t\u00ednh t\u1ed5ng, t\u1ee9c l\u00e0 c\u1ed9t &#8220;L\u01b0\u01a1ng&#8221;. Excel s\u1ebd c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi n\u00e0y n\u1ebfu ph\u00f2ng ban t\u01b0\u01a1ng \u1ee9ng l\u00e0 &#8220;K\u1ebf to\u00e1n&#8221;.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Sau khi nh\u1eadp c\u00f4ng th\u1ee9c tr\u00ean v\u00e0 nh\u1ea5n <\/span><b>Enter<\/b><span style=\"font-weight: 400;\">, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 <\/span><b>33,000,000 VN\u0110<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-457392 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-10.jpg\" alt=\"ham-sumif-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Chi ti\u1ebft t\u00ednh to\u00e1n:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u00e2n vi\u00ean <\/span><b>Nam<\/b><span style=\"font-weight: 400;\"> l\u00e0m \u1edf ph\u00f2ng &#8220;K\u1ebf to\u00e1n&#8221;, l\u01b0\u01a1ng l\u00e0 10,000,000 VN\u0110.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u00e2n vi\u00ean <\/span><b>B\u00ecnh<\/b><span style=\"font-weight: 400;\"> l\u00e0m \u1edf ph\u00f2ng &#8220;K\u1ebf to\u00e1n&#8221;, l\u01b0\u01a1ng l\u00e0 12,000,000 VN\u0110.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u00e2n vi\u00ean <\/span><b>Minh<\/b><span style=\"font-weight: 400;\"> l\u00e0m \u1edf ph\u00f2ng &#8220;K\u1ebf to\u00e1n&#8221;, l\u01b0\u01a1ng l\u00e0 11,000,000 VN\u0110.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">T\u1ed5ng l\u01b0\u01a1ng c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean \u1edf ph\u00f2ng &#8220;K\u1ebf to\u00e1n&#8221; l\u00e0: <\/span><b>10,000,000 + 12,000,000 + 11,000,000 = 33,000,000 VN\u0110<\/b><\/p>\n<h3><b>V\u00ed d\u1ee5 4: T\u00ednh t\u1ed5ng ti\u1ec1n c\u1ee7a c\u00e1c \u0111\u01a1n h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb d\u01b0\u1edbi 2 tri\u1ec7u b\u1eb1ng h\u00e0m SUMIF trong Excel<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 c\u00e1c \u0111\u01a1n h\u00e0ng nh\u01b0 sau:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>M\u00e3 \u0111\u01a1n h\u00e0ng<\/b><\/td>\n<td><b>Gi\u00e1 tr\u1ecb \u0111\u01a1n h\u00e0ng (VN\u0110)<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">DH001<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1,500,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">DH002<\/span><\/td>\n<td><span style=\"font-weight: 400;\">2,500,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">DH003<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1,200,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">DH004<\/span><\/td>\n<td><span style=\"font-weight: 400;\">3,000,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">DH005<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1,800,000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">B\u1ea1n mu\u1ed1n t\u00ednh <\/span><b>t\u1ed5ng ti\u1ec1n c\u1ee7a c\u00e1c \u0111\u01a1n h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb d\u01b0\u1edbi 2 tri\u1ec7u<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> =SUMIF(B2:B6, &#8220;&lt;2000000&#8221;)<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-457393 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-11.jpg\" alt=\"ham-sumif-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>B2:B6<\/b><span style=\"font-weight: 400;\">: \u0110\u00e2y l\u00e0 ph\u1ea1m vi m\u00e0 Excel s\u1ebd ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n (c\u1ed9t &#8220;Gi\u00e1 tr\u1ecb \u0111\u01a1n h\u00e0ng&#8221;).<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>&#8220;&lt;2000000&#8221;<\/b><span style=\"font-weight: 400;\">: \u0110i\u1ec1u ki\u1ec7n l\u00e0 gi\u00e1 tr\u1ecb \u0111\u01a1n h\u00e0ng ph\u1ea3i <\/span><b>d\u01b0\u1edbi 2 tri\u1ec7u<\/b><span style=\"font-weight: 400;\">. B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111i\u1ec1u ki\u1ec7n n\u00e0y t\u00f9y theo y\u00eau c\u1ea7u (v\u00ed d\u1ee5, <\/span><span style=\"font-weight: 400;\">&#8220;&lt;2000000&#8221;<\/span><span style=\"font-weight: 400;\"> l\u00e0 nh\u1ecf h\u01a1n 2 tri\u1ec7u, ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf \u0111i\u1ec1u ki\u1ec7n n\u00e0y b\u1eb1ng m\u1ed9t tham chi\u1ebfu \u00f4, nh\u01b0 <\/span><span style=\"font-weight: 400;\">&#8220;&lt;&#8220;&amp;C1<\/span><span style=\"font-weight: 400;\"> n\u1ebfu C1 ch\u1ee9a gi\u00e1 tr\u1ecb 2 tri\u1ec7u).<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Sau khi nh\u1eadp c\u00f4ng th\u1ee9c <b>h\u00e0m SUMIF trong Excel <\/b>v\u00e0 nh\u1ea5n <\/span><b>Enter<\/b><span style=\"font-weight: 400;\">, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 <strong>4<\/strong><\/span><b>,500,000 VN\u0110<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-457394 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-12.jpg\" alt=\"ham-sumif-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Chi ti\u1ebft t\u00ednh to\u00e1n:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u01a1n h\u00e0ng <\/span><b>DH001<\/b><span style=\"font-weight: 400;\"> c\u00f3 gi\u00e1 tr\u1ecb 1,500,000 VN\u0110, th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u01a1n h\u00e0ng <\/span><b>DH003<\/b><span style=\"font-weight: 400;\"> c\u00f3 gi\u00e1 tr\u1ecb 1,200,000 VN\u0110, th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u01a1n h\u00e0ng <\/span><b>DH005<\/b><span style=\"font-weight: 400;\"> c\u00f3 gi\u00e1 tr\u1ecb 1,800,000 VN\u0110, th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u1eady t\u1ed5ng ti\u1ec1n c\u1ee7a c\u00e1c \u0111\u01a1n h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb d\u01b0\u1edbi 2 tri\u1ec7u l\u00e0:\u00a0 <\/span><b>1,500,000 + 1,200,000 + 1,800,000 = 5,500,000 VN\u0110<\/b><\/p>\n<h2><b>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m SUMIF trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng SUMIF, b\u1ea1n c\u1ea7n ghi nh\u1edb m\u1ed9t s\u1ed1 \u0111i\u1ec3m quan tr\u1ecdng \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n ch\u00ednh x\u00e1c v\u00e0 tr\u00e1nh l\u1ed7i c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed9 d\u00e0i c\u1ee7a ph\u1ea1m vi (range) v\u00e0 ph\u1ea1m vi t\u00ednh t\u1ed5ng (sum_range) ph\u1ea3i b\u1eb1ng nhau. N\u1ebfu b\u1ea1n ch\u1ec9 d\u00f9ng range v\u00e0 sum_range kh\u00e1c k\u00edch th\u01b0\u1edbc (s\u1ed1 \u00f4), Excel v\u1eabn th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh, nh\u01b0ng k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 sai.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">SUMIF kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng. V\u00ed d\u1ee5: &#8220;A&#8221;, &#8220;a&#8221;, &#8220;A&#8221; \u2192 \u0111\u1ec1u \u0111\u01b0\u1ee3c coi l\u00e0 gi\u1ed1ng nhau trong \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 d\u00f9ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n trong \u0111i\u1ec1u ki\u1ec7n. * \u0111\u1ea1i di\u1ec7n cho <\/span><b>chu\u1ed7i k\u00fd t\u1ef1 b\u1ea5t k\u1ef3, <\/b><span style=\"font-weight: 400;\">? \u0111\u1ea1i di\u1ec7n cho <\/span><b>m\u1ed9t k\u00fd t\u1ef1 b\u1ea5t k\u1ef3.<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n, ph\u00e9p so s\u00e1nh, ho\u1eb7c \u00f4 tham chi\u1ebfu B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng: S\u1ed1: &#8220;5000&#8221;, &#8220;&gt;=10000&#8221;, V\u0103n b\u1ea3n: &#8220;A&#8221;, &#8220;K\u1ebf to\u00e1n&#8221;, \u00d4 tham chi\u1ebfu: =SUMIF(A2:A10, C1, B2:B10) (trong \u0111\u00f3 C1 ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tr\u00e1nh d\u00f9ng d\u1eef li\u1ec7u tr\u1ed1ng ho\u1eb7c ch\u1ee9a l\u1ed7i: N\u1ebfu v\u00f9ng range ho\u1eb7c sum_range ch\u1ee9a \u00f4 l\u1ed7i (nh\u01b0 #N\/A, #DIV\/0!&#8230;), c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 l\u1ed7i ho\u1eb7c kh\u00f4ng ch\u00ednh x\u00e1c. B\u1ea1n n\u00ean ki\u1ec3m tra v\u00e0 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng h\u00e0m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">SUMIF ch\u1ec9 cho m\u1ed9t \u0111i\u1ec1u ki\u1ec7n: N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng theo <\/span><b>nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\">, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SUMIFS.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-sumif-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-457395 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-13.jpg\" alt=\"ham-sumif-trong-excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><b>Ph\u00e2n bi\u1ec7t SUM, SUMIF v\u00e0 h\u00e0m SUMIFS trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Trong Excel, c\u1ea3 ba h\u00e0m <\/span><b>SUM, SUM<\/b><strong>IF v\u00e0 h\u00e0m SUMIFS<\/strong><span style=\"font-weight: 400;\"><strong> trong Excel<\/strong> \u0111\u1ec1u \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng, nh\u01b0ng m\u1ed7i h\u00e0m ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng nhu c\u1ea7u c\u1ee5 th\u1ec3 kh\u00e1c nhau. Vi\u1ec7c hi\u1ec3u r\u00f5 s\u1ef1 kh\u00e1c bi\u1ec7t s\u1ebd gi\u00fap b\u1ea1n l\u1ef1a ch\u1ecdn \u0111\u00fang h\u00e0m v\u00e0 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 h\u01a1n trong c\u00f4ng vi\u1ec7c.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Ti\u00eau ch\u00ed<\/b><\/td>\n<td><b>SUM<\/b><\/td>\n<td><b>SUMIF<\/b><\/td>\n<td><b>SUMIFS<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>M\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng<\/b><\/td>\n<td><span style=\"font-weight: 400;\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi<\/span><\/td>\n<td><span style=\"font-weight: 400;\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean <\/span><b>m\u1ed9t \u0111i\u1ec1u ki\u1ec7n<\/b><\/td>\n<td><span style=\"font-weight: 400;\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean <\/span><b>nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>S\u1ed1 l\u01b0\u1ee3ng \u0111i\u1ec1u ki\u1ec7n h\u1ed7 tr\u1ee3<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1 \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t<\/span><\/td>\n<td><span style=\"font-weight: 400;\">H\u1ed7 tr\u1ee3 t\u1eeb 2 \u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>C\u00fa ph\u00e1p<\/b><\/td>\n<td><span style=\"font-weight: 400;\">=SUM(number1, [number2], &#8230;)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SUMIF(range, criteria, [sum_range])<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], &#8230;)<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>V\u1ecb tr\u00ed ph\u1ea1m vi t\u00ednh t\u1ed5ng<\/b><\/td>\n<td><span style=\"font-weight: 400;\">L\u00e0 \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean<\/span><\/td>\n<td><span style=\"font-weight: 400;\">M\u1eb7c \u0111\u1ecbnh l\u00e0 range n\u1ebfu kh\u00f4ng c\u00f3 sum_range ri\u00eang, ho\u1eb7c l\u00e0 sum_range<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Lu\u00f4n l\u00e0 \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean sum_range<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Kh\u1ea3 n\u0103ng l\u1ecdc d\u1eef li\u1ec7u<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Kh\u00f4ng l\u1ecdc, c\u1ed9ng t\u1ea5t c\u1ea3<\/span><\/td>\n<td><span style=\"font-weight: 400;\">L\u1ecdc theo 1 ti\u00eau ch\u00ed (v\u00ed d\u1ee5 theo t\u00ean, m\u00e3 h\u00e0ng, \u0111\u01a1n gi\u00e1&#8230;)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">L\u1ecdc theo nhi\u1ec1u ti\u00eau ch\u00ed \u0111\u1ed3ng th\u1eddi (v\u00ed d\u1ee5: theo t\u00ean <\/span><b>v\u00e0<\/b><span style=\"font-weight: 400;\"> theo s\u1ed1 l\u01b0\u1ee3ng)<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Kh\u1ea3 n\u0103ng linh ho\u1ea1t<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Th\u1ea5p \u2013 ch\u1ec9 c\u1ed9ng gi\u00e1 tr\u1ecb<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Trung b\u00ecnh \u2013 l\u1ecdc \u0111\u01b0\u1ee3c 1 \u0111i\u1ec1u ki\u1ec7n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Cao \u2013 k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>V\u00ed d\u1ee5 minh h\u1ecda<\/b><\/td>\n<td><span style=\"font-weight: 400;\">=SUM(B2:B6)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SUMIF(A2:A6, &#8220;K\u1ebf to\u00e1n&#8221;, B2:B6)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SUMIFS(C2:C6, A2:A6, &#8220;K\u1ebf to\u00e1n&#8221;, B2:B6, &#8220;&gt;10000000&#8221;)<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>\u1ee8ng d\u1ee5ng ph\u1ed5 bi\u1ebfn<\/b><\/td>\n<td><span style=\"font-weight: 400;\">T\u1ed5ng doanh thu, t\u1ed5ng l\u01b0\u01a1ng, t\u1ed5ng \u0111i\u1ec3m,&#8230;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">T\u1ed5ng ti\u1ec1n c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m theo m\u00e3 h\u00e0ng, t\u1ed5ng l\u01b0\u01a1ng theo ph\u00f2ng ban,&#8230;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">T\u1ed5ng doanh s\u1ed1 theo th\u00e1ng, khu v\u1ef1c, s\u1ea3n ph\u1ea9m,&#8230; v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n k\u1ebft h\u1ee3p<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><b>T\u1ea1m k\u1ebft<\/b><\/h2>\n<p><b>H\u00e0m SUMIF trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 c\u00f4ng c\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u01b0ng c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n. D\u00f9 b\u1ea1n l\u00e0 ng\u01b0\u1eddi m\u1edbi h\u1ecdc hay \u0111\u00e3 quen v\u1edbi Excel, vi\u1ec7c hi\u1ec3u r\u00f5 c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng v\u00e0 nh\u1eefng v\u00ed d\u1ee5 minh h\u1ecda th\u1ef1c t\u1ebf s\u1ebd gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian. \u0110\u1eebng qu\u00ean \u00e1p d\u1ee5ng th\u00eam h\u00e0m SUMIFS khi c\u1ea7n t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n nh\u00e9!<\/span><\/p>\n<p><strong>XEM TH\u00caM:<\/strong><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/\">5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\">T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m SUMIF trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u1ef1c k\u1ef3 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong b\u1ea3ng t\u00ednh. Thay v\u00ec ph\u1ea3i l\u1ecdc d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng r\u1ed3i c\u1ed9ng t\u1eebng gi\u00e1 tr\u1ecb b\u1eb1ng tay, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng t\u00ednh t\u1ed5ng theo m\u1ed9t ti\u00eau ch\u00ed x\u00e1c [&hellip;]<\/p>\n","protected":false},"author":113,"featured_media":457396,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-456900","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda<\/title>\n<meta name=\"description\" content=\"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft \u0111\u1ec3 b\u1ea1n v\u1eadn d\u1ee5ng trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft \u0111\u1ec3 b\u1ea1n v\u1eadn d\u1ee5ng trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-24T13:42:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n L\u00e2m Oanh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n L\u00e2m Oanh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/\"},\"author\":{\"name\":\"Nguy\u1ec5n L\u00e2m Oanh\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/3b8d70adf1c05344bab3a1559c4c1d95\"},\"headline\":\"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft\",\"datePublished\":\"2025-05-24T13:42:40+00:00\",\"dateModified\":\"2025-05-24T13:42:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/\"},\"wordCount\":3197,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/\",\"name\":\"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg\",\"datePublished\":\"2025-05-24T13:42:40+00:00\",\"dateModified\":\"2025-05-24T13:42:40+00:00\",\"description\":\"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft \u0111\u1ec3 b\u1ea1n v\u1eadn d\u1ee5ng trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-sumif-trong-excel-thumbnail\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/3b8d70adf1c05344bab3a1559c4c1d95\",\"name\":\"Nguy\u1ec5n L\u00e2m Oanh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0ee38b6e9ddaf0852e25dac11c97725b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0ee38b6e9ddaf0852e25dac11c97725b?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n L\u00e2m Oanh\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-lam-oanh\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda","description":"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft \u0111\u1ec3 b\u1ea1n v\u1eadn d\u1ee5ng trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft","og_description":"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft \u0111\u1ec3 b\u1ea1n v\u1eadn d\u1ee5ng trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-05-24T13:42:40+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n L\u00e2m Oanh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n L\u00e2m Oanh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/"},"author":{"name":"Nguy\u1ec5n L\u00e2m Oanh","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/3b8d70adf1c05344bab3a1559c4c1d95"},"headline":"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft","datePublished":"2025-05-24T13:42:40+00:00","dateModified":"2025-05-24T13:42:40+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/"},"wordCount":3197,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/","name":"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg","datePublished":"2025-05-24T13:42:40+00:00","dateModified":"2025-05-24T13:42:40+00:00","description":"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft \u0111\u1ec3 b\u1ea1n v\u1eadn d\u1ee5ng trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-sumif-trong-excel-thumbnail.jpg","width":1200,"height":628,"caption":"ham-sumif-trong-excel-thumbnail"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/3b8d70adf1c05344bab3a1559c4c1d95","name":"Nguy\u1ec5n L\u00e2m Oanh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0ee38b6e9ddaf0852e25dac11c97725b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0ee38b6e9ddaf0852e25dac11c97725b?s=96&d=mm&r=g","caption":"Nguy\u1ec5n L\u00e2m Oanh"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-lam-oanh\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/456900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/113"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=456900"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/456900\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/457396"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=456900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=456900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=456900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}