{"id":5581,"date":"2024-12-16T16:41:26","date_gmt":"2024-12-16T16:41:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-tinh-tong-theo-cac-o-co-ky-tu-giong-nhau-trong-excel\/"},"modified":"2024-12-16T16:41:26","modified_gmt":"2024-12-16T16:41:26","slug":"huong-dan-cach-tinh-tong-theo-cac-o-co-ky-tu-giong-nhau-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-tinh-tong-theo-cac-o-co-ky-tu-giong-nhau-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh t\u1ed5ng theo c\u00e1c \u00f4 c\u00f3 k\u00fd t\u1ef1 gi\u1ed1ng nhau trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i t\u00ednh t\u1ed5ng theo\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 nh\u1eefng k\u00fd t\u1ef1 gi\u1ed1ng nhau\u00a0\u1edf trong 1\u00a0\u00f4 th\u00ec d\u00f9ng h\u00e0m g\u00ec?\u00a0\u0110\u00e2y l\u00e0 c\u00e2u h\u1ecfi r\u1ea5t th\u00fa v\u1ecb m\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc\u00a0Excel Online<\/strong> <\/a>th\u01b0\u1eddng nh\u1eadn\u00a0\u0111\u01b0\u1ee3c. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y nh\u00e9.<\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 y\u00eau c\u1ea7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24210\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/de-bai-tinh-tong-theo-o-chua-ki-tu.png\" width=\"848\" height=\"286\" title=\"de-bai-tinh-tong-theo-o-chua-ki-tu\"><\/p>\n<p>Trong c\u1ed9t ID nh\u00e2n vi\u00ean, ch\u00fang ta th\u1ea5y c\u00e1c m\u00e3 ID c\u00f3 ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 l\u00e0 KD1, KD2. Nh\u01b0ng v\u1ecb tr\u00ed c\u1ee7a c\u00e1c k\u00fd t\u1ef1 n\u00e0y kh\u00f4ng gi\u1ed1ng nhau, t\u1ee9c l\u00e0 n\u00f3 c\u00f3 th\u1ec3 n\u1eb1m ng\u1eabu nhi\u00ean\u00a0\u1edf b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o trong\u00a0\u00f4, mi\u1ec5n l\u00e0 c\u00f3\u00a0\u0111\u00fang k\u00fd t\u1ef1\u00a0\u0111\u00f3.<\/p>\n<p>Y\u00eau c\u1ea7u l\u00e0 t\u00ednh t\u1ed5ng doanh thu c\u1ee7a nh\u1eefng nh\u00e2n vi\u00ean c\u00f3 m\u00e3 ID l\u1ea7n l\u01b0\u1ee3t l\u00e0 KD1 v\u00e0 KD2.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-676058352a4c0\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-tong-theo-cac-o-co-ky-tu-giong-nhau-trong-excel.html#Cach_tinh_tong_theo_cac_o_co_ky_tu_giong_nhau_trong_Excel\" title=\"C\u00e1ch t\u00ednh t\u1ed5ng theo c\u00e1c \u00f4 c\u00f3 k\u00fd t\u1ef1 gi\u1ed1ng nhau trong Excel\">C\u00e1ch t\u00ednh t\u1ed5ng theo c\u00e1c \u00f4 c\u00f3 k\u00fd t\u1ef1 gi\u1ed1ng nhau trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-tong-theo-cac-o-co-ky-tu-giong-nhau-trong-excel.html#Cach_1_Tao_cot_phu_nhan_biet_gia_tri_dieu_kien_tinh\" title=\"C\u00e1ch 1: T\u1ea1o c\u1ed9t ph\u1ee5 nh\u1eadn bi\u1ebft gi\u00e1 tr\u1ecb\u00a0\u0111i\u1ec1u ki\u1ec7n t\u00ednh\">C\u00e1ch 1: T\u1ea1o c\u1ed9t ph\u1ee5 nh\u1eadn bi\u1ebft gi\u00e1 tr\u1ecb\u00a0\u0111i\u1ec1u ki\u1ec7n t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-tong-theo-cac-o-co-ky-tu-giong-nhau-trong-excel.html#Cach_2_Tinh_truc_tiep_khong_dung_cot_phu_voi_ham_SUMIF\" title=\"C\u00e1ch 2: T\u00ednh tr\u1ef1c ti\u1ebfp kh\u00f4ng d\u00f9ng c\u1ed9t ph\u1ee5 v\u1edbi h\u00e0m\u00a0SUMIF\">C\u00e1ch 2: T\u00ednh tr\u1ef1c ti\u1ebfp kh\u00f4ng d\u00f9ng c\u1ed9t ph\u1ee5 v\u1edbi h\u00e0m\u00a0SUMIF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-tong-theo-cac-o-co-ky-tu-giong-nhau-trong-excel.html#Cach_3_Su_dung_ham_SUMPRODUCT\" title=\"C\u00e1ch 3: S\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT\">C\u00e1ch 3: S\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tinh_tong_theo_cac_o_co_ky_tu_giong_nhau_trong_Excel\"><\/span>C\u00e1ch t\u00ednh t\u1ed5ng theo c\u00e1c \u00f4 c\u00f3 k\u00fd t\u1ef1 gi\u1ed1ng nhau trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong b\u00e0i to\u00e1n tr\u00ean, m\u1edbi \u0111\u1ecdc th\u00ec th\u1ea5y kh\u00e1 ph\u1ee9c t\u1ea1p. Nh\u01b0ng th\u1ef1c ra ta c\u00f3 r\u1ea5t nhi\u1ec1u <a href=\"http:\/\/blog.ezworkapp.com\/cac-cach-tinh-tong-nhanh-trong-excel-nhieu-cach-hay-va-la.html\"><strong>c\u00e1ch t\u00ednh t\u1ed5ng trong Excel<\/strong><\/a> v\u00e0 b\u1ea1n s\u1ebd b\u1ea5t ng\u1edd khi bi\u1ebft ch\u00fang ta c\u00f3 nhi\u1ec1u c\u00e1ch gi\u1ea3i:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_1_Tao_cot_phu_nhan_biet_gia_tri_dieu_kien_tinh\"><\/span>C\u00e1ch 1: T\u1ea1o c\u1ed9t ph\u1ee5 nh\u1eadn bi\u1ebft gi\u00e1 tr\u1ecb\u00a0\u0111i\u1ec1u ki\u1ec7n t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1edfi v\u00ec c\u00e1c k\u00fd t\u1ef1 n\u1eb1m l\u1eabn trong chu\u1ed7i k\u00fd t\u1ef1\u00a0\u1edf m\u1ed7i\u00a0\u00f4 n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m x\u00e1c\u00a0\u0111\u1ecbnh ri\u00eang t\u1eebng k\u00fd t\u1ef1 xem\u00a0\u00f4 n\u00e0o ch\u1ee9a k\u00fd t\u1ef1\u00a0\u0111\u00f3. Ch\u00e8n th\u00eam c\u1ed9t ph\u1ee5 ph\u00eda sau c\u1ed9t Doanh thu v\u00e0 d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-search-trong-excel-cach-dung-va-vi-du.html\">h\u00e0m SEARCH<\/a> x\u00e1c\u00a0\u0111\u1ecbnh nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-486.gif\" title=\"ex101_92019-nho-486\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24211\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-search-kiem-tra-co-gia-tri-dieu-kien-khong.png\" width=\"674\" height=\"333\" title=\"ham-search-kiem-tra-co-gia-tri-dieu-kien-khong\"><\/p>\n<p>Trong c\u00e2u l\u1ec7nh\u00a0IFERROR(SEARCH($C$1,A2),0) ta c\u00f3:<\/p>\n<ul>\n<li>Th\u1ee9 1: Search gi\u00e1 tr\u1ecb trong\u00a0\u00f4 C1 (l\u00e0 KD1) xem c\u00f3 trong\u00a0\u00f4 A2 hay kh\u00f4ng. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 n\u1ebfu c\u00f3 s\u1ebd l\u00e0 v\u1ecb tr\u00ed k\u00fd t\u1ef1 b\u1eaft\u00a0\u0111\u1ea7u xu\u1ea5t hi\u1ec7n trong\u00a0\u00f4 A2. N\u1ebfu kh\u00f4ng s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE<\/li>\n<li>Th\u1ee9 2: K\u1ebft h\u1ee3p h\u00e0m\u00a0IFERROR\u00a0\u0111\u1ec3 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p l\u1ed7i #VALUE khi kh\u00f4ng t\u00ecm th\u1ea5y b\u1edfi h\u00e0m SEARCH, l\u00fac\u00a0\u0111\u00f3 gi\u00e1 tr\u1ecb l\u1ed7i s\u1ebd\u00a0\u0111\u01b0\u1ee3c thay b\u1eb1ng s\u1ed1 0<\/li>\n<\/ul>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi gi\u00e1 tr\u1ecb\u00a0\u1edf\u00a0\u00f4 D1 l\u00e0 KD2<\/p>\n<p style=\"padding-left: 30px\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-nhan-biet-loai-loi-va-cach-bay-loi-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch nh\u1eadn bi\u1ebft lo\u1ea1i l\u1ed7i v\u00e0 c\u00e1ch b\u1eaby l\u1ed7i trong Excel<\/a><\/p>\n<p>Khi\u00a0\u0111\u00f3 k\u1ebft qu\u1ea3 &gt;0 t\u1ee9c l\u00e0 c\u00f3 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm, =0 l\u00e0 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/p>\n<p>B\u00e2y gi\u1edd b\u00e0i to\u00e1n tr\u1edf n\u00ean kh\u00e1\u00a0\u0111\u01a1n gi\u1ea3n, ch\u00fang ta ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m SUMIF\u00a0\u0111\u1ec3 t\u00ednh k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24212\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-sumif-de-tinh-cach-thong-thuong.png\" width=\"1059\" height=\"335\" title=\"su-dung-ham-sumif-de-tinh-cach-thong-thuong\"><\/p>\n<p>K\u1ebft qu\u1ea3 t\u1ed5ng doanh thu c\u1ee7a nh\u00e2n vi\u00ean c\u00f3 m\u00e3 ID\u00a0l\u00e0 KD1 =SUMIF(C2:C10,\u201d&gt;0\u2033,B2:B10)<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u00e2n vi\u00ean c\u00f3 m\u00e3 KD2 l\u00e0\u00a0=SUMIF(D2:D10,\u201d&gt;0\u2033,B2:B10)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_2_Tinh_truc_tiep_khong_dung_cot_phu_voi_ham_SUMIF\"><\/span>C\u00e1ch 2: T\u00ednh tr\u1ef1c ti\u1ebfp kh\u00f4ng d\u00f9ng c\u1ed9t ph\u1ee5 v\u1edbi h\u00e0m\u00a0SUMIF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c th\u00eam c\u1ed9t ph\u1ee5 khi\u1ebfn ch\u00fang ta ph\u1ea3i th\u00eam m\u1ed7i\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 1 c\u1ed9t, t\u1ea1i m\u1ed7i c\u1ed9t l\u1ea1i s\u1eed d\u1ee5ng nhi\u1ec1u c\u00f4ng th\u1ee9c. T\u1ea1i sao kh\u00f4ng l\u00e0m tr\u1ef1c ti\u1ebfp\u00a0\u0111\u1ec3 ti\u1ebft ki\u1ec7m t\u00e0i nguy\u00ean c\u1ee7a\u00a0Excel nh\u1ec9? C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u00e0m tr\u1ef1c ti\u1ebfp\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c\u00a0nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24214\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-sumif-de-tinh-cach-truc-tiep-2.png\" width=\"978\" height=\"333\" title=\"su-dung-ham-sumif-de-tinh-cach-truc-tiep-2\"><\/p>\n<p>V\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 KD1, ch\u00fang ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\">H3=SUMIF(A2:A10,\u201d*\u201d&amp;F3&amp;\u201d*\u201d,B2:B10)<\/p>\n<ul>\n<li>V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0\u00a0\u1edf c\u1ed9t A, t\u1eeb A2:A10 l\u00e0 ID nh\u00e2n vi\u00ean<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n l\u00e0\u00a0\u201c*\u201d&amp;F3&amp;\u201d*\u201d c\u00f3 ngh\u0129a l\u00e0 th\u00eam 2 d\u1ea5u *\u00a0\u1edf tr\u01b0\u1edbc v\u00e0 sau gi\u00e1 tr\u1ecb trong\u00a0\u00f4 F3. V\u00ec d\u1ea5u * l\u00e0 k\u00fd t\u1ef1\u00a0\u0111\u1eb7c bi\u1ec7t n\u1ed1i v\u1edbi\u00a0\u00f4 F3 n\u00ean\u00a0c\u1ea7n\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p, sau\u00a0\u0111\u00f3 s\u1eed d\u1ee5ng d\u1ea5u &amp;\u00a0\u0111\u1ec3 n\u1ed1i k\u00fd t\u1ef1.<\/li>\n<li>V\u00f9ng t\u00ednh t\u1ed5ng l\u00e0 c\u1ed9t Doanh thu, t\u1eeb B2:B10<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 c\u0169ng b\u1eb1ng v\u1edbi c\u00e1ch th\u1ee9 1.<\/p>\n<p>N\u1ebfu kh\u00f4ng mu\u1ed1n s\u1eed d\u1ee5ng h\u00e0m SUMIF, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 thay b\u1eb1ng h\u00e0m SUMIFS nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">H3=SUMIFS(B2:B10,A2:A10,\u201d*\u201d&amp;F3&amp;\u201d*\u201d)<\/p>\n<p>C\u00e1c n\u1ed9i dung trong h\u00e0m n\u00e0y v\u1eabn gi\u1ed1ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF<\/strong><\/a>, nh\u01b0ng th\u1ee9 t\u1ef1 c\u00f3 thay\u00a0\u0111\u1ed5i 1 ch\u00fat khi v\u00f9ng t\u00ednh t\u1ed5ng\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u01b0a l\u00ean th\u00e0nh ph\u1ea7n th\u1ee9 1\u00a0\u1edf trong h\u00e0m.<\/p>\n<p style=\"padding-left: 30px\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-tinh-tong-excel.html\">H\u00e0m SUMIF \/ SUMIFS T\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_3_Su_dung_ham_SUMPRODUCT\"><\/span>C\u00e1ch 3: S\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u1eb3n b\u1ea1n\u00a0\u0111\u00e3 nghe n\u00f3i t\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">h\u00e0m SUMPRODUCT <\/a>c\u00f3 th\u1ec3 thay th\u1ebf ho\u00e0n to\u00e0n cho h\u00e0m SUMIF, SUMIFS. Trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta s\u1ebd xem h\u00e0m SUMPRODUCT c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c kh\u00f4ng nh\u00e9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24216\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-sumproduct-tinh-tong-o-co-gia-tri-nam-giua.png\" width=\"1108\" height=\"330\" title=\"su-dung-ham-sumproduct-tinh-tong-o-co-gia-tri-nam-giua\"><\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 I3 s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=SUMPRODUCT(($B$2:$B$10)*(IFERROR(SEARCH(F3,$A$2:$A$10),0)&gt;0))<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y ph\u1ea7n\u00a0IFERROR(SEARCH(F3,$A$2:$A$10),0) ch\u00ednh l\u00e0 n\u1ed9i dung trong c\u1ed9t ph\u1ee5 m\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 l\u00e0m\u00a0\u1edf tr\u00ean.<\/p>\n<p>Khi\u00a0\u0111\u1eb7t trong h\u00e0m SUMPRODUCT, ch\u00fang ta s\u1ebd so s\u00e1nh k\u1ebft qu\u1ea3\u00a0\u0111\u00f3 c\u00f3 &gt;0 hay kh\u00f4ng, v\u00e0 v\u1edbi nh\u1eefng gi\u00e1 tr\u1ecb &gt;0 s\u1ebd d\u00f9ng\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng trong c\u1ed9t Doanh thu.<\/p>\n<p><strong><em>* L\u01b0u\u00a0\u00fd:<\/em><\/strong><\/p>\n<p>C\u00e1ch vi\u1ebft sau\u00a0\u0111\u00e2y kh\u00f4ng ra k\u1ebft qu\u1ea3:<\/p>\n<p style=\"padding-left: 30px\">=SUMPRODUCT(($B$2:$B$10)*($A$2:$A$10=\u201d*\u201d&amp;F3&amp;\u201d*\u201d)<\/p>\n<p>R\u1ea5t th\u00fa v\u1ecb ph\u1ea3i kh\u00f4ng n\u00e0o. Nh\u01b0 v\u1eady l\u00e0 H\u1ecdc\u00a0Excel Online\u00a0\u0111\u00e3 gi\u1edbi thi\u1ec7u cho b\u1ea1n 3 c\u00e1ch l\u00e0m b\u00e0i to\u00e1n n\u00e0y. B\u1ea1n c\u00f3 c\u00e1ch n\u00e0o kh\u00e1c kh\u00f4ng? H\u00e3y chia s\u1ebb c\u00f9ng ch\u00fang t\u00f4i nh\u00e9.<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tai-sao-nen-dung-ham-sumifs-thay-cho-ham-sumproduct-tinh-tong-theo-nhieu-dieu-kien.html\">T\u1ea1i sao n\u00ean d\u00f9ng h\u00e0m SUMIFS thay cho h\u00e0m SUMPRODUCT t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien.html\">So s\u00e1nh h\u00e0m COUNTIFS v\u1edbi SUMPRODUCT trong vi\u1ec7c \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-486.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5582,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5581","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5581","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=5581"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5581\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5582"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}