{"id":1545,"date":"2024-12-02T05:24:08","date_gmt":"2024-12-02T05:24:08","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc\/"},"modified":"2024-12-02T05:24:08","modified_gmt":"2024-12-02T05:24:08","slug":"cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m SUMIF trong Excel \u2013 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online <\/strong><\/a>s\u1ebd gi\u1ea3i th\u00edch <strong><em>h\u00e0m SUMIF <\/em><\/strong>v\u00e0 cung c\u1ea5p m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9 v\u1ec1 <strong>h\u00e0m\u00a0<\/strong> <strong><em>SUMIF<\/em><\/strong> cho d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng v\u00e0 nh\u1eefng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111ang ph\u1ea3i \u0111\u1ed1i m\u1eb7t v\u1edbi nhi\u1ec7m v\u1ee5 t\u00ednh t\u1ed5ng c\u00e1c d\u1eef li\u1ec7u th\u1ecfa \u0111i\u1ec1u ki\u1ec7n trong Excel, th\u00ec <strong>h\u00e0m <em>SUMIF<\/em><\/strong> l\u00e0 nh\u1eefng g\u00ec m\u00e0 b\u1ea1n c\u1ea7n. H\u01b0\u1edbng d\u1eabn n\u00e0y s\u1ebd gi\u1ea3i th\u00edch ng\u1eafn g\u1ecdn v\u1ec1 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chung, v\u00e0 ti\u1ebfp \u0111\u00f3 b\u1ea1n s\u1ebd b\u1ed5 sung th\u00eam ki\u1ebfn th\u1ee9c trong vi\u1ec7c th\u1ef1c h\u00e0nh v\u1edbi m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c c\u1ee7a <strong>h\u00e0m <em>SUMIF<\/em><\/strong>.<\/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-674d44776ca99\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#SUMIF_trong_Excel_%E2%80%93_cu_phap_va_cach_su_dung\" title=\"SUMIF trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\">SUMIF trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Lam_the_nao_de_su_dung_Ham_SUMIF_trong_Excel_%E2%80%93_cong_thuc_minh_hoa\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng H\u00e0m SUMIF trong Excel \u2013 c\u00f4ng th\u1ee9c minh h\u1ecda\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng H\u00e0m SUMIF trong Excel \u2013 c\u00f4ng th\u1ee9c minh h\u1ecda<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#SUMIF_voi_dau_lon_hon_nho_hon_hoac_bang\" title=\"SUMIF v\u1edbi d\u1ea5u l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng:\">SUMIF v\u1edbi d\u1ea5u l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Ham_SUMIF_tinh_tong_theo_dieu_kien_so_sanh_voi_chuoi\" title=\"H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh v\u1edbi chu\u1ed7i\">H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh v\u1edbi chu\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Su_dung_dau_so_sanh_voi_tham_chieu_o\" title=\"S\u1eed d\u1ee5ng d\u1ea5u so s\u00e1nh v\u1edbi tham chi\u1ebfu \u00f4\">S\u1eed d\u1ee5ng d\u1ea5u so s\u00e1nh v\u1edbi tham chi\u1ebfu \u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Cong_thuc_SUMIF_voi_ki_tu_dai_dien\" title=\"C\u00f4ng th\u1ee9c SUMIF v\u1edbi k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n\">C\u00f4ng th\u1ee9c SUMIF v\u1edbi k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Vi_du_1_Cac_gia_tri_tinh_tong_dua_tren_doi_chieu_tung_phan\" title=\"V\u00ed d\u1ee5 1. C\u00e1c gi\u00e1 tr\u1ecb t\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean \u0111\u1ed1i chi\u1ebfu t\u1eebng ph\u1ea7n:\">V\u00ed d\u1ee5 1. C\u00e1c gi\u00e1 tr\u1ecb t\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean \u0111\u1ed1i chi\u1ebfu t\u1eebng ph\u1ea7n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Vi_du_2_Tong_gia_tri_voi_so_ki_tu_nhat_dinh\" title=\"V\u00ed d\u1ee5 2. T\u1ed5ng gi\u00e1 tr\u1ecb v\u1edbi s\u1ed1 k\u00ed t\u1ef1 nh\u1ea5t \u0111\u1ecbnh\">V\u00ed d\u1ee5 2. T\u1ed5ng gi\u00e1 tr\u1ecb v\u1edbi s\u1ed1 k\u00ed t\u1ef1 nh\u1ea5t \u0111\u1ecbnh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Vi_du_3_Tinh_tong_cac_o_co_gia_tri_tuong_ung_voi_gia_tri_van_ban\" title=\"V\u00ed d\u1ee5 3. T\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n\">V\u00ed d\u1ee5 3. T\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Vi_du_4_Su_dung_hoac_nhu_nhung_ki_tu_binh_thuong\" title=\"V\u00ed d\u1ee5 4. S\u1eed d\u1ee5ng * ho\u1eb7c ? nh\u01b0 nh\u1eefng k\u00ed t\u1ef1 b\u00ecnh th\u01b0\u1eddng\">V\u00ed d\u1ee5 4. S\u1eed d\u1ee5ng * ho\u1eb7c ? nh\u01b0 nh\u1eefng k\u00ed t\u1ef1 b\u00ecnh th\u01b0\u1eddng<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Tong_cac_so_lon_nhat_hoac_nho_nhat_trong_mot_dai\" title=\"T\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn nh\u1ea5t ho\u1eb7c nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u1ea3i:\">T\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn nh\u1ea5t ho\u1eb7c nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u1ea3i:<\/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-12\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Vi_du_1_Them_mot_vai_so_lon_nhat_nho_nhat\" title=\"V\u00ed d\u1ee5 1. Th\u00eam m\u1ed9t v\u00e0i s\u1ed1 l\u1edbn nh\u1ea5t \/ nh\u1ecf nh\u1ea5t\">V\u00ed d\u1ee5 1. Th\u00eam m\u1ed9t v\u00e0i s\u1ed1 l\u1edbn nh\u1ea5t \/ nh\u1ecf nh\u1ea5t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Vi_du_2_Them_vao_cac_gia_tri_lonnho\" title=\"V\u00ed d\u1ee5 2. Th\u00eam v\u00e0o c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn\/nh\u1ecf\">V\u00ed d\u1ee5 2. Th\u00eam v\u00e0o c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn\/nh\u1ecf<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Vi_du_3_Tinh_tong_mot_bien_so_trong_cac_gia_tri_lon_nhat_nho_nhat\" title=\"V\u00ed d\u1ee5 3. T\u00ednh t\u1ed5ng m\u1ed9t bi\u1ebfn s\u1ed1 trong c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \/ nh\u1ecf nh\u1ea5t\">V\u00ed d\u1ee5 3. T\u00ednh t\u1ed5ng m\u1ed9t bi\u1ebfn s\u1ed1 trong c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \/ nh\u1ecf nh\u1ea5t<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Lam_the_nao_de_tinh_tong_cac_o_tuong_ung_voi_cac_o_trong\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c \u00f4 tr\u1ed1ng\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c \u00f4 tr\u1ed1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Lam_the_nao_de_tinh_tong_cac_o_tuong_ung_voi_cac_o_khong_trong\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Cach_su_dung_Ham_SUMIF_voi_ngay_thang\" title=\"C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m SUMIF v\u1edbi ng\u00e0y th\u00e1ng\">C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m SUMIF v\u1edbi ng\u00e0y th\u00e1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Cach_tinh_tong_cac_gia_tri_ung_voi_trong_mot_quang_thoi_gian_nhat_dinh\" title=\"C\u00e1ch t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u1ee9ng v\u1edbi trong m\u1ed9t qu\u00e3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh\">C\u00e1ch t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u1ee9ng v\u1edbi trong m\u1ed9t qu\u00e3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Lam_the_nao_de_tinh_tong_cac_gia_tri_trong_mot_vai_cot\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t v\u00e0i c\u1ed9t\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t v\u00e0i c\u1ed9t<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#Nhung_cau_hoi_thuong_gap_hoac_%E2%80%9CTai_sao_cong_thuc_SUMIF_cua_toi_khong_hoat_dong%E2%80%9D\" title=\"Nh\u1eefng c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p ho\u1eb7c \u201cT\u1ea1i sao c\u00f4ng th\u1ee9c SUMIF c\u1ee7a t\u00f4i kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng?\u201d\">Nh\u1eefng c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p ho\u1eb7c \u201cT\u1ea1i sao c\u00f4ng th\u1ee9c SUMIF c\u1ee7a t\u00f4i kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng?\u201d<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#1_Cac_tham_so_cua_range_va_sum_range_phai_la_cac_dai_chu_khong_phai_mang\" title=\"1. C\u00e1c tham s\u1ed1 c\u1ee7a range v\u00e0 sum_range ph\u1ea3i l\u00e0 c\u00e1c d\u1ea3i, ch\u1ee9 kh\u00f4ng ph\u1ea3i m\u1ea3ng:\">1. C\u00e1c tham s\u1ed1 c\u1ee7a range v\u00e0 sum_range ph\u1ea3i l\u00e0 c\u00e1c d\u1ea3i, ch\u1ee9 kh\u00f4ng ph\u1ea3i m\u1ea3ng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#2_Lam_the_nao_de_tinh_tong_gia_tri_tu_cac_trang_tinh_hoac_bang_tinh_khac\" title=\"2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb t\u1eeb c\u00e1c trang t\u00ednh ho\u1eb7c b\u1ea3ng t\u00ednh kh\u00e1c:\">2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb t\u1eeb c\u00e1c trang t\u00ednh ho\u1eb7c b\u1ea3ng t\u00ednh kh\u00e1c:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#3_Hay_chac_chan_range_va_sum_range_co_cung_kich_co\" title=\"3. H\u00e3y ch\u1eafc ch\u1eafn range v\u00e0 sum_range c\u00f3 c\u00f9ng k\u00edch c\u1ee1:\">3. H\u00e3y ch\u1eafc ch\u1eafn range v\u00e0 sum_range c\u00f3 c\u00f9ng k\u00edch c\u1ee1:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html#4_Lam_the_nao_de_cong_thuc_SUMIF_cua_ban_hoat_dong_nhanh_hon\" title=\"4. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f4ng th\u1ee9c SUMIF c\u1ee7a b\u1ea1n ho\u1ea1t \u0111\u1ed9ng nhanh h\u01a1n:\">4. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f4ng th\u1ee9c SUMIF c\u1ee7a b\u1ea1n ho\u1ea1t \u0111\u1ed9ng nhanh h\u01a1n:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"SUMIF_trong_Excel_%E2%80%93_cu_phap_va_cach_su_dung\"><\/span><strong><em>SUMIF<\/em><\/strong> trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\"><strong>H\u00e0m SUMIF<\/strong>, c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u00eam c\u00e1c \u00f4, d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e3 \u0111\u1ecdc h\u01b0\u1edbng d\u1eabn v\u1ec1<a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-trong-excel-huong-dan-cu-va-co-vi-du-minh-hoa.html\" target=\"_blank\" rel=\"noopener noreferrer\"> h\u00e0m\u00a0<strong><em>COUNTIF<\/em><\/strong><\/a> tr\u00ean trang blog n\u00e0y, th\u00ec b\u1ea1n s\u1ebd kh\u00f4ng g\u1eb7p b\u1ea5t k\u1ef3 kh\u00f3 kh\u0103n n\u00e0o khi hi\u1ec3u h\u00e0m SUMIF, b\u1edfi c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a n\u00f3 c\u0169ng t\u01b0\u01a1ng t\u1ef1. Do \u0111\u00f3, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIF nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>SUMIF (range, criteria, [sum_range])<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y,<strong> h\u00e0m SUMIF<\/strong> c\u00f3 3 \u0111\u1ed1i s\u1ed1 \u2013 2 \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u l\u00e0 b\u1eaft bu\u1ed9c, c\u00f2n \u0111\u1ed1i s\u1ed1 th\u1ee9 3 l\u00e0 t\u00f9y ch\u1ecdn.<\/p>\n<ol style=\"text-align: justify\">\n<li><strong><em>range <\/em><\/strong>\u2013 d\u1ea3i c\u1ee7a c\u00e1c \u00f4 \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 theo ti\u00eau ch\u00ed c\u1ee7a b\u1ea1n, v\u00ed d\u1ee5 A1: A10.<\/li>\n<li><strong><em>criteria<\/em><\/strong> \u2013 \u0111i\u1ec1u ki\u1ec7n\/ti\u00eau ch\u00ed c\u1ea7n ph\u1ea3i \u0111\u00e1p \u1ee9ng. C\u00e1c ti\u00eau ch\u00ed c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c cung c\u1ea5p d\u01b0\u1edbi d\u1ea1ng s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y, bi\u1ec3u th\u1ee9c logic, tham chi\u1ebfu \u00f4, ho\u1eb7c m\u1ed9t h\u00e0m Excel kh\u00e1c. V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00e1c ti\u00eau ch\u00ed nh\u01b0 \u201c5\u201d, \u201c<strong><em>cherries<\/em><\/strong>\u201c, \u201c10\/25\/2014\u201d, \u201c&lt;5\u201d, \u201cA1\u201d, v.v \u2026<\/li>\n<\/ol>\n<p style=\"text-align: justify\">L\u01b0u \u00fd: H\u00e3y ch\u00fa \u00fd r\u1eb1ng b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n d\u1ea1ng v\u0103n b\u1ea3n ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n c\u00f3 ch\u1ee9a c\u00e1c k\u00fd hi\u1ec7u to\u00e1n h\u1ecdc th\u00ec \u0111\u1ec1u ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p (\u201c\u201d). \u0110\u1ed1i v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n s\u1ed1, d\u1ea5u nh\u00e1y k\u00e9p l\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-45.gif\" title=\"vba101_92019-nho-45\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-112.gif\" title=\"ex101_92019-nho-112\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol style=\"text-align: justify\" start=\"3\">\n<li><strong><em>sum_range <\/em><\/strong>\u2013 c\u00e1c \u00f4 d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. \u0110\u1ed1i s\u1ed1 n\u00e0y l\u00e0 t\u00f9y b\u1ea1n ch\u1ecdn, v\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng n\u00f3 n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c \u00f4 kh\u00e1c (m\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a trong \u0111\u1ed1i s\u1ed1 range). N\u1ebfu \u0111\u1ed1i s\u1ed1 sum_range b\u1ecb b\u1ecf qua, khi \u0111\u00f3 Excel s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u01b0\u01a1ng t\u1ef1 m\u00e0 c\u00e1c ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c \u0111\u1eb7t ra (ngh\u0129a l\u00e0 ch\u00fang \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong \u0111\u1ed1i s\u1ed1 range).<\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ec3 minh h\u1ecda c\u00fa ph\u00e1p <strong>h\u00e0m <em>SUMIF <\/em><\/strong><em>m\u1ed9t c\u00e1ch d\u1ec5 hi\u1ec3u<\/em>, h\u00e3y xem x\u00e9t v\u00ed d\u1ee5 sau \u0111\u00e2y. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c s\u1ea3n ph\u1ea9m trong c\u1ed9t A v\u00e0 s\u1ed1 l\u01b0\u1ee3ng t\u01b0\u01a1ng \u1ee9ng trong kho trong c\u1ed9t C. V\u1ea5n \u0111\u1ec1 \u0111\u01b0a ra l\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c l\u01b0\u1ee3ng h\u00e0ng t\u1ed3n kho li\u00ean quan \u0111\u1ebfn m\u1ed9t s\u1ea3n ph\u1ea9m nh\u1ea5t \u0111\u1ecbnh, v\u00ed d\u1ee5: bananas.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/source-data.png\" alt=\"Data to be conditionally summed.\" title=\"source-data\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, h\u00e3y x\u00e1c \u0111\u1ecbnh c\u00e1c \u0111\u1ed1i s\u1ed1 cho c\u00f4ng th\u1ee9c SUMIF c\u1ee7a ch\u00fang ta:<\/p>\n<ul style=\"text-align: justify\">\n<li>range-A2: A8<\/li>\n<li>criteria \u2013 \u201cbananas\u201d<\/li>\n<li>sum_range \u2013 C2: C8<\/li>\n<\/ul>\n<p style=\"text-align: justify\">G\u1ed9p c\u00e1c \u0111\u1ed1i s\u1ed1 l\u1ea1i v\u00e0 b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c: = SUMIF (A2: A8, \u201cbananas\u201d, C2: C8)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-function.png\" alt=\"Excel SUMIF formula example\" title=\"excel-sumif-function\"><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c v\u00ed d\u1ee5 n\u00e0y th\u1ec3 hi\u1ec7n c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n c\u1ee7a <strong>h\u00e0m SUMIF<\/strong> trong excel v\u1edbi c\u00e1c ti\u00eau ch\u00ed d\u1ea1ng v\u0103n b\u1ea3n. Thay v\u00ec v\u0103n b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u01b0a v\u00e0o m\u1ed9t s\u1ed1, ng\u00e0y ho\u1eb7c m\u1ed9t \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu \u0111\u1ebfn trong ti\u00eau ch\u00ed b\u1ea1n \u0111\u01b0a ra. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft l\u1ea1i c\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ec3 n\u00f3 tham chi\u1ebfu \u0111\u1ebfn \u00f4 c\u00f3 ch\u1ee9a t\u00ean c\u1ee7a s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng:<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUMIF (A2: A8, F1, C2: C8)<\/code><\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa th\u00edch<\/strong>: Tham s\u1ed1 sum_range th\u1ef1c s\u1ef1 ch\u1ec9 x\u00e1c \u0111\u1ecbnh \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a d\u1ea3i \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng. Khu v\u1ef1c c\u00f2n l\u1ea1i th\u00ec l\u1ea1i \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi k\u00edch th\u01b0\u1edbc c\u1ee7a \u0111\u1ed1i s\u1ed1 range.<\/p>\n<p style=\"text-align: justify\">Trong th\u1ef1c t\u1ebf, \u0111i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 \u0111\u1ed1i s\u1ed1 sum_range kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc v\u1edbi \u0111\u1ed1i s\u1ed1 d\u1ea3i, ngh\u0129a l\u00e0 n\u00f3 c\u00f3 th\u1ec3 kh\u00e1c nhau v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng v\u00e0 c\u1ed9t. Tuy nhi\u00ean, \u00f4 \u0111\u1ea7u ti\u00ean (t\u1ee9c l\u00e0 \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i) c\u1ee7a d\u1ea3i t\u00ednh t\u1ed5ng ph\u1ea3i lu\u00f4n lu\u00f4n \u1edf \u0111\u00fang c\u1ed9t. V\u00ed d\u1ee5, trong c\u00f4ng th\u1ee9c SUMIF \u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 l\u1ea5y \u00f4 C2, ho\u1eb7c C2: C4, hay th\u1eadm ch\u00ed l\u00e0 C2: C100 l\u00e0m \u0111\u1ed1i s\u1ed1 <strong><em>sum_range<\/em><\/strong>, v\u00e0 k\u1ebft qu\u1ea3 v\u1eabn s\u1ebd nh\u01b0 c\u0169. Tuy nhi\u00ean, h\u01b0\u1edbng \u0111i t\u1ed1t nh\u1ea5t v\u1eabn l\u00e0 cung c\u1ea5p <strong><em>range<\/em><\/strong> v\u00e0 <strong><em>sum_range <\/em><\/strong>c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc.<\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_su_dung_Ham_SUMIF_trong_Excel_%E2%80%93_cong_thuc_minh_hoa\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng H\u00e0m <strong><em>SUMIF<\/em><\/strong> trong Excel \u2013 c\u00f4ng th\u1ee9c minh h\u1ecda<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Hy v\u1ecdng r\u1eb1ng, v\u00ed d\u1ee5 tr\u00ean \u0111\u00e3 gi\u00fap b\u1ea1n hi\u1ec3u c\u01a1 b\u1ea3n \u0111\u01b0\u1ee3c c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m SUMIF. D\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c cho bi\u1ebft r\u1eb1ng l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng<strong> h\u00e0m SUMIF trong Excel<\/strong> v\u1edbi c\u00e1c ti\u00eau ch\u00ed kh\u00e1c nhau v\u00e0 lo\u1ea1t d\u1eef li\u1ec7u kh\u00e1c nhau.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"SUMIF_voi_dau_lon_hon_nho_hon_hoac_bang\"><\/span><strong><em>SUMIF<\/em><\/strong> v\u1edbi d\u1ea5u l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e3y nh\u00ecn v\u00e0o m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c <strong>h\u00e0m <em>SUMIF<\/em><\/strong> m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 th\u00eam v\u00e0o c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd: Trong c\u00e1c c\u00f4ng th\u1ee9c <strong>h\u00e0m <em><strong>SU<\/strong>MIF<\/em><\/strong>, m\u1ed9t d\u1ea5u so s\u00e1nh theo sau b\u1edfi m\u1ed9t s\u1ed1 ho\u1eb7c m\u1ed9t v\u0103n b\u1ea3n ph\u1ea3i lu\u00f4n lu\u00f4n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p (\u201c\u201d).<\/p>\n<table style=\"height: 535px\" width=\"967\">\n<tbody>\n<tr>\n<td style=\"text-align: left\">\u0110i\u1ec1u ki\u1ec7n<\/td>\n<td style=\"text-align: left\">To\u00e1n t\u1eed<\/td>\n<td style=\"text-align: left\">C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/td>\n<td style=\"text-align: left\">Gi\u1ea3i th\u00edch<\/td>\n<\/tr>\n<tr>\n<td>T\u00ednh t\u1ed5ng n\u1ebfu l\u1edbn h\u01a1n<\/td>\n<td>&gt;<\/td>\n<td>=SUMIF(A2:A10, \u201c&gt;5\u201d)<\/td>\n<td>T\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn h\u01a1n 5 trong v\u00f9ng A2:A10<\/td>\n<\/tr>\n<tr>\n<td>T\u00ednh t\u1ed5ng n\u1ebfu nh\u1ecf h\u01a1n<\/td>\n<td>&lt;<\/td>\n<td>=SUMIF(A2:A10, \u201c&lt;10\u201d, B2:B10)<\/td>\n<td>T\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong c\u1ed9t B, n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng, c\u00f9ng d\u00f2ng trong c\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n 10<\/td>\n<\/tr>\n<tr>\n<td>T\u00ednh t\u1ed5ng n\u1ebfu b\u1eb1ng<\/td>\n<td>=<\/td>\n<td>=SUMIF(A2:A10, \u201c=\u201d&amp;D1) ho\u1eb7c =SUMIF(A2:A10,D1)<\/td>\n<td>T\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong v\u00f9ng A2:A10, n\u1ebfu b\u1eb1ng D1<\/td>\n<\/tr>\n<tr>\n<td>T\u00ednh t\u1ed5ng n\u1ebfu kh\u00f4ng b\u1eb1ng<\/td>\n<td>&lt;&gt;<\/td>\n<td>=SUMIF(A2:A10, \u201c&lt;&gt;\u201d&amp;D1, B2:B10)<\/td>\n<td>T\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong c\u1ed9t B, n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng, c\u00f9ng d\u00f2ng trong c\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb kh\u00e1c gi\u00e1 tr\u1ecb \u1edf D1<\/td>\n<\/tr>\n<tr>\n<td>T\u00ednh t\u1ed5ng n\u1ebfu l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td>&gt;=<\/td>\n<td>=SUMIF(A2:A10, \u201c&gt;=5\u201d)<\/td>\n<td>T\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5 trong v\u00f9ng A2:A10<\/td>\n<\/tr>\n<tr>\n<td>T\u00ednh t\u1ed5ng n\u1ebfu nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td>&lt;=<\/td>\n<td>=SUMIF(A2:A10, \u201c&lt;=10\u201d, B2:B10)<\/td>\n<td>T\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong c\u1ed9t B, n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng, c\u00f9ng d\u00f2ng trong c\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUMIF_tinh_tong_theo_dieu_kien_so_sanh_voi_chuoi\"><\/span>H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh v\u1edbi chu\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e3y l\u01b0u \u00fd r\u1eb1ng b\u1ea1n s\u1ebd c\u1ea7n c\u00e1c c\u00f4ng th\u1ee9c <strong>h\u00e0m SUMIF<\/strong> kh\u00e1c nhau \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu ch\u00ednh x\u00e1c v\u00e0 t\u1eebng ph\u1ea7n, nh\u01b0 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<table style=\"height: 534px\" width=\"959\">\n<tbody>\n<tr>\n<td width=\"106\"><strong>Ti\u00eau ch\u00ed<\/strong><\/td>\n<td width=\"148\"><strong>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><\/td>\n<td width=\"369\"><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">T\u00ednh t\u1ed5ng n\u1ebfu b\u1eb1ng<\/td>\n<td><strong>\u0110\u1ed1i chi\u1ebfu ho\u00e0n to\u00e0n:<\/strong><br \/>\n<strong>=SUMIF(A2:A8, \u201cbananas\u201d, C2:C8)<\/strong><\/td>\n<td>Gi\u00e1 tr\u1ecb t\u00ednh t\u1ed5ng trong c\u00e1c \u00f4 C2:C8 n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t A ch\u1ee9a ch\u00ednh x\u00e1c t\u1eeb \u201cbananas\u201d v\u00e0 kh\u00f4ng d\u01b0 m\u1ed9t t\u1eeb hay k\u00ed t\u1ef1 n\u00e0o. C\u00e1c \u00f4 ch\u1ee9a \u201cgreen bananas\u201d, \u201cbananas green\u201d or \u201cbananas!\u201d kh\u00f4ng bao g\u1ed3m trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y.<\/td>\n<\/tr>\n<tr>\n<td><strong>\u0110\u1ed1i chi\u1ebfu t\u1eebng ph\u1ea7n:<\/strong><br \/>\n<strong>=SUMIF(A2:A8, \u201c*bananas*\u201d, C2:C8)<\/strong><\/td>\n<td>Gi\u00e1 tr\u1ecb t\u00ednh t\u1ed5ng trong c\u00e1c \u00f4 C2:C8 n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t A ch\u1ee9a t\u1eeb \u201cbananas\u201d, \u0111\u1ee9ng \u0111\u1ed9c l\u1eadp ho\u1eb7c \u0111i k\u00e8m v\u1edbi nh\u1eefng t\u1eeb kh\u00e1c\u201d. C\u00e1c \u00f4 ch\u1ee9a \u201cgreen bananas\u201d, \u201cbananas green\u201d or \u201cbananas!\u201d s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y.<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">T\u00ednh t\u1ed5ng n\u1ebfu kh\u00e1c<\/td>\n<td><strong>\u0110\u1ed1i chi\u1ebfu ho\u00e0n to\u00e0n:<\/strong><br \/>\n<strong>=SUMIF(A2:A8, \u201c&lt;&gt;bananas\u201d, C2:C8)<\/strong><\/td>\n<td>Gi\u00e1 tr\u1ecb t\u00ednh t\u1ed5ng trong c\u00e1c \u00f4 C2:C8 n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t A ch\u1ee9a b\u1ea5t k\u00ec gi\u00e1 tr\u1ecb n\u00e0o m\u00e0 kh\u00e1c \u201cbananas\u201d. N\u1ebfu \u00f4 ch\u1ee9a \u201cbananas\u201d c\u00f3 th\u00eam 1 s\u1ed1 t\u1eeb hay k\u00ed t\u1ef1 kh\u00e1c, v\u00ed nh\u01b0 \u201cyellow bananas\u201d ho\u1eb7c \u201cbananas yellow\u201d, th\u00ec ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng.<\/td>\n<\/tr>\n<tr>\n<td><strong>\u0110\u1ed1i chi\u1ebfu t\u1eebng ph\u1ea7n:<\/strong><br \/>\n<strong>=SUMIF(A2:A8, \u201c&lt;&gt;*bananas*\u201d, C2:C8)<\/strong><\/td>\n<td>Gi\u00e1 tr\u1ecb t\u00ednh t\u1ed5ng trong c\u00e1c \u00f4 C2:C8 n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t A ch\u1ee9a b\u1ea5t k\u00ec gi\u00e1 tr\u1ecb n\u00e0o m\u00e0 kh\u00e1c \u201cbananas\u201d. N\u1ebfu \u00f4 ch\u1ee9a \u201cbananas\u201d c\u00f3 th\u00eam 1 s\u1ed1 t\u1eeb kh\u00e1c. C\u00e1c \u00f4 nh\u01b0 \u201cyellow bananas\u201d or \u201cbananas yellow\u201d s\u1ebd kh\u00f4ng th\u1ecfa ti\u00eau ch\u00ed n\u00e0y.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">\u0110\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin v\u1ec1 gi\u00e1 tr\u1ecb kh\u1edbp 1 ph\u1ea7n, vui l\u00f2ng xem v\u00ed d\u1ee5 v\u1ec1 <strong>h\u00e0m SUMIF trong excel<\/strong> v\u1edbi c\u00e1c k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, h\u00e3y xem c\u00f4ng th\u1ee9c ch\u00ednh x\u00e1c \u201cT\u00ednh t\u1ed5ng n\u1ebfu kh\u00e1c\u201d qua c\u00e1c thao t\u00e1c. Nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi, n\u00f3 cho bi\u1ebft l\u01b0\u1ee3ng t\u1ed3n kho c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m kh\u00e1c ngo\u00e0i \u201cgoldfinger bananas\u201d:<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUMIF (A2: A7, \"&lt;&gt; goldfinger bananas\", C2: C7)<\/code><\/em><\/strong><strong><em>\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6357\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-167.png\" width=\"600\" height=\"208\" title=\"excel-dialog-box-launcher-1-167\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd: \u00a0Gi\u1ed1ng nh\u01b0 h\u1ea7u h\u1ebft c\u00e1c h\u00e0m Excel kh\u00e1c, SUMIF kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, c\u00f3 ngh\u0129a l\u00e0 d\u00f9 b\u1ea1n nh\u1eadp \u201c&lt;bananas\u201d, \u201c&lt;&gt; Bananas\u201d v\u00e0 \u201c&lt;BANANAS\u201d th\u00ec n\u00f3 \u0111\u00eau cho k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1\u1ed5<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_dau_so_sanh_voi_tham_chieu_o\"><\/span>S\u1eed d\u1ee5ng d\u1ea5u so s\u00e1nh v\u1edbi tham chi\u1ebfu \u00f4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n ti\u1ebfn xa h\u01a1n v\u00e0 mu\u1ed1n c\u00f3 m\u1ed9t c\u00f4ng th\u1ee9c <strong>h\u00e0m SUMIF<\/strong> ph\u1ed5 qu\u00e1t h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf gi\u00e1 tr\u1ecb s\u1ed1 ho\u1eb7c v\u0103n b\u1ea3n trong ti\u00eau ch\u00ed b\u1eb1ng m\u1ed9t \u00f4 tham chi\u1ebfu, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUMIF (A2: A8, \"&lt;&gt;\" &amp; F1, C2: C8)<\/code><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n s\u1ebd kh\u00f4ng ph\u1ea3i thay \u0111\u1ed5i c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed kh\u00e1c \u2013 m\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp m\u1ed9t gi\u00e1 tr\u1ecb m\u1edbi v\u00e0o m\u1ed9t \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-comparison-operator.png\" alt=\"Sum in-stock amounts of all products other than in cell F1.\" title=\"excel-sumif-comparison-operator\"><\/p>\n<p style=\"text-align: justify\">Ch\u00fa th\u00edch. Khi b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t bi\u1ec3u th\u1ee9c logic v\u1edbi m\u1ed9t tham chi\u1ebfu \u00f4, b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng d\u1ea5u nh\u00e1y k\u00e9p (\u201c\u201d) \u0111\u1ec3 b\u1eaft \u0111\u1ea7u m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 d\u1ea5u v\u00e0 (&amp;) \u0111\u1ec3 n\u1ed1i\/k\u1ebft th\u00fac chu\u1ed7i, v\u00ed d\u1ee5 \u201c&lt;&gt;\u201d &amp; F1.<\/p>\n<p style=\"text-align: justify\">D\u1ea5u \u201cb\u1eb1ng\u201d (=) c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c b\u1ecf qua tr\u01b0\u1edbc m\u1ed9t tham chi\u1ebfu \u00f4, do \u0111\u00f3 c\u1ea3 hai c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y l\u00e0 mang t\u00ednh t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u00e0 ch\u00ednh x\u00e1c:<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c 1: <code class=\"excel-formula\">= SUMIF (A2: A8, \"=\" &amp; F1, C2: C8)<\/code><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c 2: <code class=\"excel-formula\">= SUMIF (A2: A8, F1, C2: C8)<\/code><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_SUMIF_voi_ki_tu_dai_dien\"><\/span>C\u00f4ng th\u1ee9c SUMIF v\u1edbi k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n m\u1ee5c \u0111\u00edch c\u1ee7a b\u1ea1n l\u00e0 vi\u1ec7c t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00e1c \u00f4 d\u1ef1a tr\u00ean ti\u00eau ch\u00ed \u201cv\u0103n b\u1ea3n\u201d v\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng b\u1eb1ng c\u00e1ch \u0111\u1ed1i chi\u1ebfu t\u1eebng ph\u1ea7n, th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n trong c\u00f4ng th\u1ee9c SUMIF c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">H\u00e3y xem x\u00e9t c\u00e1c k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n sau \u0111\u00e2y:<\/p>\n<ul style=\"text-align: justify\">\n<li>D\u1ea5u hoa th\u1ecb (*) \u2013 \u0111\u1ea1i di\u1ec7n cho nhi\u1ec1u k\u00ed t\u1ef1<\/li>\n<li>D\u1ea5u h\u1ecfi (?) \u2013 \u0111\u1ea1i di\u1ec7n cho m\u1ed9t k\u00ed t\u1ef1 duy nh\u1ea5t \u1edf m\u1ed9t v\u1ecb tr\u00ed c\u1ee5 th\u1ec3<\/li>\n<\/ul>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Cac_gia_tri_tinh_tong_dua_tren_doi_chieu_tung_phan\"><\/span>V\u00ed d\u1ee5 1. C\u00e1c gi\u00e1 tr\u1ecb t\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean \u0111\u1ed1i chi\u1ebfu t\u1eebng ph\u1ea7n:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n li\u00ean quan \u0111\u1ebfn t\u1ea5t c\u1ea3 c\u00e1c lo\u1ea1i chu\u1ed1i (bananas). Th\u00ec c\u00e1c c\u00f4ng th\u1ee9c SUMIF sau s\u1ebd ch\u1ea1y nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A8, \"bananas *\", C2: C8)<\/code>\u2013 ti\u00eau ch\u00ed bao g\u1ed3m c\u00e1c v\u0103n b\u1ea3n k\u1ebft th\u00fac v\u1edbi d\u1ea5u hoa th\u1ecb (*).<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A8, \"*\" &amp; F1 &amp; \"*\", C2: C8)<\/code>\u2013 c\u00e1c ti\u00eau ch\u00ed bao g\u1ed3m m\u1ed9t tham chi\u1ebfu \u00f4 k\u00e8m theo d\u1ea5u hoa th\u1ecb, vui l\u00f2ng l\u01b0u \u00fd v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng d\u1ea5u v\u00e0 (&amp;) tr\u01b0\u1edbc v\u00e0 sau m\u1ed9t tham chi\u1ebfu \u00f4 \u0111\u1ec3 n\u1ed1i v\u1edbi chu\u1ed7i.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-wildcard.png\" alt=\"Using wildcards to sum values based on a partial match\" title=\"excel-sumif-wildcard\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n t\u00ednh t\u1ed5ng nh\u1eefng \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac v\u1edbi m\u1ed9t v\u0103n b\u1ea3n nh\u1ea5t \u0111\u1ecbnh, th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n th\u00eam m\u1ed9t d\u1ea5u * tr\u01b0\u1edbc ho\u1eb7c sau v\u0103n b\u1ea3n:<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUMIF (A2: A8, \"bananas*\", C2: C8)<\/code><\/em><\/strong> \u2013 t\u1ed5ng gi\u00e1 tr\u1ecb trong C2: C8 n\u1ebfu m\u1ed9t \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t A b\u1eaft \u0111\u1ea7u b\u1eb1ng t\u1eeb \u201cbananas\u201d.<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUMIF (A2: A8, \"*bananas\", C2: C8<\/code><\/em><\/strong>) \u2013 t\u1ed5ng gi\u00e1 tr\u1ecb trong C2: C8 n\u1ebfu m\u1ed9t \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t A k\u1ebft th\u00fac b\u1eb1ng t\u1eeb \u201cbananas\u201d.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Tong_gia_tri_voi_so_ki_tu_nhat_dinh\"><\/span>V\u00ed d\u1ee5 2. T\u1ed5ng gi\u00e1 tr\u1ecb v\u1edbi s\u1ed1 k\u00ed t\u1ef1 nh\u1ea5t \u0111\u1ecbnh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng m\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb n\u1ebfu gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 ch\u00ednh x\u00e1c 6 ch\u1eef c\u00e1i, th\u00ec b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A8, \"??????\", C2: C8)<\/code><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_Tinh_tong_cac_o_co_gia_tri_tuong_ung_voi_gia_tri_van_ban\"><\/span>V\u00ed d\u1ee5 3. T\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n ch\u1ee9a c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u kh\u00e1c nhau v\u00e0 b\u1ea1n ch\u1ec9 mu\u1ed1n t\u1ed5ng c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, th\u00ec c\u00e1c c\u00f4ng th\u1ee9c SUMIF sau s\u1ebd c\u00f3 \u00edch cho b\u1ea1n:<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A8, \"? *\", C2: C8)<\/code> \u2013 c\u1ed9ng gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 C2: C8 n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t A ch\u1ee9a \u00edt nh\u1ea5t 1 k\u00ed t\u1ef1.<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A8, \"*\", C2: C8)<\/code> \u2013 bao g\u1ed3m c\u00e1c \u00f4 c\u00f3 v\u1ebb l\u00e0 r\u1ed7ng, ch\u1ee9a c\u00e1c chu\u1ed7i c\u00f3 \u0111\u1ed9 d\u00e0i b\u1eb1ng 0 (l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c), v\u00ed d\u1ee5: = \u201c\u201d.<\/p>\n<p style=\"text-align: justify\">C\u1ea3 hai c\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ec1u b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i l\u00e0 v\u0103n b\u1ea3n nh\u01b0 c\u00e1c l\u1ed7i, c\u00e1c ph\u00e9p to\u00e1n lu\u1eadn, c\u00e1c ch\u1eef s\u1ed1 v\u00e0 ng\u00e0y th\u00e1ng.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_4_Su_dung_hoac_nhu_nhung_ki_tu_binh_thuong\"><\/span>V\u00ed d\u1ee5 4. S\u1eed d\u1ee5ng * ho\u1eb7c ? nh\u01b0 nh\u1eefng k\u00ed t\u1ef1 b\u00ecnh th\u01b0\u1eddng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n * ho\u1eb7c ? \u0111\u01b0\u1ee3c coi nh\u01b0 l\u00e0 m\u1ed9t ch\u1eef ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n, th\u00ec h\u00e3y s\u1eed d\u1ee5ng d\u1ea5u ng\u00e3 tr\u01b0\u1edbc \u0111\u00f3 (~). V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c SUMIF sau s\u1ebd th\u00eam c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 C2: C8 n\u1ebfu m\u1ed9t \u00f4 trong c\u1ed9t A n\u1eb1m trong c\u00f9ng m\u1ed9t h\u00e0ng m\u00e0 ch\u1ee9a m\u1ed9t d\u1ea5u ch\u1ea5m h\u1ecfi:<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A8, \"~?\", C2: C8)<\/code><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-wildcard-tilde.png\" alt=\"A SUMIF formula adds values corresponding to the question mark in another column\" title=\"excel-sumif-wildcard-tilde\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tong_cac_so_lon_nhat_hoac_nho_nhat_trong_mot_dai\"><\/span>T\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn nh\u1ea5t ho\u1eb7c nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u1ea3i:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn nh\u1ea5t ho\u1eb7c nh\u1ecf nh\u1ea5t trong d\u1ea3i, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SUM c\u00f9ng v\u1edbi h\u00e0m <strong><em>LARGE ho\u1eb7c SMALL.<\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Them_mot_vai_so_lon_nhat_nho_nhat\"><\/span>V\u00ed d\u1ee5 1. Th\u00eam m\u1ed9t v\u00e0i s\u1ed1 l\u1edbn nh\u1ea5t \/ nh\u1ecf nh\u1ea5t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng ch\u1ec9 m\u1ed9t s\u1ed1 \u00edt, v\u00ed d\u1ee5 nh\u01b0 5 s\u1ed1, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 ch\u00fang tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUM (LARGE (B1: B10, {1,2,3,4,5}))<\/code><\/em><\/strong> \u2013 t\u1ed5ng 5 s\u1ed1 l\u1edbn nh\u1ea5t<\/p>\n<p>\u00a0<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUM (SMALL (B1: B10, {1,2,3,4,5}))<\/code><\/em><\/strong> \u2013 t\u1ed5ng 5 s\u1ed1 nh\u1ecf nh\u1ea5t<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sum-largest-smallest-numbers.png\" alt=\"Sum the largest and smallest numbers in a range\" title=\"sum-largest-smallest-numbers\"><\/p>\n<p style=\"text-align: justify\">Ch\u00fa th\u00edch. N\u1ebfu c\u00f3 2 ho\u1eb7c nhi\u1ec1u h\u01a1n s\u1ed1 \u0111\u01b0\u1ee3c bu\u1ed9c cho v\u1ecb tr\u00ed cu\u1ed1i c\u00f9ng, ch\u1ec9 c\u00f3 s\u1ed1 \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh. Nh\u01b0 b\u1ea1n th\u1ea5y, s\u1ed1 9 th\u1ee9 hai kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o trong v\u00ed d\u1ee5 tr\u00ean.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Them_vao_cac_gia_tri_lonnho\"><\/span>V\u00ed d\u1ee5 2. Th\u00eam v\u00e0o c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn\/nh\u1ecf<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam nhi\u1ec1u s\u1ed1, thay v\u00ec li\u1ec7t k\u00ea t\u1ea5t c\u1ea3 trong c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 t\u1ed5 ch\u1ee9c c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/bieu-do-dong-ham-index-row-scrollbar-control.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m ROW<\/a> v\u00e0 \u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m INDIRECT <\/a>trong c\u00f4ng th\u1ee9c SUM c\u1ee7a b\u1ea1n. Trong h\u00e0m INDIRECT, h\u00e3y s\u1eed d\u1ee5ng s\u1ed1 h\u00e0ng \u0111\u1ea1i di\u1ec7n cho s\u1ed1 gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n th\u00eam v\u00e0o. V\u00ed d\u1ee5, c\u00e1c c\u00f4ng th\u1ee9c sau \u0111\u00e2y t\u00ednh t\u1ed5ng 15 s\u1ed1 l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t, l\u1ea7n l\u01b0\u1ee3t l\u00e0:<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUM (LARGE (B1: B50, ROW (INDIRECT (\"1:15\"))))<\/code><\/em><\/strong><\/p>\n<p>\u00a0<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUM (SMALL (B1: B50, ROW (INDIRECT (\"1:15\"))))<\/code><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ec \u0111\u00e2y l\u00e0 c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng, n\u00ean b\u1ea1n h\u00e3y nh\u1edb nh\u1eadp ch\u00fang b\u1eb1ng c\u00e1ch nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sum-largest-smallest-numbers2.png\" alt=\"Array formulas to add many top \/ bottom numbers\" title=\"sum-largest-smallest-numbers2\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_Tinh_tong_mot_bien_so_trong_cac_gia_tri_lon_nhat_nho_nhat\"><\/span>V\u00ed d\u1ee5 3. T\u00ednh t\u1ed5ng m\u1ed9t bi\u1ebfn s\u1ed1 trong c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \/ nh\u1ecf nh\u1ea5t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n thay \u0111\u1ed5i c\u00f4ng th\u1ee9c m\u1ed7i khi b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng m\u1ed9t s\u1ed1 \u00f4 kh\u00e1c nhau, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t s\u1ed1 \u0111\u00f3 trong m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3 thay v\u00ec nh\u1eadp n\u00f3 v\u00e0o c\u00f4ng th\u1ee9c. V\u00e0 sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROW v\u00e0 INDIRECT nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf tr\u00ean v\u00e0 tham chi\u1ebfu m\u1ed9t \u00f4 ch\u1ee9a bi\u1ebfn, nh\u01b0 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 \u00f4 E1:<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUM (LARGE (B1: B50, ROW (INDIRECT (\"1:\" &amp; E1))))<\/code><\/em><\/strong> \u2013 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb h\u00e0ng \u0111\u1ea7u m\u00e0 c\u00f3 ch\u1ee9a 1 \u00f4 thay \u0111\u1ed5i<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUM (SMALL (B1: B50, ROW (INDIRECT (\"1:\" &amp; E1))))<\/code><\/em><\/strong> \u2013 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t m\u00e0 c\u00f3 ch\u1ee9a 1 \u00f4 thay \u0111\u1ed5i<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sum-top-bottom-values.png\" alt=\"Sum a variable number of largest \/ smallest values by referencing a cell\" title=\"sum-top-bottom-values\"><\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb r\u1eb1ng, \u0111\u00e2y l\u00e0 c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng, v\u00ec v\u1eady b\u1ea1n ph\u1ea3i nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh ch\u00fang.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tinh_tong_cac_o_tuong_ung_voi_cac_o_trong\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c \u00f4 tr\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu \u201ctr\u1ed1ng\u201d th\u00ec c\u00f3 ngh\u0129a l\u00e0 c\u00e1c \u00f4 \u0111\u00f3 ho\u00e0n to\u00e0n kh\u00f4ng c\u00f3 ch\u1ee9a g\u00ec \u2013 kh\u00f4ng c\u00f3 c\u00f4ng th\u1ee9c, kh\u00f4ng c\u00f3 chu\u1ed7i chi\u1ec1u d\u00e0i b\u1eb1ng 0 \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i b\u1edfi m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c, khi \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u201c=\u201d l\u00e0m ti\u00eau ch\u00ed, nh\u01b0 trong c\u00f4ng th\u1ee9c SUMIF sau:<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A10, \"=\", C2: C10)<\/code><\/p>\n<p>\u00a0<\/p>\n<p style=\"text-align: justify\">N\u1ebfu \u201ctr\u1ed1ng\u201d bao g\u1ed3m c\u00e1c chu\u1ed7i \u0111\u1ed9 d\u00e0i b\u1eb1ng kh\u00f4ng (v\u00ed d\u1ee5: \u00f4 c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 = \u201c\u201d), th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u201c\u201d l\u00e0m ti\u00eau ch\u00ed:<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A10, \"\", C2: C10)<\/code><\/p>\n<p>\u00a0<\/p>\n<p style=\"text-align: justify\">C\u1ea3 hai c\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ec1u \u0111\u00e1nh gi\u00e1 c\u00e1c \u00f4 trong c\u1ed9t A v\u00e0 n\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 \u00f4 tr\u1ed1ng n\u00e0o \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1eeb c\u1ed9t C s\u1ebd \u0111\u01b0\u1ee3c th\u00eam v\u00e0o.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-blank.png\" alt=\"Summing cells that correspond to blank cells\" title=\"excel-sumif-blank\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tinh_tong_cac_o_tuong_ung_voi_cac_o_khong_trong\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u1ea1o lo\u1ea1i c\u00f4ng th\u1ee9c \u201cn\u1ebfu \u00f4 kh\u00f4ng tr\u1ed1ng th\u00ec t\u00ednh t\u1ed5ng\u201d, h\u00e3y s\u1eed d\u1ee5ng \u201c&lt;&gt;\u201d l\u00e0m ti\u00eau ch\u00ed. Thao t\u00e1c n\u00e0y s\u1ebd c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a b\u1ea5t k\u1ef3 th\u1ee9 g\u00ec trong \u0111\u00f3, bao g\u1ed3m c\u1ea3 c\u00e1c chu\u1ed7i c\u00f3 \u0111\u1ed9 d\u00e0i b\u1eb1ng kh\u00f4ng.<\/p>\n<p>V\u00ed d\u1ee5: \u0111\u00e2y l\u00e0 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng cho t\u1ea5t c\u1ea3 c\u00e1c khu v\u1ef1c, t\u1ee9c l\u00e0 trong \u0111\u00f3 c\u1ed9t B kh\u00f4ng tr\u1ed1ng:<\/p>\n<p><code class=\"excel-formula\">=SUMIF(B2:B10, \u201c&lt;&gt;\u201d, C2:D10)<\/code><\/p>\n<figure class=\"wp-caption aligncenter\" style=\"width: 466px\"><img loading=\"lazy\" decoding=\"async\" class=\"\" title=\"V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m sumif 4\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-not-blank.png\" alt=\"SUM IF not blank\" width=\"466\" height=\"266\"><figcaption class=\"wp-caption-text\">V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m sumif 4<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_Ham_SUMIF_voi_ngay_thang\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m SUMIF v\u1edbi ng\u00e0y th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u00f3i chung, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng m\u1ed9t c\u00e1ch c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean ng\u00e0y c\u0169ng gi\u1ed1ng nh\u01b0 c\u00e1ch b\u1ea1n s\u1eed d\u1ee5ng v\u0103n b\u1ea3n v\u00e0 c\u00e1c ti\u00eau ch\u00ed s\u1ed1.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u00a0n\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng so v\u1edbi ng\u00e0y b\u1ea1n ch\u1ec9 \u0111\u1ecbnh, th\u00ec h\u00e3y s\u1eed d\u1ee5ng d\u1ea5u so s\u00e1nh m\u00e0 ch\u00fang t\u00f4i \u0111\u00e3 th\u1ea3o lu\u1eadn t\u1eeb nh\u1eefng b\u00e0i tr\u01b0\u1edbc. V\u00e0 d\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c h\u00e0m SUMIF:<\/p>\n<table style=\"height: 426px\" width=\"920\">\n<tbody>\n<tr>\n<td width=\"163\"><strong>Ti\u00eau ch\u00ed<\/strong><\/td>\n<td width=\"289\"><strong>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><\/td>\n<td width=\"171\"><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<\/tr>\n<tr>\n<td>T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u00f4 d\u1ef1a tr\u00ean 1 ng\u00e0y th\u00e1ng nh\u1ea5t \u0111\u1ecbnh<\/td>\n<td><strong>=SUMIF(B2:B9,\u201d10\/29\/2014\u2033,C2:C9)<\/strong><\/td>\n<td>T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 C2:C9 n\u1ebfu ng\u00e0y \u1edf \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B l\u00e0 ng\u00e0y 29\/10\/2014<\/td>\n<\/tr>\n<tr>\n<td>T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u00f4 n\u1ebfu ng\u00e0y \u1edf \u00f4 t\u01b0\u01a1ng \u1ee9ng l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng v\u1edbi ng\u00e0y \u0111\u00e3 cho<\/td>\n<td><strong>=SUMIF(B2:B9,\u201d&gt;=10\/29\/2014\u2033,C2:C9)<\/strong><\/td>\n<td>T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 C2:C9 n\u1ebfu ng\u00e0y \u1edf \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B l\u00e0 t\u1eeb ng\u00e0y 29\/10\/2014 tr\u1edf v\u1ec1 sau (v\u1ec1 hi\u1ec7n t\u1ea1i)<\/td>\n<\/tr>\n<tr>\n<td>T\u00ednh t\u1ed5ng c\u00e1c g\u00ed tr\u1ecb \u00f4 n\u1ebfu ng\u00e0y \u1edf \u00f4 t\u01b0\u01a1ng \u1ee9ng l\u1edbn h\u01a1n ng\u00e0y \u1edf 1 \u00f4 kh\u00e1c.<\/td>\n<td><strong>=SUMIF(B2:B9,\u201d&gt;\u201d&amp;F1,C2:C9)<\/strong><\/td>\n<td>T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 C2:C9 n\u1ebfu ng\u00e0y \u1edf \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B l\u00e0 sau ng\u00e0y trong \u00f4 F1.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n th\u1eddi, th\u00ec b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m SUMIF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m TODAY (), nh\u01b0 sau:<\/p>\n<table style=\"height: 273px\" width=\"936\">\n<tbody>\n<tr>\n<td width=\"377\"><strong>Ti\u00eau ch\u00ed<\/strong><\/td>\n<td width=\"365\"><strong>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"377\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n th\u1eddi<\/td>\n<td width=\"365\"><strong>=SUMIF(B2:B9, TODAY(), C2:C9)<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"377\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u00f4 m\u00e0 n\u1eb1m trong qu\u00e1 kh\u1ee9, c\u00f3 ngh\u0129a l\u00e0 tr\u01b0\u1edbc ng\u00e0y hi\u1ec7n th\u1eddi.<\/td>\n<td width=\"365\"><strong>=SUMIF(B2:B9, \u201c&lt;\u201c&amp;TODAY(), C2:C9)<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"377\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u00f4 m\u00e0 n\u1eb1m trong t\u01b0\u01a1ng lai, c\u00f3 ngh\u0129a l\u00e0 sau ng\u00e0y hi\u1ec7n th\u1eddi.<\/td>\n<td width=\"365\"><strong>=SUMIF(B2:B9, \u201c&gt;\u201d&amp;TODAY(), C2:C9)<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"377\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u00f4 n\u1ebfu c\u00e1c ng\u00e0y t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec1u \u0111\u01b0\u1ee3c x\u1ea3y ra trong 1 tu\u1ea7n (c\u00f3 ngh\u0129a l\u00e0 ng\u00e0y hi\u1ec7n th\u1eddi + 7 ng\u00e0y n\u1eefa)<\/td>\n<td width=\"365\"><strong>=SUMIF(B2:B9, \u201c=\u201d&amp;TODAY()+7, C2:C9)<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y minh ho\u1ea1 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c cu\u1ed1i c\u00f9ng \u0111\u1ec3 t\u00ecm t\u1ed5ng s\u1ed1 ti\u1ec1n c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111i trong m\u1ed9t tu\u1ea7n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-date.png\" alt=\"Sum values corresponding to the date that occurs in a week\" title=\"excel-sumif-date\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tinh_tong_cac_gia_tri_ung_voi_trong_mot_quang_thoi_gian_nhat_dinh\"><\/span>C\u00e1ch t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u1ee9ng v\u1edbi trong m\u1ed9t qu\u00e3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e2u h\u1ecfi sau \u0111\u00e2y \u0111\u01b0\u1ee3c h\u1ecfi th\u01b0\u1eddng xuy\u00ean tr\u00ean c\u00e1c di\u1ec5n \u0111\u00e0n v\u00e0 blog c\u1ee7a Excel \u2013 \u201cL\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u1ee9ng v\u1edbi th\u1eddi gian n\u1eb1m gi\u1eefa hai ng\u00e0y?\u201d<\/p>\n<p style=\"text-align: justify\">C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 s\u1eed d\u1ee5ng m\u1ed9t s\u1ef1 k\u1ebft h\u1ee3p, ho\u1eb7c ch\u00ednh x\u00e1c h\u01a1n, l\u00e0 s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa 2 c\u00f4ng th\u1ee9c SUMIF. Trong Excel 2007 tr\u1edf v\u1ec1 b\u00e2y gi\u1edd, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS cho ph\u00e9p nhi\u1ec1u ti\u00eau ch\u00ed, th\u1eadm ch\u00ed l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1ed1t h\u01a1n. Ch\u00fang t\u00f4i s\u1ebd \u0111\u1ec1 c\u1eadp t\u1edbi v\u1ebf sau trong ch\u1ee7 \u0111\u1ec1 c\u1ee7a b\u00e0i vi\u1ebft ti\u1ebfp theo, c\u00f2n d\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0 v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c SUMIF:<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (B2: B9, \"&gt; = 10\/1\/2014\", C2: C9) - SUMIF (B2: B9, \"&gt; = 11\/1\/2014\", C2: C9)<\/code><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 C2: C9 n\u1ebfu ng\u00e0y trong c\u1ed9t B n\u1eb1m gi\u1eefa ng\u00e0y 1\/10\/2014 v\u00e0 ng\u00e0y 31\/10\/2014, bao g\u1ed3m.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-date-range.png\" alt=\"SUMIF formula to add values in a given date range\" title=\"sumif-date-range\"><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 c\u00f3 v\u1ebb h\u01a1i kh\u00f3 kh\u0103n n\u1ebfu b\u1ea1n ch\u1ec9 l\u01b0\u1edbt qua, nh\u01b0ng khi n\u1ebfu \u0111i s\u00e2u v\u00e0o n\u00f3, th\u00ec b\u1ea1n s\u1ebd th\u1ea5y n\u00f3 r\u1ea5t \u0111\u01a1n gi\u1ea3n. H\u00e0m SUMIF \u0111\u1ea7u ti\u00ean \u0111\u00e3 th\u00eam t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong C2: C9, n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y b\u1eaft \u0111\u1ea7u (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 ng\u00e0y 1 th\u00e1ng 10). Ti\u1ebfp \u0111\u00f3, b\u1ea1n ch\u1ec9 c\u1ea7n ph\u1ea3i lo\u1ea1i \u0111i b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o x\u1ea3y ra v\u00e0o sau ng\u00e0y k\u1ebft th\u00fac (Oct-10 hay ng\u00e0y 31\/10) \u2013 l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi h\u00e0m SUMIF th\u1ee9 hai.<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Z73YOrndkEQ?t=5s\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tinh_tong_cac_gia_tri_trong_mot_vai_cot\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t v\u00e0i c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3u v\u1ea5n \u0111\u1ec1 h\u01a1n, h\u00e3y xem x\u00e9t v\u00ed d\u1ee5 sau \u0111\u00e2y: Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00f3m t\u1eaft doanh thu h\u00e0ng th\u00e1ng v\u00e0 n\u00f3 \u0111\u01b0\u1ee3c thu th\u1eadp t\u1eeb m\u1ed9t s\u1ed1 b\u00e1o c\u00e1o cho t\u1eebng khu v\u1ef1c, trong \u0111\u00f3 c\u00f3 m\u1ed9t v\u00e0i h\u1ed3 s\u01a1 cho c\u00f9ng m\u1ed9t s\u1ea3n ph\u1ea9m \u1edf tr\u00ean:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-source-data.png\" alt=\"Values in several columns need to be conditionally summed.\" title=\"sumif-source-data\"><\/p>\n<p style=\"text-align: justify\">V\u00ec v\u1eady, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u1ea1n t\u00ecm th\u1ea5y t\u1ed5ng s\u1ed1 apples (t\u00e1o) \u0111\u01b0\u1ee3c b\u00e1n \u1edf t\u1ea5t c\u1ea3 c\u00e1c ti\u1ec3u bang trong ba th\u00e1ng qua?<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, k\u00edch th\u01b0\u1edbc c\u1ee7a sum_range \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi k\u00edch th\u01b0\u1edbc c\u1ee7a tham s\u1ed1 range. \u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao b\u1ea1n kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 = SUMIF (A2: A9, \u201capples\u201d, C2: E9) b\u1edfi v\u00ec n\u00f3 s\u1ebd th\u00eam c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u201cApples\u201d m\u00e0 ch\u1ec9 \u1edf trong c\u1ed9t C. V\u00e0 \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 nh\u1eefng g\u00ec ch\u00fang ta \u0111ang t\u00ecm ki\u1ebfm.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p h\u1ee3p l\u00fd v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t cho th\u1ea5y ch\u00ednh n\u00f3 l\u00e0 t\u1ea1o ra m\u1ed9t c\u1ed9t \u0111\u1ec3 tr\u1ee3 gi\u00fap t\u00ednh t\u1eebng t\u1ed5ng s\u1ed1 cho m\u1ed7i h\u00e0ng v\u00e0 sau \u0111\u00f3 c\u1ed9t n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c tham chi\u1ebfu trong ti\u00eau ch\u00ed sum_range.<\/p>\n<p style=\"text-align: justify\">\u0110i tr\u01b0\u1edbc v\u00e0 \u0111\u1eb7t c\u00f4ng th\u1ee9c SUM \u0111\u01a1n gi\u1ea3n trong \u00f4 F2, sau \u0111\u00f3 \u0111i\u1ec1n v\u00e0o c\u1ed9t F: = SUM (C2: E2)<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c SUMIF \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A9, \"apples\", F2: F9)<\/code><\/p>\n<p style=\"text-align: justify\">ho\u1eb7c l\u00e0<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUMIF (A2: A9, H1, F2: F9)<\/code><\/p>\n<p style=\"text-align: justify\">Trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, sum_range c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc v\u1edbi d\u1ea3i, t\u1ee9c l\u00e0 1 c\u1ed9t v\u00e0 8 h\u00e0ng, v\u00e0 do \u0111\u00f3 k\u1ebft qu\u1ea3 m\u00e0 n\u00f3 tr\u1ea3 l\u1ea1i s\u1ebd ch\u00ednh x\u00e1c:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-several-columns.png\" alt=\"Solution to sum values in several columns\" title=\"sumif-several-columns\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m m\u00e0 kh\u00f4ng c\u00f3 m\u1ed9t c\u1ed9t tr\u1ee3 gi\u00fap, sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c SUMIF ri\u00eang cho m\u1ed7i c\u1ed9t b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng, v\u00e0 sau \u0111\u00f3 th\u00eam c\u00e1c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 v\u1edbi h\u00e0m SUM:<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">= SUM (SUMIF (A2: A9, I1, C2: C9), SUMIF (A2: A9, I1, D2: D9), SUMIF (A2: A9, I1, E2: E9))<\/code><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c l\u00e0 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng ph\u1ee9c t\u1ea1p h\u01a1n (nh\u01b0ng c\u0169ng \u0111\u1eebng qu\u00ean nh\u1ea5n Ctrl + Shift + Enter):<\/p>\n<p style=\"text-align: justify\"><code class=\"excel-formula\">{= SUM ((C2: C9 + D2: D9 + E2: E9) * (- (A2: A9 = I1)))}}<\/code><\/p>\n<p style=\"text-align: justify\">C\u1ea3 hai c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd \u0111\u01b0a ra k\u1ebft qu\u1ea3 l\u00e0 2070 trong tr\u01b0\u1eddng h\u1ee3p tr\u00ean.<\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nhung_cau_hoi_thuong_gap_hoac_%E2%80%9CTai_sao_cong_thuc_SUMIF_cua_toi_khong_hoat_dong%E2%80%9D\"><\/span>Nh\u1eefng c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p ho\u1eb7c \u201cT\u1ea1i sao c\u00f4ng th\u1ee9c SUMIF c\u1ee7a t\u00f4i kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng?\u201d<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">C\u00f3 th\u1ec3 c\u00f3 v\u00e0i l\u00fd do khi\u1ebfn H\u00e0m SUMIF kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng trong t\u00ecnh hu\u1ed1ng c\u1ee7a b\u1ea1n. \u0110\u00f4i khi c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng tr\u1ea3 l\u1ea1i nh\u1eefng g\u00ec b\u1ea1n mong \u0111\u1ee3i ch\u1ec9 v\u00ec ki\u1ec3u d\u1eef li\u1ec7u trong m\u1ed9t \u00f4 ho\u1eb7c trong m\u1ed9t s\u1ed1 \u0111\u1ed1i s\u1ed1 kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi h\u00e0m SUMIF. Do \u0111\u00f3, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t danh s\u00e1ch nh\u1eefng \u0111i\u1ec1u c\u1ea7n ki\u1ec3m tra:<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Cac_tham_so_cua_range_va_sum_range_phai_la_cac_dai_chu_khong_phai_mang\"><\/span>1. C\u00e1c tham s\u1ed1 c\u1ee7a range v\u00e0 sum_range ph\u1ea3i l\u00e0 c\u00e1c d\u1ea3i, ch\u1ee9 kh\u00f4ng ph\u1ea3i m\u1ea3ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e1c tham s\u1ed1 \u0111\u1ea7u ti\u00ean (range) v\u00e0 th\u1ee9 ba (sum_range) trong c\u00f4ng th\u1ee9c SUMIF c\u1ee7a b\u1ea1n ph\u1ea3i lu\u00f4n l\u00e0 m\u1ed9t tham chi\u1ebfu d\u1ea3i, nh\u01b0 A1: A10. N\u1ebfu b\u1ea1n b\u1ea5t ch\u1ea5p m\u00e0 b\u1ecf qua \u0111i\u1ec1u n\u00e0y, v\u00ed d\u1ee5 l\u00e0 tr\u01b0\u1eddng h\u1ee3p tham chi\u1ebfu m\u1ed9t m\u1ea3ng nh\u01b0 {1,2,3}, th\u00ec Excel v\u1edbi tr\u1ea3 l\u1ea1i v\u1edbi m\u1ed9t th\u00f4ng b\u00e1o l\u1ed7i.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u0111\u00fang: <code class=\"excel-formula\"><strong><em>= SUMIF (A1: A3, \"flower\", C1: C3)<\/em><\/strong><\/code><\/p>\n<p>\u00a0<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c sai: <code class=\"excel-formula\"><strong><em>= SUMIF ({1,2,3}, \"flower\", C1: C3)<\/em><\/strong><\/code><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_Lam_the_nao_de_tinh_tong_gia_tri_tu_cac_trang_tinh_hoac_bang_tinh_khac\"><\/span>2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb t\u1eeb c\u00e1c trang t\u00ednh ho\u1eb7c b\u1ea3ng t\u00ednh kh\u00e1c:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u1ee7ng gi\u1ed1ng nh\u01b0 h\u1ea7u h\u1ebft c\u00e1c h\u00e0m Excel kh\u00e1c, SUMIF c\u00f3 th\u1ec3 tham chi\u1ebfu \u0111\u1ebfn c\u00e1c trang t\u00ednh v\u00e0 b\u1ea3ng t\u00ednh kh\u00e1c, mi\u1ec5n l\u00e0 ch\u00fang v\u1eabn \u0111ang m\u1edf.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c sau \u0111\u00e2y s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 F2: F9 trong Sheet 1 (trang t\u00ednh 1) c\u1ee7a Book 1 (b\u1ea3ng t\u00ednh 1) n\u1ebfu c\u00f3 m\u1ed9t \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t A v\u00e0 c\u00f3 trang t\u00ednh \u0111\u00f3 c\u0169ng c\u00f3 ch\u1ee9a \u201capples\u201d:<\/p>\n<p style=\"text-align: justify\"><strong><em><code class=\"excel-formula\">= SUMIF ([Book1.xlsx] Sheet1! $A$2:$A$9, \"apples\", [Book1.xlsx] Sheet1! $F$2:$F$9)<\/code><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, c\u00f4ng th\u1ee9c n\u00e0y s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng ngay khi Book 1 b\u1ecb \u0111\u00f3ng l\u1ea1i. \u0110i\u1ec1u n\u00e0y x\u1ea3y ra v\u00ec c\u00e1c d\u1ea3i \u0111\u01b0\u1ee3c tham chi\u1ebfu b\u1edfi c\u00e1c c\u00f4ng th\u1ee9c SUMIF trong b\u1ea3ng t\u00ednh \u0111\u00e3 \u0111\u00f3ng, v\u1eady n\u00ean n\u00f3 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c m\u1ea3ng. M\u1eb7t kh\u00e1c, c\u0169ng do kh\u00f4ng c\u00f3 m\u1ea3ng n\u00e0o \u0111\u01b0\u1ee3c cho ph\u00e9p trong range v\u00e0 \u0111\u1ed1i s\u1ed1 sum_range, n\u00ean sau \u0111\u00f3, c\u00f4ng th\u1ee9c SUMIF s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t th\u00f4ng b\u00e1o l\u1ed7i <strong><em>#VALUE!.<\/em><\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_Hay_chac_chan_range_va_sum_range_co_cung_kich_co\"><\/span>3. H\u00e3y ch\u1eafc ch\u1eafn <strong><em>range v\u00e0 sum_range<\/em><\/strong> c\u00f3 c\u00f9ng k\u00edch c\u1ee1:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 l\u01b0u \u00fd \u1edf ph\u1ea7n \u0111\u1ea7u c\u1ee7a h\u01b0\u1edbng d\u1eabn n\u00e0y, trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Microsoft Excel, c\u00e1c tham s\u1ed1 range v\u00e0 sum_range kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i b\u1eb1ng nhau. T\u1eeb phi\u00ean b\u1ea3n Excel 2000 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, range v\u00e0 sum_range c\u00f3 k\u00edch th\u01b0\u1edbc kh\u00f4ng \u0111\u1ed3ng \u0111\u1ec1u c\u00f3 th\u1ec3 g\u00e2y ra v\u1ea5n \u0111\u1ec1. Tuy nhi\u00ean, ngay c\u1ea3 trong c\u00e1c phi\u00ean b\u1ea3n m\u1edbi nh\u1ea5t c\u1ee7a Excel 2010 v\u00e0 2013, c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p <strong><em>SUMIF<\/em><\/strong> m\u00e0 \u1edf \u0111\u00f3, n\u1ebfu <strong><em>sum_range <\/em><\/strong>c\u00f3 \u00edt h\u00e0ng v\u00e0\/ho\u1eb7c c\u1ed9t h\u01a1n <strong><em>range<\/em><\/strong>, th\u00ec s\u1ebd kh\u00f4ng h\u1ee3p l\u1ec7. \u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao n\u00f3 \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t minh h\u1ecda t\u1ed1t \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng ch\u00fa \u00fd r\u1eb1ng ph\u1ea3i lu\u00f4n lu\u00f4n gi\u1eef \u0111\u1ed1i s\u1ed1 <strong><em>range v\u00e0 sum_range <\/em><\/strong>c\u00f9ng k\u00edch th\u01b0\u1edbc v\u00e0 h\u00ecnh d\u1ea1ng.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"4_Lam_the_nao_de_cong_thuc_SUMIF_cua_ban_hoat_dong_nhanh_hon\"><\/span>4. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f4ng th\u1ee9c SUMIF c\u1ee7a b\u1ea1n ho\u1ea1t \u0111\u1ed9ng nhanh h\u01a1n:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e3 \u0111i\u1ec1n v\u00e0o b\u1ea3ng t\u00ednh v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p SUMIF l\u00e0m ch\u1eadm Excel, h\u00e3y xem th\u1eed b\u00e0i vi\u1ebft n\u00e0y v\u00e0 t\u00ecm hi\u1ec3u L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00fang ho\u1ea1t \u0111\u1ed9ng nhanh h\u01a1n. B\u00e0i vi\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c vi\u1ebft c\u00e1ch \u0111\u00e2y kh\u00e1 l\u00e2u, v\u00ec v\u1eady \u0111\u1eebng ng\u1ea1c nhi\u00ean b\u1edfi th\u1eddi gian t\u00ednh to\u00e1n. C\u00e1c v\u00ed d\u1ee5 v\u1ec1 Excel \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong h\u01b0\u1edbng d\u1eabn n\u00e0y ch\u1ec9 li\u00ean quan \u0111\u1ebfn m\u1ed9t s\u1ed1 c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m n\u00e0y. Trong b\u00e0i vi\u1ebft ti\u1ebfp theo, ch\u00fang t\u00f4i s\u1ebd \u0111\u01b0a ra c\u00e1c c\u00f4ng th\u1ee9c ti\u00ean ti\u1ebfn nh\u1eb1m khai th\u00e1c s\u1ee9c m\u1ea1nh th\u1ef1c c\u1ee7a SUMIF v\u00e0 SUMIFS v\u00e0 cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng theo nhi\u1ec1u ti\u00eau ch\u00ed.<\/p>\n<p style=\"text-align: justify\">\u2013 \u2013 \u2013 \u2013 \u2013<\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc.<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-45.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1546,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1545","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1545","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=1545"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1545\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1546"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}