{"id":264298,"date":"2023-09-25T23:42:34","date_gmt":"2023-09-25T16:42:34","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=264298"},"modified":"2023-09-25T23:42:34","modified_gmt":"2023-09-25T16:42:34","slug":"ham-sumifs","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t"},"content":{"rendered":"<p><strong>H\u00e0m SUMIFS<\/strong> trong Excel l\u00e0 m\u1ed9t h\u00e0m c\u01a1 b\u1ea3n, gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb, d\u1eef li\u1ec7u tho\u1ea3 m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00ednh k\u00e8m kh\u00e1c nhau m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c. Tuy nhi\u00ean, \u0111\u1ec3 t\u1eadn d\u1ee5ng h\u1ebft kh\u1ea3 n\u0103ng c\u1ee7a <strong>h\u00e0m SUMIFS<\/strong>, b\u1ea1n c\u1ea7n ph\u1ea3i n\u1eafm v\u1eefng quy lu\u1eadt s\u1eed d\u1ee5ng h\u00e0m. Th\u00f4ng qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n t\u1eebng b\u01b0\u1edbc m\u1ed9t v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y ch\u00ednh x\u00e1c nh\u1ea5t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n<h2>Excel l\u00e0 g\u00ec?<\/h2>\n<p>Microsoft Excel l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng thu\u1ed9c b\u1ed9 c\u00f4ng c\u1ee5 Microsoft Office, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ea1o, s\u1eeda \u0111\u1ed5i v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u trong m\u1ed9t b\u1ea3ng theo h\u00e0ng v\u00e0 c\u1ed9t. Excel cung c\u1ea5p nhi\u1ec1u c\u00f4ng c\u1ee5 v\u00e0 ch\u1ee9c n\u0103ng t\u00ednh to\u00e1n, th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n s\u1ed1 h\u1ecdc, th\u1ed1ng k\u00ea, v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-264310 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs.jpg\" alt=\"ham-sumifs\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>Microsoft Excel c\u00f3 t\u1ea7m quan tr\u1ecdng l\u1edbn trong nhi\u1ec1u l\u0129nh v\u1ef1c doanh nghi\u1ec7p v\u00e0 c\u00e1 nh\u00e2n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng quan tr\u1ecdng c\u1ee7a Excel:<\/p>\n<ul>\n<li><strong>Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3<\/strong>: Gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1ed5 ch\u1ee9c, l\u01b0u tr\u1eef v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. Vi\u1ec7c s\u1eafp x\u1ebfp, l\u1ecdc, v\u00e0 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong c\u00e1c b\u1ea3ng t\u00ednh thu\u1eadn ti\u1ec7n.<\/li>\n<li><strong>T\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u<\/strong>: Cung c\u1ea5p nhi\u1ec1u c\u00f4ng c\u1ee5 t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n s\u1ed1 h\u1ecdc, th\u1ed1ng k\u00ea v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p.<\/li>\n<li><strong>T\u1ea1o bi\u1ec3u \u0111\u1ed3 v\u00e0 \u0111\u1ed3 th\u1ecb<\/strong>: Tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u, nh\u00ecn ra c\u00e1c xu h\u01b0\u1edbng v\u00e0 m\u1ed1i quan h\u1ec7 trong d\u1eef li\u1ec7u.<\/li>\n<li><strong>B\u00e1o c\u00e1o v\u00e0 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u<\/strong>: tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng v\u00e0 chuy\u00ean nghi\u1ec7p.<\/li>\n<li><strong>Thao t\u00e1c v\u1edbi d\u1eef li\u1ec7u l\u1edbn<\/strong>: Excel h\u1ed7 tr\u1ee3 x\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng l\u00e0m vi\u1ec7c v\u1edbi t\u1eadp tin v\u00e0 b\u1ea3ng t\u00ednh c\u00f3 h\u00e0ng ng\u00e0n, th\u1eadm ch\u00ed h\u00e0ng tri\u1ec7u d\u00f2ng d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p>V\u1edbi nh\u1eefng t\u00ednh n\u0103ng tr\u00ean, Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong nhi\u1ec1u l\u0129nh v\u1ef1c: kinh t\u1ebf, t\u00e0i ch\u00ednh, k\u1ebf to\u00e1n, th\u1ed1ng k\u00ea, qu\u1ea3n l\u00fd d\u1ef1 \u00e1n\u2026gi\u00fap c\u00e1 nh\u00e2n v\u00e0 doanh nghi\u1ec7p t\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh c\u00f4ng vi\u1ec7c. Trong ph\u1ea7n ti\u1ebfp theo, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m t\u00ednh t\u1ed5ng trong Excel, c\u1ee5 th\u1ec3 l\u00e0 <strong>h\u00e0m<\/strong> <strong>SUMIFS<\/strong>.<\/p>\n<h2>Ph\u00e2n bi\u1ec7t c\u00e1c h\u00e0m t\u00ednh t\u1ed5ng trong Excel<\/h2>\n<p>Trong Excel, c\u00f3 nhi\u1ec1u h\u00e0m t\u00ednh t\u1ed5ng kh\u00e1c nhau \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c lo\u1ea1i t\u00ednh to\u00e1n t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u kh\u00e1c nhau m\u00e0 b\u1ea1n \u0111ang th\u1ef1c hi\u1ec7n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 h\u00e0m t\u00ednh t\u1ed5ng ph\u1ed5 bi\u1ebfn:<\/p>\n<p><strong>SUM<\/strong>: H\u00e0m SUM \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m trong m\u1ed9t ph\u1ea1m vi c\u1ee5 th\u1ec3. AVERAGE: H\u00e0m AVERAGE d\u00f9ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng c\u1ee7a m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-cac-tham-so.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-cac-tham-so-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-cac-tham-so-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-264299 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-cac-tham-so.jpeg\" alt=\"ham-sumifs-cac-tham-so\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-cac-tham-so.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-cac-tham-so-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-cac-tham-so-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>COUNT v\u00e0 COUNTA<\/strong>: H\u00e0m COUNT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb s\u1ed1 trong m\u1ed9t ph\u1ea1m vi. Trong khi \u0111\u00f3, h\u00e0m COUNTA \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb kh\u00f4ng r\u1ed7ng.<\/p>\n<p><strong>SUMIF v\u00e0 SUMIFS:<\/strong> H\u00e0m SUMIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ed5ng h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t. Theo \u0111\u00f3, h\u00e0m n\u00e0y cho ph\u00e9p t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p><strong>SUBTOTAL<\/strong>: H\u00e0m SUBTOTAL t\u00ednh t\u1ed5ng ho\u1eb7c c\u00e1c th\u1ed1ng k\u00ea kh\u00e1c cho m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u, v\u1edbi kh\u1ea3 n\u0103ng t\u1eaft b\u1eadt c\u00e1c t\u1ed5ng ph\u1ee5 v\u00e0 t\u1ed5ng k\u1ebft.<\/p>\n<h2>H\u00e0m SUMIFS l\u00e0 g\u00ec?<\/h2>\n<p>V\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m n\u00e0y cho ph\u00e9p b\u1ea1n t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u d\u1ef1a tr\u00ean m\u1ed9t ho\u1eb7c nhi\u1ec1u ti\u00eau ch\u00ed \u0111i\u1ec1u ki\u1ec7n m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c. \u0110i\u1ec1u n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau.<\/p>\n<p>C\u00f4ng th\u1ee9c h\u00e0m:<\/p>\n<p style=\"text-align: center;\"><strong>SUMIFS(T\u1ed5ng c\u1ed9t; ph\u1ea1m vi \u0111i\u1ec1u ki\u1ec7n 1; \u0111i\u1ec1u ki\u1ec7n 1; \u2026)<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>Sum_range<\/strong>: \u0111\u00e2y l\u00e0 v\u00f9ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh t\u1ed5ng ch\u01b0a c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1. Tr\u01b0\u1eddng h\u1ee3p v\u00f9ng t\u00ednh gi\u00e1 tr\u1ecb ch\u01b0a c\u00e1c gi\u00e1 tr\u1ecb tr\u1ed1ng, hay l\u00e0 v\u0103n b\u1ea3n s\u1ebd \u0111\u01b0\u1ee3c b\u1ecf qua.<\/li>\n<li><strong>Criteria_range1, criteria1<\/strong>\u2026 : V\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u ph\u1ea1m vi v\u00e0 \u0111i\u1ec1u ki\u1ec7n s\u1ed1 1<\/li>\n<\/ul>\n<p>T\u01b0\u01a1ng t\u1ef1 cho c\u00e1c criteria_range2, criteria2, criteria_range3, criteria3\u2026<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-la-gi.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-la-gi-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-la-gi-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-264309 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-la-gi.jpg\" alt=\"ham-sumifs-la-gi\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-la-gi.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-la-gi-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-la-gi-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>C\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m SUMIF<\/strong><\/p>\n<p>H\u00e0m SUMIFS c\u00f3 c\u00e1c tham s\u1ed1 quan tr\u1ecdng sau:<\/p>\n<ul>\n<li>Sum_range (T\u1ed5ng_c\u1ed9t): \u0110\u00e2y l\u00e0 ph\u1ea1m vi c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u1ed5ng h\u1ee3p.<\/li>\n<li>Criteria_range1 (Ph\u1ea1m_vi_\u0111i\u1ec1u_ki\u1ec7n1), Criteria_range2 (Ph\u1ea1m_vi_\u0111i\u1ec1u_ki\u1ec7n2), &#8230;: \u0110\u00e2y l\u00e0 c\u00e1c ph\u1ea1m vi ch\u1ee9a c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng.<\/li>\n<li>Criteria1 (Ti\u00eau_ch\u00ed1), Criteria2 (Ti\u00eau_ch\u00ed2, )&#8230;: \u0110\u00e2y l\u00e0 c\u00e1c \u0111i\u1ec1u ki\u1ec7n m\u00e0 d\u1eef li\u1ec7u c\u1ea7n ph\u1ea3i th\u1ecfa m\u00e3n.<\/li>\n<\/ul>\n<h2>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3<\/h2>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c nh\u1ea5t, h\u00e3y c\u00e2n nh\u1eafc c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp m\u1ed9t c\u00e1ch ch\u1eb7t ch\u1ebd. \u0110i\u1ec1u n\u00e0y gi\u00fap h\u00e0m SUMIFS ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c.<\/p>\n<p><strong>X\u00e1c \u0111\u1ecbnh ti\u00eau ch\u00ed<\/strong>: X\u00e1c \u0111\u1ecbnh c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng. H\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng c\u00e1c ti\u00eau ch\u00ed n\u00e0y ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u trong ph\u1ea1m vi b\u1ea1n \u0111ang xem x\u00e9t.<\/p>\n<p><strong>S\u1eed d\u1ee5ng h\u00e0m SUMIFS<\/strong>: \u00c1p d\u1ee5ng h\u00e0m SUMIFS v\u1edbi c\u00e1c tham s\u1ed1 t\u01b0\u01a1ng \u1ee9ng. Theo d\u00f5i c\u00e1c ph\u1ea1m vi v\u00e0 ti\u00eau ch\u00ed \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-cach-su-dung-hieu-qua.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-cach-su-dung-hieu-qua-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-cach-su-dung-hieu-qua-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-264300 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-cach-su-dung-hieu-qua.jpg\" alt=\"ham-sumifs-cach-su-dung-hieu-qua\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-cach-su-dung-hieu-qua.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-cach-su-dung-hieu-qua-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-cach-su-dung-hieu-qua-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>Nh\u1eefng l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m SUMIFS:<\/strong><\/p>\n<ul>\n<li>H\u00e3y s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (wildcards) khi c\u1ea7n thi\u1ebft \u0111\u1ec3 m\u1edf r\u1ed9ng ti\u00eau ch\u00ed t\u00ecm ki\u1ebfm. \u0110i\u1ec1u ki\u1ec7n criteria c\u00f3 th\u1ec3 ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 sau: (?), (*) \u2026. N\u1ebfu trong \u0111i\u1ec1u ki\u1ec7n criteria mu\u1ed1n \u0111\u1eb7t l\u00e0 (?) ho\u1eb7c (*) th\u00ec c\u1ea7n th\u00eam d\u1ea5u ~ tr\u01b0\u1edbc \u0111\u00f3.<\/li>\n<li>Lu\u00f4n ki\u1ec3m tra k\u1ef9 thu\u1eadt s\u1eafp x\u1ebfp d\u1eef li\u1ec7u \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c.<\/li>\n<li>D\u00f9ng c\u00f4ng c\u1ee5 \u0111i\u1ec1u ki\u1ec7n theo nh\u00f3m \u0111\u1ec3 t\u1ed5 ch\u1ee9c v\u00e0 ki\u1ec3m so\u00e1t \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng.<\/li>\n<li>C\u00e1c ti\u00eau ch\u00ed \u0111i\u1ec1u ki\u1ec7n th\u1ec3 hi\u1ec7n \u1edf d\u1ea1ng v\u0103n b\u1ea3n, th\u00ec c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u \u201cngo\u1eb7c k\u00e9p\u201d v\u00e0 \u0111\u1ed1i v\u1edbi m\u1ed7i h\u00e0m nh\u01b0 v\u1eady, ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u1eb7t kh\u00f4ng qu\u00e1 127 \u0111i\u1ec1u ki\u1ec7n.<\/li>\n<li>Criteria_range v\u00e0 sum_range ph\u1ea3i c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc, t\u1ee9c s\u1ed1 h\u00e0ng,\u00a0 s\u1ed1 c\u1ed9t gi\u1ed1ng nhau.<\/li>\n<li>Trong tr\u01b0\u1eddng h\u1ee3p sum_range tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE, t\u1ee9c k\u1ebft qu\u1ea3 l\u00e0 1 v\u00e0 khi tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 FALSE, th\u00ec k\u1ebft qu\u1ea3 0.<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-luu-y.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-luu-y-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-luu-y-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-264303 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-luu-y.jpeg\" alt=\"\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-luu-y.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-luu-y-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-luu-y-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2>M\u1ed9t v\u00e0i v\u00ed d\u1ee5 khi s\u1eed d\u1ee5ng h\u00e0m SUMIFS<\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 h\u00e0m SUMIFS trong Excel c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y.<\/p>\n<p><strong>S\u1eed d\u1ee5ng SUMIFS v\u1edbi to\u00e1n so s\u00e1nh<\/strong><\/p>\n<p>V\u1edbi b\u1ea3ng v\u00ed d\u1ee5 sau, y\u00eau c\u1ea7u \u0111\u1eb7t ra l\u00e0 t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng m\u00e0 Mike \u0111\u00e3 cung c\u1ea5p t\u1eeb 200 s\u1ea3n ph\u1ea9m tr\u1edf l\u00ean. Khi n\u00e0y \u0111i\u1ec1u ki\u1ec7n th\u1ee9 nh\u1ea5t l\u00e0 \u201cnh\u00e0 cung c\u1ea5p Mike\u201d. \u0110i\u1ec1u ki\u1ec7n th\u1ee9 hai l\u00e0 \u201cl\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 200\u201d . = SUMIFS (C2: C9, B2: B9, \u201cMike\u201d, C2: C9, \u201c&gt; = 200\u201d).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-toan-tu-so-sanh.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-toan-tu-so-sanh-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-toan-tu-so-sanh-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-264306 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-toan-tu-so-sanh.jpg\" alt=\"ham-sumifs-toan-tu-so-sanh\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-toan-tu-so-sanh.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-toan-tu-so-sanh-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-toan-tu-so-sanh-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>S\u1eed d\u1ee5ng SUMIFS v\u1edbi ng\u00e0y th\u00e1ng<\/strong><\/p>\n<p>V\u1edbi v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi, \u0111\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng gi\u00e1 tr\u1ecb v\u1edbi v\u1edbi ng\u00e0y hi\u1ec7n t\u1ea1i, h\u00e0m SUMIFS s\u1ebd s\u1eed d\u1ee5ng h\u00e0m TODAY () l\u00e0m \u0111i\u1ec1u ki\u1ec7n c\u1ee7a m\u00ecnh.<\/p>\n<p>Y\u00eau c\u1ea7u c\u1ee5 th\u1ec3: T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb S\u1ed1 l\u01b0\u1ee3ng trong 7 ng\u00e0y qua, t\u00ednh c\u1ea3 ng\u00e0y h\u00f4m nay.<\/p>\n<p>Khi \u0111\u00f3 ta s\u1ebd c\u00f3 h\u00e0m c\u00f4ng th\u1ee9c nh\u01b0 sau: \u0111i\u1ec1u ki\u1ec7n th\u1ee9 nh\u1ea5t l\u00e0 \u201ch\u00f4m nay tr\u1eeb 07 ng\u00e0y v\u1ec1 tr\u01b0\u1edbc\u201d, \u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai \u201cb\u00e9 h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y h\u00f4m nay\u201d. \u201c<em>= SUMIFS (D2: D10, C2: C10, \u201c&gt; =\u201d &amp; TODAY () \u2013 7, C2: C10, \u201c&lt;=\u201d &amp; TODAY ())\u201d:<\/em><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-ngay-thang.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-ngay-thang-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-ngay-thang-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-264304 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-ngay-thang.jpg\" alt=\"ham-sumifs-ngay-thang\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-ngay-thang.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-ngay-thang-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-ngay-thang-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2>C\u00e1c l\u1ed7i sai th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m SUMIFS v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/h2>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m SUMIFS trong Excel, c\u00f3 m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn m\u00e0 ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng g\u1eb7p. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, c\u0169ng nh\u01b0 c\u00e1ch kh\u1eafc ph\u1ee5c nh\u1eefng l\u1ed7i n\u00e0y:<\/p>\n<p><strong>S\u1ed1 l\u01b0\u1ee3ng tham s\u1ed1 kh\u00f4ng \u0111\u00fang<\/strong>: \u0110\u00f4i khi ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u1eadp sai s\u1ed1 l\u01b0\u1ee3ng tham s\u1ed1 ho\u1eb7c \u0111\u1eb7t sai th\u1ee9 t\u1ef1 c\u00e1c tham s\u1ed1. \u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y, c\u1ea7n ki\u1ec3m tra k\u1ef9 l\u01b0\u1ee1ng c\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIFS. X\u00e1c \u0111\u1ecbnh xem b\u1ea1n \u0111\u00e3 nh\u1eadp \u0111\u00fang s\u1ed1 tham s\u1ed1 v\u00e0 \u0111\u00fang th\u1ee9 t\u1ef1 ch\u00fang hay ch\u01b0a.<\/p>\n<p><strong>Ph\u1ea1m vi \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi ph\u1ea1m vi t\u1ed5ng h\u1ee3p<\/strong>: C\u00f3 th\u1ec3 x\u1ea3y ra khi ph\u1ea1m vi \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc ho\u1eb7c kh\u00f4ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi ph\u1ea1m vi t\u1ed5ng h\u1ee3p. \u0110\u1ec3 kh\u1eafc ph\u1ee5c b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng ph\u1ea1m vi \u0111i\u1ec1u ki\u1ec7n v\u00e0 ph\u1ea1m vi t\u1ed5ng h\u1ee3p c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc ho\u1eb7c ch\u1ee9a c\u00f9ng s\u1ed1 l\u01b0\u1ee3ng d\u00f2ng\/c\u1ed9t.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-loi-sai-thuong-gap.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-loi-sai-thuong-gap-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-sumifs-loi-sai-thuong-gap-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-264302 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-loi-sai-thuong-gap.jpeg\" alt=\"ham-sumifs-loi-sai-thuong-gap\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-loi-sai-thuong-gap.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-loi-sai-thuong-gap-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-loi-sai-thuong-gap-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>Thi\u1ebfu d\u1ea5u ngo\u1eb7c \u0111\u00f3ng<\/strong>: L\u1ed7i: Qu\u00ean \u0111i\u1ec1n d\u1ea5u \u0111\u00f3ng &#8220;)&#8221; sau khi ho\u00e0n th\u00e0nh c\u00fa ph\u00e1p c\u1ee7a h\u00e0m. C\u1ea7n l\u01b0u \u00fd ki\u1ec3m tra l\u1ea1i c\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIFS v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111\u00e3 nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 c\u00e1c d\u1ea5u ngo\u1eb7c \u0111\u00f3ng.<\/p>\n<p><strong>Sai c\u00fa ph\u00e1p cho ti\u00eau ch\u00ed<\/strong>: C\u00f3 th\u1ec3 nh\u1eadp sai c\u00fa ph\u00e1p cho ti\u00eau ch\u00ed. V\u00ed d\u1ee5: qu\u00ean \u0111\u1eb7t d\u1ea5u ngo\u1eb7c k\u00e9p (&#8221; &#8220;) xung quanh v\u0103n b\u1ea3n. \u0110\u1ec3 kh\u1eafc ph\u1ee5c c\u1ea7n x\u00e1c \u0111\u1ecbnh l\u1ea1i ti\u00eau ch\u00ed v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00fa ph\u00e1p c\u1ee7a n\u00f3 \u0111\u00fang.<\/p>\n<p><strong>Thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p cho ti\u00eau ch\u00ed v\u0103n b\u1ea3n:<\/strong> Khi s\u1eed d\u1ee5ng ti\u00eau ch\u00ed v\u0103n b\u1ea3n, ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng qu\u00ean \u0111\u1eb7t d\u1ea5u ngo\u1eb7c k\u00e9p (&#8221; &#8220;) xung quanh ti\u00eau ch\u00ed. B\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng ti\u00eau ch\u00ed v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c bao b\u1ecdc b\u1edfi d\u1ea5u ngo\u1eb7c k\u00e9p \u0111\u1ec3 tr\u00e1nh m\u1eafc ph\u1ea3i l\u1ed7i n\u00e0y.<\/p>\n<h2>Ph\u00e2n bi\u1ec7t chi ti\u1ebft h\u00e0m SUM, SUMIF v\u00e0 SUMIFS<\/h2>\n<p>H\u00e0m SUM, SUMIF v\u00e0 SUMIFS trong Excel \u0111\u1ec1u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb. Tuy nhi\u00ean, m\u1ed7i h\u00e0m n\u00e0y c\u00f3 m\u1ee5c ti\u00eau v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng kh\u00e1c nhau.<\/p>\n<p><strong>H\u00e0m SUM<\/strong><\/p>\n<p>C\u00fa ph\u00e1p: <strong>=SUM(number1, number2, &#8230;)<\/strong><\/p>\n<p>M\u1ee5c ti\u00eau: T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c cung c\u1ea5p.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<ul>\n<li>=SUM(C1:C5) s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb \u00f4 C1 \u0111\u1ebfn C5.<\/li>\n<li>=SUM(5, 10, 15) s\u1ebd tr\u1ea3 v\u1ec1 t\u1ed5ng c\u1ee7a 5, 10 v\u00e0 15, t\u1ee9c l\u00e0 30.<\/li>\n<\/ul>\n<p><strong>H\u00e0m SUMIF<\/strong><\/p>\n<p>C\u00fa ph\u00e1p: <strong>=SUMIF(range, criteria, [sum_range])<\/strong><\/p>\n<p>M\u1ee5c ti\u00eau: T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong sum_range (ph\u1ea1m vi c\u1ea7n t\u00ednh to\u00e1n) n\u1ebfu c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong range (ph\u1ea1m vi \u0111i\u1ec1u ki\u1ec7n) th\u1ecfa m\u00e3n.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<ul>\n<li>=SUMIF(A1:A5, &#8220;&gt;10&#8221;) s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi A1:A5 m\u00e0 l\u1edbn h\u01a1n 10.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-264305 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-phan-biet-sum-sumif-sumifs.jpg\" alt=\"ham-sumifs-phan-biet-sum-sumif-sumifs\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-phan-biet-sum-sumif-sumifs.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-phan-biet-sum-sumif-sumifs-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-phan-biet-sum-sumif-sumifs-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><strong>H\u00e0m SUMIFS<\/strong><\/p>\n<p>C\u00fa ph\u00e1p: <strong>=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], &#8230;)<\/strong><\/p>\n<p>M\u1ee5c ti\u00eau: T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong sum_range (ph\u1ea1m vi c\u1ea7n t\u00ednh to\u00e1n) d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi criteria_range v\u00e0 criteria.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>=SUMIFS(B1:B5, A1:A5, &#8220;&gt;10&#8221;, C1:C5, &#8220;Fruits&#8221;) s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi B1:B5 ch\u1ec9 khi gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong A1:A5 l\u1edbn h\u01a1n 10 v\u00e0 t\u01b0\u01a1ng \u1ee9ng trong C1:C5 l\u00e0 &#8220;Fruits&#8221;.<\/p>\n<p>Nh\u00ecn chung c\u1ea3 3 h\u00e0m SUM, SUMIF v\u00e0 SUMIFS \u0111\u1ec1u l\u00e0 h\u00e0m t\u00ednh gi\u00e1 tr\u1ecb t\u1ed5ng trong Excel. Tuy nhi\u00ean, \u0111i\u1ec3m d\u1ec5 nh\u1eadn bi\u1ebft v\u00e0 ph\u00e2n bi\u1ec7t ba h\u00e0m n\u00e0y chi ti\u1ebft nh\u01b0 sau:<\/p>\n<ul>\n<li>SUM t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111i k\u00e8m theo.<\/li>\n<li>SUMIF t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/li>\n<li>SUMIFS t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau.<\/li>\n<li>Khi c\u1ea7n t\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n, h\u00e3y x\u00e1c \u0111\u1ecbnh li\u1ec7u ch\u1ec9 c\u1ea7n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n (SUMIF) hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n (SUMIFS).<\/li>\n<\/ul>\n<h2>T\u1ea1m k\u1ebft<\/h2>\n<p>T\u00f3m l\u1ea1i, <strong>h\u00e0m SUMIFS<\/strong> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 \u0111\u1ea3m b\u1ea3o tuy\u1ec7t \u0111\u1ed1i ch\u00ednh x\u00e1c cho k\u1ebft qu\u1ea3 c\u1ee7a m\u00ecnh.<\/p>\n<p>Ngo\u00e0i ra, \u0111\u1eebng qu\u00ean ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb tham chi\u1ebfu v\u00e0 l\u01b0u l\u1ea1i nh\u1eefng l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m SUMIFS m\u00e0 Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 chia s\u1ebb \u1edf tr\u00ean, \u0111\u1ec3 tr\u00e1nh m\u1eafc nh\u1eefng sai x\u00f3t tr\u1ea3, nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 \u0111\u00fang. Theo d\u00f5i ngay trang tin nhanh c\u1ee7a ch\u00fang t\u00f4i \u0111\u1ec3 kh\u00f4ng b\u1ecf l\u1ee1 nh\u1eefng chia s\u1ebb h\u1eefu \u00edch kh\u00e1c li\u00ean quan \u0111\u1ebfn Excel ho\u1eb7c b\u1ea5t k\u00ec l\u0129nh v\u1ef1c n\u00e0o m\u00e0 b\u1ea1n quan t\u00e2m nh\u00e9.<\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/\">C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/\">Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m SUMIFS trong Excel l\u00e0 m\u1ed9t h\u00e0m c\u01a1 b\u1ea3n, gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb, d\u1eef li\u1ec7u tho\u1ea3 m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00ednh k\u00e8m kh\u00e1c nhau m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c. Tuy nhi\u00ean, \u0111\u1ec3 t\u1eadn d\u1ee5ng h\u1ebft kh\u1ea3 n\u0103ng c\u1ee7a h\u00e0m SUMIFS, b\u1ea1n c\u1ea7n ph\u1ea3i n\u1eafm v\u1eefng quy lu\u1eadt s\u1eed d\u1ee5ng [&hellip;]<\/p>\n","protected":false},"author":83,"featured_media":264307,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-264298","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"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\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"H\u00e0m SUMIFS trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed, tham kh\u1ea3o ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y nh\u00e9.\" \/>\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-sumifs\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m SUMIFS trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed, tham kh\u1ea3o ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/\" \/>\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=\"2023-09-25T16:42:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.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=\"Do Tuyet Nhi\" \/>\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=\"Do Tuyet Nhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 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-sumifs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/\"},\"author\":{\"name\":\"Do Tuyet Nhi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t\",\"datePublished\":\"2023-09-25T16:42:34+00:00\",\"dateModified\":\"2023-09-25T16:42:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/\"},\"wordCount\":3075,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.jpg\",\"datePublished\":\"2023-09-25T16:42:34+00:00\",\"dateModified\":\"2023-09-25T16:42:34+00:00\",\"description\":\"H\u00e0m SUMIFS trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed, tham kh\u1ea3o ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-sumifs-thump\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t\"}]},{\"@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\/bba0f0fb7a9ee063d98abf6557ccdaee\",\"name\":\"Do Tuyet Nhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g\",\"caption\":\"Do Tuyet Nhi\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t","description":"H\u00e0m SUMIFS trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed, tham kh\u1ea3o ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y nh\u00e9.","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-sumifs\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t","og_description":"H\u00e0m SUMIFS trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed, tham kh\u1ea3o ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y nh\u00e9.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-09-25T16:42:34+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.jpg","type":"image\/jpeg"}],"author":"Do Tuyet Nhi","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Do Tuyet Nhi","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"13 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/"},"author":{"name":"Do Tuyet Nhi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee"},"headline":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t","datePublished":"2023-09-25T16:42:34+00:00","dateModified":"2023-09-25T16:42:34+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/"},"wordCount":3075,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/","name":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.jpg","datePublished":"2023-09-25T16:42:34+00:00","dateModified":"2023-09-25T16:42:34+00:00","description":"H\u00e0m SUMIFS trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed, tham kh\u1ea3o ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y nh\u00e9.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-sumifs-thump.jpg","width":1200,"height":628,"caption":"ham-sumifs-thump"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t"}]},{"@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\/bba0f0fb7a9ee063d98abf6557ccdaee","name":"Do Tuyet Nhi","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g","caption":"Do Tuyet Nhi"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/264298","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\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=264298"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/264298\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/264307"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=264298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=264298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=264298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}