{"id":1156,"date":"2024-12-02T04:20:18","date_gmt":"2024-12-02T04:20:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-sumproduct-trong-excel-va-mot-so-vi-vu-cong-thuc\/"},"modified":"2024-12-02T04:20:18","modified_gmt":"2024-12-02T04:20:18","slug":"ham-sumproduct-trong-excel-va-mot-so-vi-vu-cong-thuc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-sumproduct-trong-excel-va-mot-so-vi-vu-cong-thuc\/","title":{"rendered":"Ha\u0300m SUMPRODUCT trong Excel va\u0300 m\u00f4\u0323t s\u00f4\u0301 vi\u0301 vu\u0323 c\u00f4ng th\u01b0\u0301c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>B\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1ea3i th\u00edch c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n v\u00e0 n\u00e2ng cao c\u1ee7a <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">h\u00e0m SUMPRODUCT<\/a> trong Excel<\/strong>. B\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t v\u00e0i v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c d\u00f9ng \u0111\u1ec3 so s\u00e1nh m\u1ea3ng, t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u00e0 \u0111\u1ebfm s\u1ed1 \u00f4 c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, t\u00ednh trung b\u00ecnh c\u1ed9ng c\u00f3 tr\u1ecdng l\u01b0\u1ee3ng v\u00e0 h\u01a1n th\u1ebf n\u1eefa.<\/em><\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n nghe c\u00e1i t\u00ean h\u00e0m SUMPRODUCT l\u1ea7n \u0111\u1ea7u ti\u00ean, n\u00f3 c\u00f3 v\u1ebb l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c v\u00f4 \u00edch \u2013 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng th\u00f4ng th\u01b0\u1eddng c\u1ee7a c\u00e1c t\u00edch s\u1ed1. Nh\u01b0ng \u0111\u1ecbnh ngh\u0129a n\u00e0y kh\u00f4ng cho th\u1ea5y th\u1eadm ch\u00ed l\u00e0 ch\u1ec9 m\u1ed9t ph\u1ea7n nh\u1ecf t\u00ednh n\u0103ng c\u1ee7a h\u00e0m SUMPRODUCT.<\/p>\n<p style=\"text-align: justify\">Th\u1ef1c ra, h\u00e0m SUMPRODUCT trong Excel l\u00e0 h\u00e0m c\u00f3 r\u1ea5t nhi\u1ec1u t\u00ednh n\u0103ng. Do kh\u1ea3 n\u0103ng \u0111\u1eb7c bi\u1ec7t c\u00f3 th\u1ec3 x\u1eed l\u00fd m\u1ea3ng m\u1ed9t c\u00e1ch tinh t\u1ebf v\u00e0 th\u00f4ng minh, n\u00ean h\u00e0m SUMPRODUCT trong Excel r\u1ea5t h\u1eefu \u00edch, n\u1ebfu kh\u00f4ng b\u1eaft bu\u1ed9c, khi n\u00f3i \u0111\u1ebfn vi\u1ec7c so s\u00e1nh d\u1eef li\u1ec7u \u1edf hai hay nhi\u1ec1u d\u1ea3i \u00f4 v\u00e0 vi\u1ec7c t\u00ednh to\u00e1n d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Nh\u1eefng v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd cho b\u1ea1n th\u1ea5y to\u00e0n b\u1ed9 kh\u1ea3 n\u0103ng c\u1ee7a h\u00e0m SUMPRODUCT v\u00e0 s\u1ef1 h\u1eefu \u00edch c\u1ee7a n\u00f3 s\u1ebd s\u1edbm tr\u1edf n\u00ean r\u00f5 r\u00e0ng th\u00f4i.<\/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-674d358151e04\" 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\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#HAM_SUMPRODUCT_TRONG_EXCEL_%E2%80%93_CU_PHAP_VA_CONG_DUNG\" title=\"H\u00c0M SUMPRODUCT TRONG EXCEL \u2013 C\u00da PH\u00c1P V\u00c0 C\u00d4NG D\u1ee4NG:\">H\u00c0M SUMPRODUCT TRONG EXCEL \u2013 C\u00da PH\u00c1P V\u00c0 C\u00d4NG D\u1ee4NG:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#CACH_DUNG_CO_BAN_CUA_HAM_SUMPRODUCT_TRONG_EXCEL\" title=\"C\u00c1CH D\u00d9NG C\u01a0 B\u1ea2N C\u1ee6A H\u00c0M SUMPRODUCT TRONG EXCEL:\">C\u00c1CH D\u00d9NG C\u01a0 B\u1ea2N C\u1ee6A H\u00c0M SUMPRODUCT TRONG EXCEL:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#CACH_SU_DUNG_HAM_SUMPRODUCT_TRONG_EXCEL_%E2%80%93_VI_DU_CONG_THUC\" title=\"C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M SUMPRODUCT TRONG EXCEL \u2013 V\u00cd D\u1ee4 C\u00d4NG TH\u1ee8C:\">C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M SUMPRODUCT TRONG EXCEL \u2013 V\u00cd D\u1ee4 C\u00d4NG TH\u1ee8C:<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#HAM_SUMPRODUCT_CO_NHIEU_DIEU_KIEN\" title=\"H\u00c0M SUMPRODUCT C\u00d3 NHI\u1ec0U \u0110I\u1ec0U KI\u1ec6N\">H\u00c0M SUMPRODUCT C\u00d3 NHI\u1ec0U \u0110I\u1ec0U KI\u1ec6N<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#CACH_CONG_THUC_SUMPRODUCT_CO_MOT_DIEU_KIEN_HOAT_DONG\" title=\"C\u00c1CH C\u00d4NG TH\u1ee8C SUMPRODUCT C\u00d3 M\u1ed8T \u0110I\u1ec0U KI\u1ec6N HO\u1ea0T \u0110\u1ed8NG:\">C\u00c1CH C\u00d4NG TH\u1ee8C SUMPRODUCT C\u00d3 M\u1ed8T \u0110I\u1ec0U KI\u1ec6N HO\u1ea0T \u0110\u1ed8NG:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#CACH_CONG_THUC_SUMPRODUCT_CO_NHIEU_DIEU_KIEN_HOAT_DONG\" title=\"C\u00c1CH C\u00d4NG TH\u1ee8C SUMPRODUCT C\u00d3 NHI\u1ec0U \u0110I\u1ec0U KI\u1ec6N HO\u1ea0T \u0110\u1ed8NG:\">C\u00c1CH C\u00d4NG TH\u1ee8C SUMPRODUCT C\u00d3 NHI\u1ec0U \u0110I\u1ec0U KI\u1ec6N HO\u1ea0T \u0110\u1ed8NG:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#DEMTINH_TONGTINH_TRUNG_BINH_CO_DIEU_KIEN_CAC_O_VOI_NHIEU_TIEU_CHUAN\" title=\"\u0110\u1ebeM\/T\u00cdNH T\u1ed4NG\/T\u00cdNH TRUNG B\u00ccNH C\u00d3 \u0110I\u1ec0U KI\u1ec6N C\u00c1C \u00d4 V\u1edaI NHI\u1ec0U TI\u00caU CHU\u1ea8N\">\u0110\u1ebeM\/T\u00cdNH T\u1ed4NG\/T\u00cdNH TRUNG B\u00ccNH C\u00d3 \u0110I\u1ec0U KI\u1ec6N C\u00c1C \u00d4 V\u1edaI NHI\u1ec0U TI\u00caU CHU\u1ea8N<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#CONG_THUC_SUMPRODUCT_VOI_HAM_LOGIC_AND\" title=\"C\u00d4NG TH\u1ee8C SUMPRODUCT V\u1edaI H\u00c0M L\u00d4GIC AND:\">C\u00d4NG TH\u1ee8C SUMPRODUCT V\u1edaI H\u00c0M L\u00d4GIC AND:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#CONG_THUC_SUMPRODUCT_DUNG_CHO_VIEC_TINH_TONG_CO_DIEU_KIEN_HOAT_DONG_NHU_THE_NAO\" title=\"C\u00d4NG TH\u1ee8C SUMPRODUCT D\u00d9NG CHO VI\u1ec6C T\u00cdNH T\u1ed4NG C\u00d3 \u0110I\u1ec0U KI\u1ec6N HO\u1ea0T \u0110\u1ed8NG NH\u01af TH\u1ebe N\u00c0O\">C\u00d4NG TH\u1ee8C SUMPRODUCT D\u00d9NG CHO VI\u1ec6C T\u00cdNH T\u1ed4NG C\u00d3 \u0110I\u1ec0U KI\u1ec6N HO\u1ea0T \u0110\u1ed8NG NH\u01af TH\u1ebe N\u00c0O<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#CONG_THUC_SUMPRODUCT_DUNG_DE_TINH_TRUNG_BINH_CO_TRONG_LUONG\" title=\"C\u00d4NG TH\u1ee8C SUMPRODUCT D\u00d9NG \u0110\u1ec2 T\u00cdNH TRUNG B\u00ccNH C\u00d3 TR\u1eccNG L\u01af\u1ee2NG\">C\u00d4NG TH\u1ee8C SUMPRODUCT D\u00d9NG \u0110\u1ec2 T\u00cdNH TRUNG B\u00ccNH C\u00d3 TR\u1eccNG L\u01af\u1ee2NG<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#HAM_SUMPRODUCT_DUOC_DUNG_LAM_HAM_THAY_THE_CHO_CONG_THUC_MANG\" title=\"H\u00c0M SUMPRODUCT \u0110\u01af\u1ee2C D\u00d9NG L\u00c0M H\u00c0M THAY TH\u1ebe CHO C\u00d4NG TH\u1ee8C M\u1ea2NG\">H\u00c0M SUMPRODUCT \u0110\u01af\u1ee2C D\u00d9NG L\u00c0M H\u00c0M THAY TH\u1ebe CHO C\u00d4NG TH\u1ee8C M\u1ea2NG<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#MOD_va_SUMPRODUCT_trong_Excel_dem_o_chua_so_le\" title=\"MOD v\u00e0 SUMPRODUCT trong Excel \u0111\u1ebfm \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb\">MOD v\u00e0 SUMPRODUCT trong Excel \u0111\u1ebfm \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb<\/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\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#Cac_ung_dung_thuong_gap_va_cac_ham_thuong_dung_voi_SUMPRODUCT\" title=\"C\u00e1c \u1ee9ng d\u1ee5ng th\u01b0\u1eddng g\u1eb7p, v\u00e0 c\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng v\u1edbi SUMPRODUCT.\">C\u00e1c \u1ee9ng d\u1ee5ng th\u01b0\u1eddng g\u1eb7p, v\u00e0 c\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng v\u1edbi SUMPRODUCT.<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\">\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#Cac_ham_kiem_tra_logic_ISNUMBERISERROR_SEARCH\" title=\"C\u00e1c h\u00e0m ki\u1ec3m tra logic: ISNUMBER\/ISERROR + SEARCH\">C\u00e1c h\u00e0m ki\u1ec3m tra logic: ISNUMBER\/ISERROR + SEARCH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#Tinh_tong_tat_ca_cac_sheet_voi_SUMIFS\" title=\"T\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c sheet v\u1edbi SUMIFS\">T\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c sheet v\u1edbi SUMIFS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#Tinh_so_gio_di_muon_ve_som_gio_lam_cua_nhan_vien_voi_ham_SUMPRODUCT\" title=\"T\u00ednh s\u1ed1 gi\u1edd \u0111i mu\u1ed9n, v\u1ec1 s\u1edbm, gi\u1edd l\u00e0m c\u1ee7a nh\u00e2n vi\u00ean v\u1edbi h\u00e0m SUMPRODUCT.\">T\u00ednh s\u1ed1 gi\u1edd \u0111i mu\u1ed9n, v\u1ec1 s\u1edbm, gi\u1edd l\u00e0m c\u1ee7a nh\u00e2n vi\u00ean v\u1edbi h\u00e0m SUMPRODUCT.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html#Ung_dung_SUMPRODUCT_trong_viec_cham_cong_tinh_cong_cho_nhan_vien\" title=\"\u1ee8ng d\u1ee5ng SUMPRODUCT trong vi\u1ec7c ch\u1ea5m c\u00f4ng, t\u00ednh c\u00f4ng cho nh\u00e2n vi\u00ean.\">\u1ee8ng d\u1ee5ng SUMPRODUCT trong vi\u1ec7c ch\u1ea5m c\u00f4ng, t\u00ednh c\u00f4ng cho nh\u00e2n vi\u00ean.<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_SUMPRODUCT_TRONG_EXCEL_%E2%80%93_CU_PHAP_VA_CONG_DUNG\"><\/span><strong>H\u00c0M SUMPRODUCT TRONG EXCEL \u2013 C\u00da PH\u00c1P V\u00c0 C\u00d4NG D\u1ee4NG:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt, <strong>h\u00e0m SUMPRODUCT trong Excel<\/strong> nh\u00e2n c\u00e1c con s\u1ed1 trong m\u1ea3ng x\u00e1c \u0111\u1ecbnh, r\u1ed3i tr\u1ea3 v\u1ec1 t\u1ed5ng c\u1ee7a c\u00e1c t\u00edch s\u1ed1 \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00fa ph\u00e1p<\/strong> c\u1ee7a <strong>h\u00e0m SUMPRODUCT<\/strong> r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/p>\n<p style=\"text-align: justify\">SUMPRODUCT(array1, [array2], [array3], \u2026)<\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3, m\u1ea3ng 1, m\u1ea3ng 2, \u2026 l\u00e0 c\u00e1c d\u1ea3i \u00f4 li\u00ean t\u1ee5c hay l\u00e0 c\u00e1c m\u1ea3ng c\u00f3 ch\u1ee9a th\u00e0nh ph\u1ea7n b\u1ea1n mu\u1ed1n nh\u00e2n, r\u1ed3i c\u1ed9ng l\u1ea1i.<\/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-82.gif\" title=\"ex101_92019-nho-82\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">S\u1ed1 m\u1ea3ng t\u1ed1i thi\u1ec3u l\u00e0 1. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e0m SUMPRODUCT trong Excel ch\u1ec9 \u0111\u01a1n gi\u1ea3n t\u00ednh t\u1ed5ng c\u00e1c th\u00e0nh ph\u1ea7n m\u1ea3ng r\u1ed3i tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1.<\/p>\n<p style=\"text-align: justify\">S\u1ed1 m\u1ea3ng t\u1ed1i \u0111a l\u00e0 255 trong Excel 2016, Excel 2013, Excel 2010, v\u00e0 Excel 2007, v\u00e0 30 trong c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc c\u1ee7a Excel.<\/p>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 h\u00e0m SUMPRODUCT x\u1eed l\u00fd m\u1ea3ng, nh\u01b0ng n\u00f3 kh\u00f4ng y\u00eau c\u1ea7u ph\u00edm t\u1eaft m\u1ea3ng (Ctrl + Shift + Enter). B\u1ea1n ho\u00e0n th\u00e0nh m\u1ed9t c\u00f4ng th\u1ee9c SUMPRODUCT theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng b\u1eb3ng c\u00e1ch nh\u1ea5n ph\u00edm Enter.<\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<p style=\"text-align: justify\">T\u1ea5t c\u1ea3 m\u1ea3ng trong c\u00f4ng th\u1ee9c SUMPRODUCT ph\u1ea3i c\u00f3 c\u00f9ng s\u1ed1 h\u00e0ng v\u00e0 s\u1ed1 c\u1ed9t , n\u1ebfu kh\u00f4ng th\u00ec b\u1ea1n s\u1ebd nh\u1eadn l\u1ed7i #VALUE!.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea5t c\u1ee9 c\u00e2u l\u1ec7nh m\u1ea3ng n\u00e0o ch\u1ee9a gi\u00e1 tr\u1ecb phi s\u1ed1, ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c x\u1eed l\u00fd nh\u01b0 s\u1ed1 0.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu m\u1ea3ng l\u00e0 ph\u00e9p th\u1eed l\u00f4 gic, th\u00ec n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE v\u00e0 FALSE. Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1ed5i c\u00e1c gi\u00e1 tr\u1ecb TRUE v\u00e0 FALSE n\u00e0y th\u00e0nh 1 v\u00e0 0 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng to\u00e1n t\u1eed \u0111\u01a1n ph\u00e2n (\u2013). H\u00e3y xem qua v\u00ed d\u1ee5 h\u00e0m SUMPRODUCT c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 n\u1eafm r\u00f5 h\u01a1n.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DUNG_CO_BAN_CUA_HAM_SUMPRODUCT_TRONG_EXCEL\"><\/span>C\u00c1CH D\u00d9NG C\u01a0 B\u1ea2N C\u1ee6A H\u00c0M SUMPRODUCT TRONG EXCEL:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng qu\u00e1t v\u1ec1 c\u00e1ch h\u00e0m SUMPRODUCT trong Excel ho\u1ea1t \u0111\u1ed9ng, h\u00e3y xem qua v\u00ed d\u1ee5 sau.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 s\u1ed1 l\u01b0\u1ee3ng \u1edf c\u00e1c \u00f4 A2:A4, v\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng. N\u1ebfu b\u1ea1n \u0111ang gi\u1ea3i m\u1ed9t ph\u00e9p to\u00e1n \u1edf tr\u01b0\u1eddng, th\u00ec b\u1ea1n s\u1ebd nh\u00e2n s\u1ed1 l\u01b0\u1ee3ng v\u1edbi gi\u00e1 ti\u1ec1n c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m, r\u1ed3i c\u1ed9ng ch\u00fang l\u1ea1i. Trong Microsoft Excel, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u1ec9 v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c SUMPRODUCT:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(A2:A4,B2:B4)<\/p>\n<p style=\"text-align: justify\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y c\u00f4ng th\u1ee9c tr\u00ean th\u1ef1c t\u1ebf:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6027 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/81-300x158-1.png\" width=\"300\" height=\"158\" title=\"81-300x158-1\"><\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 chi ti\u1ebft nh\u1eefng g\u00ec \u0111ang di\u1ec5n ra v\u1ec1 m\u1eb7t to\u00e1n h\u1ecdc:<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c ch\u1ecdn s\u1ed1 \u0111\u1ea7u ti\u00ean trong m\u1ea3ng \u0111\u1ea7u ti\u00ean r\u1ed3i nh\u00e2n n\u00f3 cho s\u1ed1 \u0111\u1ea7u ti\u00ean trong m\u1ea3ng th\u1ee9 hai, r\u1ed3i l\u1ea5y s\u1ed1 th\u1ee9 hai trong m\u1ea3ng \u0111\u1ea7u ti\u00ean nh\u00e2n cho s\u1ed1 th\u1ee9 hai trong m\u1ea3ng th\u1ee9 hai r\u1ed3i c\u1ee9 ti\u1ebfp t\u1ee5c nh\u01b0 th\u1ebf.<\/p>\n<p style=\"text-align: justify\">Khi \u0111\u00e3 nh\u00e2n t\u1ea5t c\u00e1c th\u00e0nh ph\u1ea7n m\u1ea3ng, c\u00f4ng th\u1ee9c s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c t\u00edch s\u1ed1 r\u1ed3i tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1.<\/p>\n<p style=\"text-align: justify\">N\u00f3i c\u00e1ch kh\u00e1c, c\u00f4ng th\u1ee9c SUMPRODUCT bi\u1ec3u di\u1ec5n c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\">=A2*B2 + A3*B3 + A4*B4<\/p>\n<p style=\"text-align: justify\">H\u00e3y ngh\u0129 \u0111\u1ebfn vi\u1ec7c b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m bao nhi\u1ec1u th\u1eddi gian n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n kh\u00f4ng ch\u1ee9a 3 h\u00e0ng d\u1eef li\u1ec7u, m\u00e0 l\u00e0 3 tr\u0103m hay 3 ng\u00e0n h\u00e0ng!<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_SU_DUNG_HAM_SUMPRODUCT_TRONG_EXCEL_%E2%80%93_VI_DU_CONG_THUC\"><\/span>C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M SUMPRODUCT TRONG EXCEL \u2013 V\u00cd D\u1ee4 C\u00d4NG TH\u1ee8C:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u00e2n hai hay nhi\u1ec1u d\u1ea3i \u00f4 v\u1edbi nhau r\u1ed3i c\u1ed9ng c\u00e1c t\u00edch s\u1ed1 l\u00e0 c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n v\u00e0 r\u00f5 r\u00e0ng nh\u1ea5t c\u1ee7a h\u00e0m SUBTOTAL trong Excel, nh\u01b0ng \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch d\u00f9ng duy nh\u1ea5t. V\u1ebb \u0111\u1eb9p th\u1ef1c s\u1ef1 c\u1ee7a h\u00e0m SUMPRODUCT trong Excel \u0111\u00f3 l\u00e0 n\u00f3 c\u00f3 th\u1ec3 l\u00e0m nhi\u1ec1u h\u01a1n c\u00e1c t\u00ednh n\u0103ng \u0111\u00e3 \u0111\u01b0\u1ee3c n\u00eau r\u00f5. S\u00e2u h\u01a1n trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y v\u00e0i c\u00f4ng th\u1ee9c cho th\u1ea5y nh\u1eefng c\u00e1ch d\u00f9ng th\u00fa v\u1ecb v\u00e0 n\u00e2ng cao h\u01a1n nhi\u1ec1u, v\u00ec th\u1ebf h\u00e3y ti\u1ebfp t\u1ee5c \u0111\u1ecdc b\u00e0i vi\u1ebft nh\u00e9!<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_SUMPRODUCT_CO_NHIEU_DIEU_KIEN\"><\/span>H\u00c0M SUMPRODUCT C\u00d3 NHI\u1ec0U \u0110I\u1ec0U KI\u1ec6N<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng trong Microsoft Excel, lu\u00f4n c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t c\u00e1ch \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c. Nh\u01b0ng khi n\u00f3i \u0111\u1ebfn vi\u1ec7c so s\u00e1nh hai hay nhi\u1ec1u m\u1ea3ng, \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, n\u1ebfu kh\u00f4ng n\u00f3i l\u00e0 duy nh\u1ea5t, h\u00e0m SUMPRODUCT trong Excel l\u00e0 h\u00e0m hi\u1ec7u qu\u1ea3 nh\u1ea5t. \u00c0 th\u00ec, h\u00e0m SUMPRODUCT hay c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec1u \u0111\u01b0\u1ee3c.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch c\u00e1c m\u00f3n h\u00e0ng \u1edf c\u1ed9t A, doanh s\u1ed1 b\u00e1n d\u1ef1 ki\u1ebfn \u1edf c\u1ed9t B, v\u00e0 doanh s\u1ed1 b\u00e1n th\u1ef1c \u1edf c\u1ed9t C. M\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n l\u00e0 t\u00ecm xem c\u00f3 bao nhi\u00eau c\u00f3 bao nhi\u00eau m\u00f3n b\u00e1n \u00edt h\u01a1n d\u1ef1 ki\u1ebfn. \u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong nh\u1eefng bi\u1ebfn ph\u00e2n c\u1ee7a c\u00f4ng th\u1ee9c SUMPRODUCT:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(\u2013(C2:C10&lt;B2:B10))<\/p>\n<p style=\"text-align: justify\">hay<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((C2:C10&lt;B2:B10)*1)<\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3 C2:C10 l\u00e0 doanh s\u1ed1 th\u1ef1c v\u00e0 B2:B10 l\u00e0 doanh s\u1ed1 d\u1ef1 ki\u1ebfn.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6028 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/82-300x167-1.png\" width=\"300\" height=\"167\" title=\"82-300x167-1\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng n\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n th\u00ec sao? Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u1ea7n T\u00e1o b\u00e1n \u00edt h\u01a1n d\u1ef1 ki\u1ebfn. Gi\u1ea3i ph\u00e1p \u0111\u00f3 l\u00e0 th\u00eam m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u1eefa v\u00e0o c\u00f4ng th\u1ee9c SUMPRODUCT:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(\u2013(C2:C10&lt;B2:B10), \u2013(A2:A10=\u201dt\u00e1o\u201d))<\/p>\n<p style=\"text-align: justify\">Hay, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00fa ph\u00e1p sau:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((C2:C10&lt;B2:B10)*(A2:A10=\u201dt\u00e1o\u201d))<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6029 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/83-300x151-1.png\" width=\"300\" height=\"151\" title=\"83-300x151-1\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, h\u00e3y d\u00e0nh \u00edt ph\u00fat \u0111\u1ec3 hi\u1ec3u r\u00f5 c\u00f4ng th\u1ee9c tr\u00ean \u0111ang x\u1eed l\u00fd \u0111i\u1ec1u g\u00ec. T\u00f4i tin r\u1eb1ng n\u00f3 \u0111\u00e1ng v\u00e0i ph\u00fat suy ng\u1eabm \u0111\u1ea5y b\u1edfi v\u00ec nhi\u1ec1u c\u00f4ng th\u1ee9c SUMPRODUCT kh\u00e1c c\u00f3 quy lu\u1eadt t\u01b0\u01a1ng t\u1ef1.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H<span data-sheets-value='{\"1\":2,\"2\":\"h\u1ecdc excel \u1edf \u0111\u00e2u t\u1ed1t \"}' data-sheets-userformat='{\"2\":2561,\"3\":[null,0],\"12\":0,\"14\":[null,2,16711680]}'>\u1ecdc excel \u1edf \u0111\u00e2u t\u1ed1t <\/span><\/a><\/p>\n<\/blockquote>\n<h4><span class=\"ez-toc-section\" id=\"CACH_CONG_THUC_SUMPRODUCT_CO_MOT_DIEU_KIEN_HOAT_DONG\"><\/span>C\u00c1CH C\u00d4NG TH\u1ee8C SUMPRODUCT C\u00d3 M\u1ed8T \u0110I\u1ec0U KI\u1ec6N HO\u1ea0T \u0110\u1ed8NG:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, h\u00e3y chia nh\u1ecf c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n h\u01a1n \u2013 c\u00f4ng th\u1ee9c so s\u00e1nh c\u00e1c con s\u1ed1 trong hai c\u1ed9t h\u00e0ng theo h\u00e0ng, v\u00e0 n\u00f3i cho ch\u00fang ta bi\u1ebft s\u1ed1 l\u1ea7n c\u1ed9t C \u00edt h\u01a1n c\u1ed9t B:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(\u2013(C2:C10&lt;B2:B10))<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u1ecdn ph\u1ea7n\u00a0(C2:C10&lt;B2:B10) trong thanh c\u00f4ng th\u1ee9c, v\u00e0 nh\u1ea5n F9 \u0111\u1ec3 xem gi\u00e1 tr\u1ecb \u1ea9n, th\u00ec b\u1ea1n s\u1ebd th\u1ea5y m\u1ea3ng sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"imgl2\" title=\"View the values behind an array\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-array.png\" alt=\"View the values behind an array\"><\/p>\n<p style=\"text-align: justify\">C\u00e1i ch\u00fang ta c\u00f3 \u1edf \u0111\u00e2y \u0111\u00f3 l\u00e0 gi\u00e1 tr\u1ecb h\u00e0m BOOLEAN TRUE v\u00e0 FALSE, trong \u0111\u00f3, TRUE c\u00f3 ngh\u0129a l\u00e0 \u0111\u00e3 \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh (v\u00ed d\u1ee5, m\u1ed9t gi\u00e1 tr\u1ecb \u1edf c\u1ed9t B \u00edt h\u01a1n m\u1ed9t gi\u00e1 tr\u1ecb \u1edf c\u1ed9t C trong c\u00f9ng m\u1ed9t h\u00e0ng), v\u00e0 FALSE cho th\u1ea5y \u0111i\u1ec1u ki\u1ec7n v\u1eabn ch\u01b0a \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng.<\/p>\n<p style=\"text-align: justify\">Hai d\u1ea5u tr\u1eeb (\u2013), v\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 hai to\u00e1n t\u1eed \u0111\u01a1n ph\u00e2n, n\u00f3 \u00e9p bu\u1ed9c TRUE v\u00e0 FALSE th\u00e0nh 1 v\u00e0 0:\u00a0{0;1;0;0;1;0;1;0;0}.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch kh\u00e1c \u0111\u1ec3 \u0111\u1ed5i gi\u00e1 tr\u1ecb l\u00f4gic th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1 \u0111\u00f3 l\u00e0 nh\u00e2n m\u1ea3ng v\u1edbi 1:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((C2:C10&lt;B2:B10)*1)<\/p>\n<p style=\"text-align: justify\">C\u00e1ch n\u00e0o c\u0169ng \u0111\u01b0\u1ee3c, v\u00ec ch\u1ec9 c\u00f3 m\u1ed9t m\u1ea3ng trong c\u00f4ng th\u1ee9c SUMPRODUCT, n\u00ean n\u00f3 ch\u1ec9 nh\u00e2n 1 trong m\u1ea3ng cho k\u1ebft qu\u1ea3 v\u00e0 ch\u00fang ta nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 \u0111\u1ebfm mong mu\u1ed1n. R\u1ea5t d\u1ec5, \u0111\u00fang kh\u00f4ng n\u00e0o?<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6030 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/84-300x140-1.png\" width=\"300\" height=\"140\" title=\"84-300x140-1\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_CONG_THUC_SUMPRODUCT_CO_NHIEU_DIEU_KIEN_HOAT_DONG\"><\/span>C\u00c1CH C\u00d4NG TH\u1ee8C SUMPRODUCT C\u00d3 NHI\u1ec0U \u0110I\u1ec0U KI\u1ec6N HO\u1ea0T \u0110\u1ed8NG:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Khi c\u00f4ng th\u1ee9c SUMPRODUCT trong Excel ch\u1ee9a hai hay nhi\u1ec1u m\u1ea3ng, n\u00f3 nh\u00e2n c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a m\u1ea3ng, r\u1ed3i c\u1ed9ng c\u00e1c t\u00edch s\u1ed1.<\/p>\n<p style=\"text-align: justify\">C\u00f3 l\u1ebd b\u1ea1n v\u1eabn c\u00f2n nh\u1edb, ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n doanh s\u1ed1 th\u1ef1c (c\u1ed9t C) \u00edt h\u01a1n doanh s\u1ed1 d\u1ef1 ki\u1ebfn (c\u1ed9t B) \u0111\u1ed1i v\u1edbi T\u00e1o (c\u1ed9t A):<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(\u2013(C2:C10&lt;B2:B10), \u2013(A2:A10=\u201dt\u00e1o\u201d))<\/p>\n<p style=\"text-align: justify\">hay<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((C2:C10&lt;B2:B10)*(A2:A10=\u201dt\u00e1o\u201d))<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec3m kh\u00e1c bi\u1ec7t duy nh\u1ea5t v\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt gi\u1eefa hai c\u00f4ng th\u1ee9c \u0111\u00f3 l\u00e0 ph\u01b0\u01a1ng ph\u00e1p \u00e9p bu\u1ed9c TRUE v\u00e0 FALSE th\u00e0nh 1 v\u00e0 0 \u2013 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng hai to\u00e1n t\u1eed \u0111\u01a1n ph\u00e2n hay ph\u00e9p nh\u00e2n. K\u1ebft qu\u1ea3 l\u00e0, ch\u00fang ta nh\u1eadn \u0111\u01b0\u1ee3c hai m\u1ea3ng 1 v\u00e0 0:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"imgl2\" title=\"The values behind two arrays\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-arrays.png\" alt=\"The values behind two arrays\"><\/p>\n<p style=\"text-align: justify\">Ph\u00e9p nh\u00e2n th\u1ef1c hi\u1ec7n b\u1edfi h\u00e0m SUMPRODUCT k\u1ebft h\u1ee3p ch\u00fang th\u00e0nh m\u1ed9t m\u1ea3ng ri\u00eang. V\u00e0 v\u00ec nh\u00e2n 0 th\u00ec b\u1eb1ng 0, n\u00ean 1 ch\u1ec9 xu\u1ea5t hi\u1ec7n khi c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, v\u00e0 do \u0111\u00f3 ch\u1ec9 nh\u1eefng h\u00e0ng \u0111\u00f3 m\u1edbi \u0111\u01b0\u1ee3c \u0111\u1ebfm:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6031 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/85-300x139-1.png\" width=\"300\" height=\"139\" title=\"85-300x139-1\"><\/p>\n<h3 style=\"text-align: justify\"><\/h3>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"DEMTINH_TONGTINH_TRUNG_BINH_CO_DIEU_KIEN_CAC_O_VOI_NHIEU_TIEU_CHUAN\"><\/span>\u0110\u1ebeM\/T\u00cdNH T\u1ed4NG\/T\u00cdNH TRUNG B\u00ccNH C\u00d3 \u0110I\u1ec0U KI\u1ec6N C\u00c1C \u00d4 V\u1edaI NHI\u1ec0U TI\u00caU CHU\u1ea8N<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong Excel 2003 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc th\u00ec kh\u00f4ng c\u00f3 h\u00e0m IFS, m\u1ed9t trong nh\u1eefng c\u00e1ch d\u00f9ng th\u00f4ng d\u1ee5ng nh\u1ea5t c\u1ee7a h\u00e0m SUMPRODUCT \u0111\u00f3 l\u00e0 t\u00ednh t\u1ed5ng hay \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00e1c \u00f4 v\u1edbi nhi\u1ec1u ti\u00eau chu\u1ea9n. B\u1eaft \u0111\u1ea7u v\u1edbi Excel 2007, Microsoft gi\u1edbi thi\u1ec7u m\u1ed9t chu\u1ed7i h\u00e0m \u0111\u01b0\u1ee3c \u0111\u1eb7c bi\u1ec7t thi\u1ebft k\u1ebf cho nh\u1eefng nhi\u1ec7m v\u1ee5 n\u00e0y \u2013 <a href=\"http:\/\/blog.ezworkapp.com\/42-%e2%97%8f-su-dung-ham-sumif-sumifs-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m SUMIFS<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countifs-va-countif-voi-nhieu-dieu-kien.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m COUNTIFS <\/a>v\u00e0 h\u00e0m AVERAGEIFS.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng th\u1eadm ch\u00ed \u1edf c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Excel, c\u00f4ng th\u1ee9c SUMPRODUCT ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn thay th\u1ebf, v\u00ed d\u1ee5, t\u00ednh t\u1ed5ng v\u00e0 \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00e1c \u00f4 c\u00f3 h\u00e0m l\u00f4gic OR. D\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n s\u1ebd th\u1ea5y v\u00e0i v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c cho th\u1ea5y kh\u1ea3 n\u0103ng n\u00e0y.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_SUMPRODUCT_VOI_HAM_LOGIC_AND\"><\/span>C\u00d4NG TH\u1ee8C SUMPRODUCT V\u1edaI H\u00c0M L\u00d4GIC AND:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 chu\u1ed7i d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y, trong \u0111\u00f3 c\u1ed9t A li\u1ec7t k\u00ea v\u00f9ng mi\u1ec1n, c\u1ed9t B \u2013 m\u00f3n h\u00e0ng v\u00e0 c\u1ed9t C \u2013 doanh s\u1ed1 b\u00e1n ra:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6032 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/86.png\" width=\"216\" height=\"260\" title=\"86\"><\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1u b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n \u0111\u00f3 l\u00e0 \u0111\u1ebfm, t\u00ednh t\u1ed5ng v\u00e0 t\u00ednh trung b\u00ecnh c\u1ed9ng doanh s\u1ed1 t\u00e1o b\u00e1n ra \u1edf khu v\u1ef1c ph\u00eda B\u1eafc.<\/p>\n<p style=\"text-align: justify\">Trong c\u00e1c phi\u00ean b\u1ea3n Excel g\u1ea7n \u0111\u00e2y: Excel 2016, 2013, 2010 v\u00e0 2007, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng ho\u00e0n th\u00e0nh nhi\u1ec7m v\u1ee5 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS, COUNTIFS v\u00e0 AVERAGEIFS. N\u1ebfu b\u1ea1n \u0111ang t\u00ecm m\u1ed9t h\u01b0\u1edbng \u0111i kh\u00f3 kh\u0103n h\u01a1n, hay n\u1ebfu b\u1ea1n v\u1eabn s\u1eed d\u1ee5ng Excel 2003 hay phi\u00ean b\u1ea3n c\u0169 h\u01a1n, th\u00ec b\u1ea1n v\u1eabn \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n v\u1edbi h\u00e0m SUMPRODUCT trong Excel.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ebfm doanh s\u1ed1 t\u00e1o b\u00e1n ra \u1edf khu v\u1ef1c ph\u00eda B\u1eafc:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(\u2013(A2:A12=\u201dkhu v\u1ef1c ph\u00eda B\u1eafc\u201d), \u2013(B2:B12=\u201dt\u00e1o\u201d))<\/p>\n<p style=\"text-align: justify\">hay<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((A2:A12=\u201dkhu v\u1ef1c ph\u00eda B\u1eafc\u201d)*(B2:B12=\u201dt\u00e1o\u201d))<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 t\u00e1o b\u00e1n ra \u1edf khu v\u1ef1c ph\u00eda B\u1eafc:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(\u2013(A2:A12=\u201dkhu v\u1ef1c ph\u00eda B\u1eafc\u201d), \u2013(B2:B12=\u201dt\u00e1o\u201d), C2:C12)<\/p>\n<p style=\"text-align: justify\">hay<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((A2:A12=\u201dkhu v\u1ef1c ph\u00eda B\u1eafc\u201d)*(B2:B12=\u201dt\u00e1o\u201d)*C2:C12)<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng doanh s\u1ed1 t\u00e1o b\u00e1n ra \u1edf khu v\u1ef1c ph\u00eda B\u1eafc:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng, ch\u00fang ta ch\u1ec9 chia t\u1ed5ng cho ph\u00e9p \u0111\u1ebfm nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(\u2013(A2:A12=\u201dkhu v\u1ef1c ph\u00eda B\u1eafc\u201d), \u2013(B2:B12=\u201dt\u00e1o\u201d), C2:C12) \/ SUMPRODUCT( \u2013(A2:A12=\u201dkhu v\u1ef1c ph\u00eda B\u1eafc\u201d), \u2013(B2:B12=\u201dt\u00e1o\u201d))<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f4ng th\u1ee9c SUMPRODUCT linh ho\u1ea1t h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh r\u00f5 khu v\u1ef1c v\u00e0 m\u00f3n h\u00e0ng mong mu\u1ed1n \u1edf c\u00e1c \u00f4 ri\u00eang, r\u1ed3i tham chi\u1ebfu c\u00e1c \u00f4 \u0111\u00f3 v\u00e0o c\u00f4ng th\u1ee9c gi\u1ed1ng nh\u01b0 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6033 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/87-300x212-1.png\" width=\"300\" height=\"212\" title=\"87-300x212-1\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_SUMPRODUCT_DUNG_CHO_VIEC_TINH_TONG_CO_DIEU_KIEN_HOAT_DONG_NHU_THE_NAO\"><\/span>C\u00d4NG TH\u1ee8C SUMPRODUCT D\u00d9NG CHO VI\u1ec6C T\u00cdNH T\u1ed4NG C\u00d3 \u0110I\u1ec0U KI\u1ec6N HO\u1ea0T \u0110\u1ed8NG NH\u01af TH\u1ebe N\u00c0O<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">T\u1eeb v\u00ed d\u1ee5 tr\u01b0\u1edbc, b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch c\u00f4ng th\u1ee9c SUMPRODUCT trong Excel \u0111\u1ebfm s\u1ed1 \u00f4 c\u00f9ng v\u1edbi hi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. N\u1ebfu b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 c\u00e1ch \u0111\u00f3, s\u1ebd r\u1ea5t d\u1ec5 d\u00e0ng \u0111\u1ec3 b\u1ea1n n\u1eafm r\u00f5 quy lu\u1eadt t\u00ednh t\u1ed5ng.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00f4i nh\u1eafc b\u1ea1n nh\u1edb r\u1eb1ng ch\u00fang ta \u0111\u00e3 d\u00f9ng c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 T\u00e1o \u1edf khu v\u1ef1c ph\u00eda B\u1eafc:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(\u2013(A2:A12=\u201dkhu v\u1ef1c ph\u00eda B\u1eafc\u201d), \u2013(B2:B12=\u201dt\u00e1o\u201d), C2:C12)<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u1ef1c ti\u1ebfp c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean ch\u00ednh l\u00e0 3 m\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"imgl2\" title=\"An intermediate result of the SUMPRODUCT formula for conditional sum\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/conditional-sum-arrays.png\" alt=\"An intermediate result of the SUMPRODUCT formula for conditional sum\"><\/p>\n<p style=\"text-align: justify\">Trong m\u1ea3ng \u0111\u1ea7u ti\u00ean, 1 \u0111\u1ea1i di\u1ec7n cho khu v\u1ef1c ph\u00eda B\u1eafc, v\u00e0 0 \u0111\u1ea1i di\u1ec7n cho c\u00e1c khu v\u1ef1c kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">Trong m\u1ea3ng th\u1ee9 hai, 1 \u0111\u1ea1i di\u1ec7n cho T\u00e1o, v\u00e0 0 \u0111\u1ea1i di\u1ec7n cho c\u00e1c m\u00f3n h\u00e0ng kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">M\u1ea3ng th\u1ee9 ba ch\u1ee9a ch\u00ednh c\u00e1c con s\u1ed1 xu\u1ea5t hi\u1ec7n t\u1eeb \u00f4 C2 \u0111\u1ebfn C12.<\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb r\u1eb1ng nh\u00e2n 0 th\u00ec lu\u00f4n b\u1eb1ng 0, v\u00e0 nh\u00e2n 1 th\u00ec b\u1eb1ng ch\u00ednh n\u00f3, ch\u00fang ta c\u00f3 m\u1ea3ng cu\u1ed1i c\u00f9ng ch\u1ee9a doanh s\u1ed1 v\u00e0 nh\u1eefng con s\u1ed1 0 \u2013 doanh s\u1ed1 ch\u1ec9 xu\u1ea5t hi\u1ec7n n\u1ebfu hai m\u1ea3ng \u0111\u1ea7u ti\u00ean c\u00f3 s\u1ed1 1 \u1edf c\u00f9ng m\u1ed9t v\u1ecb tr\u00ed, c\u1ee5 th\u1ec3 l\u00e0 c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng; c\u00f2n kh\u00f4ng th\u00ec s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 0:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6034 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/88-300x84-1.png\" width=\"300\" height=\"84\" title=\"88-300x84-1\"><\/p>\n<p style=\"text-align: justify\">C\u1ed9ng c\u00e1c con s\u1ed1 trong m\u1ea3ng tr\u00ean cho k\u1ebft qu\u1ea3 mong mu\u1ed1n \u2013 doanh s\u1ed1 T\u00e1o b\u00e1n ra \u1edf khu v\u1ef1c ph\u00eda B\u1eafc.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00cd D\u1ee4 2. C\u00d4NG TH\u1ee8C SUMPRODUCT V\u1edaI H\u00c0M L\u00d4GIC OR<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f4ng hay \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00e1c \u00f4 s\u1eed d\u1ee5ng h\u00e0m l\u00f4gic OR, h\u00e3y s\u1eed d\u1ee5ng d\u1ea5u c\u1ed9ng (+) gi\u1eefa c\u00e1c m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c Excel SUMPRODUCT, c\u0169ng nh\u01b0 trong c\u00f4ng th\u1ee9c m\u1ea3ng, d\u1ea5u c\u1ed9ng \u0111\u00f3ng vai tr\u00f2 l\u00e0m to\u00e1n t\u1eed OR h\u01b0\u1edbng d\u1eabn Excel tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE n\u1ebfu b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o trong bi\u1ec3u th\u1ee9c x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng doanh s\u1ed1 T\u00e1o v\u00e0 Chanh kh\u00f4ng ph\u00e2n bi\u1ec7t v\u00f9ng mi\u1ec1n, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((B2:B12=\u201dt\u00e1o\u201d)+(B2:B12=\u201dchanh\u201d))<\/p>\n<p style=\"text-align: justify\">N\u00f3i \u0111\u01a1n gi\u1ea3n, c\u00f4ng th\u1ee9c tr\u00ean c\u00f3 ngh\u0129a l\u00e0: H\u00e3y \u0111\u1ebfm s\u1ed1 \u00f4 n\u1ebfu d\u1ea3i \u00f4 B2:B12=\u201dt\u00e1o\u201d OR B2:B12=\u201dchanh\u201d.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 T\u00e1o v\u00e0 Chanh, h\u00e3y th\u00eam m\u1ed9t c\u00e2u l\u1ec7nh ch\u1ee9a d\u1ea3i \u00f4 Doanh s\u1ed1:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((B2:B12=\u201dt\u00e1o\u201d)+(B2:B12=\u201dchanh\u201d), C2:C12)<\/p>\n<p style=\"text-align: justify\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y di\u1ec5n gi\u1ea3i c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6035 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/89-300x186-1.png\" width=\"300\" height=\"186\" title=\"89-300x186-1\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00cd D\u1ee4 3. C\u00d4NG TH\u1ee8C SUMPRODUCT C\u00d9NG V\u1edaI H\u00c0M L\u00d4GIC AND V\u00c0 H\u00c0M L\u00d4GIC OR<\/strong><\/p>\n<p style=\"text-align: justify\">Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, c\u00f3 th\u1ec3 b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1ebfm hay t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng c\u1ea3 h\u00e0m l\u00f4gic AND v\u00e0 OR. Th\u1eadm ch\u00ed \u1edf phi\u00ean b\u1ea3n Excel m\u1edbi nh\u1ea5t , chu\u1ed7i h\u00e0m li\u00ean quan \u0111\u1ebfn h\u00e0m IF c\u0169ng kh\u00f4ng th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng gi\u1ea3i ph\u00e1p kh\u1ea3 thi \u0111\u00f3 l\u00e0 k\u1ebft h\u1ee3p hai hay nhi\u1ec1u h\u00e0m SUMIFS+SUMIFS hay COUNTIFS+COUNTIFS.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch kh\u00e1c \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT trong \u0111\u00f3:<\/p>\n<p style=\"text-align: justify\">D\u1ea5u hoa th\u1ecb (*) \u0111\u01b0\u1ee3c d\u00f9ng nh\u01b0 to\u00e1n t\u1eed AND.<\/p>\n<p style=\"text-align: justify\">D\u1ea5u c\u1ed9ng (+) \u0111\u01b0\u1ee3c d\u00f9ng nh\u01b0 to\u00e1n t\u1eed OR.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 khi\u1ebfn m\u1ecdi th\u1ee9 \u0111\u01a1n gi\u1ea3n h\u01a1n, h\u00e3y xem x\u00e9t c\u00e1c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n T\u00e1o v\u00e0 Chanh \u0111\u01b0\u1ee3c b\u00e1n \u1edf khu v\u1ef1c ph\u00eda B\u1eafc, h\u00e3y l\u1eadp c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m l\u00f4gic sau:<\/p>\n<p style=\"text-align: justify\">=Count If ((V\u00f9ng mi\u1ec1n=\u201dmi\u1ec1n B\u1eafc\u201d) AND ((M\u00f3n h\u00e0ng=\u201dT\u00e1o\u201d) OR (M\u00f3n h\u00e0ng=\u201dChanh\u201d)))<\/p>\n<p style=\"text-align: justify\">Khi v\u1eeba s\u1eed d\u1ee5ng theo c\u00fa ph\u00e1p h\u00e0m SUMPRODUCT, c\u00f4ng th\u1ee9c s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((A2:A12=\u201dmi\u1ec1n B\u1eafc\u201d)*((B2:B12=\u201dt\u00e1o\u201d)+(B2:B12=\u201dchanh\u201d)))<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 T\u00e1o v\u00e0 Chanh b\u00e1n ra \u1edf khu v\u1ee5c ph\u00eda B\u1eafc, h\u00e3y d\u00f9ng c\u00f4ng th\u1ee9c tr\u00ean r\u1ed3i th\u00eam d\u1ea3i \u00f4 Doanh s\u1ed1 c\u00f9ng v\u1edbi h\u00e0m l\u00f4gic AND:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT((A2:A12=\u201dmi\u1ec1n B\u1eafc\u201d)*((B2:B12=\u201dt\u00e1o\u201d)+(B2:B12=\u201dchanh\u201d))*C2:C12)<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f4ng th\u1ee9c tr\u00f4ng g\u1ecdn h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 c\u00e1c bi\u1ebfn v\u00e0o c\u00e1c \u00f4 ri\u00eang bi\u1ec7t \u2013 Khu v\u1ef1c \u1edf \u00f4 F1 v\u00e0 M\u00f3n h\u00e0ng \u1edf \u00f4 F2 v\u00e0 H2 \u2013 r\u1ed3i tham chi\u1ebfu c\u00e1c \u00f4 n\u00e0y v\u00e0o c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6036 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/90-300x180-1.png\" width=\"300\" height=\"180\" title=\"90-300x180-1\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_SUMPRODUCT_DUNG_DE_TINH_TRUNG_BINH_CO_TRONG_LUONG\"><\/span>C\u00d4NG TH\u1ee8C SUMPRODUCT D\u00d9NG \u0110\u1ec2 T\u00cdNH TRUNG B\u00ccNH C\u00d3 TR\u1eccNG L\u01af\u1ee2NG<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">\u1ede m\u1ed9t trong nh\u1eefng v\u00ed d\u1ee5 tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 b\u00e0n v\u1ec1 c\u00f4ng th\u1ee9c SUMPRODUCT d\u00f9ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u00f3 \u0111i\u1ec1u ki\u1ec7n. C\u00e1ch d\u00f9ng ph\u1ed5 bi\u1ebfn kh\u00e1c c\u1ee7a h\u00e0m SUMPRODUCT trong Excel \u0111\u00f3 l\u00e0 t\u00ednh trung b\u00ecnh c\u00f3 tr\u1ecdng l\u01b0\u1ee3ng trong \u0111\u00f3 m\u1ed7i gi\u00e1 tr\u1ecb c\u00f3 m\u1ed9t tr\u1ecdng l\u01b0\u1ee3ng nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c SUMPRODUCT t\u00ednh trung b\u00ecnh c\u00f3 tr\u1ecdng l\u01b0\u1ee3ng t\u1ed5ng qu\u00e1t c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">SUMPRODUCT(<em>values<\/em>,\u00a0<em>weights<\/em>) \/ SUM(<em>weights<\/em>)<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m \u1edf d\u1ea3i \u00f4 B2:B7 v\u00e0 tr\u1ecdng l\u01b0\u1ee3ng \u1edf d\u1ea3i \u00f4 C2:C7, c\u00f4ng th\u1ee9c SUMPRODUCT t\u00ednh trung b\u00ecnh c\u00f3 tr\u1ecdng l\u01b0\u1ee3ng c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(B2:B7,C2:C7)\/SUM(C2:C7)<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6037 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/91.png\" width=\"294\" height=\"239\" title=\"91\"><\/p>\n<p style=\"text-align: justify\">T\u00f4i tin r\u1eb1ng ngay b\u00e2y gi\u1edd, b\u1ea1n s\u1ebd kh\u00f4ng g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c hi\u1ec3u quy lu\u1eadt c\u00f4ng th\u1ee9c n\u1eefa.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_SUMPRODUCT_DUOC_DUNG_LAM_HAM_THAY_THE_CHO_CONG_THUC_MANG\"><\/span>H\u00c0M SUMPRODUCT \u0110\u01af\u1ee2C D\u00d9NG L\u00c0M H\u00c0M THAY TH\u1ebe CHO C\u00d4NG TH\u1ee8C M\u1ea2NG<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Ngay c\u1ea3 khi b\u1ea1n \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y ch\u1ec9 \u0111\u1ec3 c\u00f3 th\u00eam th\u00f4ng tin v\u00e0 b\u1ea1n kh\u00f4ng c\u00f2n nh\u1edb r\u00f5 c\u00e1c chi ti\u1ebft n\u1eefa, h\u00e3y nh\u1edb m\u1ed9t \u0111i\u1ec3m m\u1ea5u ch\u1ed1t quan tr\u1ecdng \u2013 h\u00e0m SUMPRODUCT trong Excel x\u1eed l\u00fd m\u1ea3ng. V\u00e0 v\u00ec h\u00e0m SUMPRODUCT c\u00f3 c\u00e1c kh\u1ea3 n\u0103ng c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng, n\u00ean n\u00f3 c\u00f3 th\u1ec3 tr\u1edf th\u00e0nh h\u00e0m thay th\u1ebf d\u1ec5 s\u1eed d\u1ee5ng cho c\u00f4ng th\u1ee9c m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">\u01afu \u0111i\u1ec3m l\u00e0 g\u00ec? V\u1ec1 m\u1eb7t c\u01a1 b\u1ea3n, b\u1ea1n c\u00f3 kh\u1ea3 n\u0103ng qu\u1ea3n l\u00fd c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u1ea5p\u00a0Ctrl + Shift + Enter m\u1ed7i l\u1ea7n b\u1ea1n nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng m\u1edbi hay ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong d\u1ea3i \u00f4 x\u00e1c \u0111\u1ecbnh:<\/p>\n<p style=\"text-align: justify\">{=SUM(LEN(<em>range<\/em>))}<\/p>\n<p style=\"text-align: justify\">v\u00e0 bi\u1ebfn n\u00f3 th\u00e0nh c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng:<\/p>\n<p style=\"text-align: justify\">=SUMPRODUCT(LEN(<em>range<\/em>))<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6038 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/92-300x118-1.png\" width=\"300\" height=\"118\" title=\"92-300x118-1\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u1ef1c h\u00e0nh, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng n\u00e0y trong Excel r\u1ed3i c\u1ed1 g\u1eafng vi\u1ebft l\u1ea1i s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"MOD_va_SUMPRODUCT_trong_Excel_dem_o_chua_so_le\"><\/span>MOD v\u00e0 SUMPRODUCT trong Excel \u0111\u1ebfm \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta \u0111\u1ec1u \u0111\u00e3 bi\u1ebft s\u1ed1 l\u1ebb l\u00e0 nh\u1eefng s\u1ed1 chia 2 d\u01b0 1. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ta s\u1ebd k\u1ebft h\u1ee3p 2 h\u00e0m l\u00e0 MOD v\u00e0 SUMPRODUCT \u0111\u1ec3 ti\u1ebfn h\u00e0nh \u0111\u1ebfm nh\u1eefng \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb trong Excel.<\/p>\n<p>D\u1eef li\u1ec7u m\u1eabu c\u1ee7a ta nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30793 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-mod-dem-so-le-1.png\" alt=\"ung-dung-ham-sumproduct-dem-o-chua-so-le-1\" width=\"400\" height=\"450\" title=\"sumproduct-mod-dem-so-le-1\"><\/p>\n<p>Y\u00eau c\u1ea7u: \u0110\u1ebfm nh\u1eefng \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb.<\/p>\n<p>C\u00f4ng th\u1ee9c h\u00e0m SUMPRODUCT excel trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u1ee7a ta nh\u01b0 sau:<\/p>\n<p><em><strong>=SUMPRODUCT(\u2013(MOD(A1:A15,2)=1))<\/strong><\/em><\/p>\n<p>C\u00f4ng th\u1ee9c\u00a0(MOD(A1:A15,2)=1) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb\u00a0d\u1ea1ng m\u1ea3ng {TRUE; FALSE} t\u01b0\u01a1ng \u1ee9ng:\u00a0<strong>TRUE\u00a0<\/strong>n\u1ebfu \u00f4 kh\u00f4ng chia h\u1ebft cho 2 v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.\u00a0<strong>\u2014<\/strong> bi\u1ebfn TRUE th\u00e0nh 1, FALSE th\u00e0nh 0. Cu\u1ed1i c\u00f9ng ta l\u1ed3ng v\u00e0o\u00a0<strong>SUMPRODUCT<\/strong> tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 l\u1ebb.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30794 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-mod-dem-so-le-2.png\" alt=\"ung-dung-ham-sumproduct-dem-o-chua-so-le-2\" width=\"521\" height=\"490\" title=\"sumproduct-mod-dem-so-le-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_ung_dung_thuong_gap_va_cac_ham_thuong_dung_voi_SUMPRODUCT\"><\/span>C\u00e1c \u1ee9ng d\u1ee5ng th\u01b0\u1eddng g\u1eb7p, v\u00e0 c\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng v\u1edbi SUMPRODUCT.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"Cac_ham_kiem_tra_logic_ISNUMBERISERROR_SEARCH\"><\/span>C\u00e1c h\u00e0m ki\u1ec3m tra logic: ISNUMBER\/ISERROR + SEARCH<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ul>\n<li>H\u00e0m SEARCH gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm \u0111i\u1ec1u ki\u1ec7n c\u00f3 trong v\u00f9ng t\u00ecm ki\u1ebfm hay kh\u00f4ng? N\u1ebfu t\u00ecm th\u1ea5y s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 c\u1ee7a v\u1ecb tr\u00ed t\u00ecm th\u1ea5y, c\u00f2n kh\u00f4ng t\u00ecm th\u1ea5y h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 #VALUE. L\u00fac n\u00e0y \u0111\u1ec3 tr\u00e1nh l\u1ed7i, ta d\u00f9ng h\u00e0m ISNUMBER \u0111\u1ec3 b\u1ecf qua l\u1ed7i, ch\u1ec9 t\u00ednh c\u00e1i t\u00ecm th\u1ea5y.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/sumproduct-isnumber-search.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24321\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-isnumber-search.jpg\" width=\"680\" height=\"322\" title=\"sumproduct-isnumber-search\"><\/a><br \/>\nV\u00ed d\u1ee5, ta t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m ch\u1ee9a ch\u1eef \u201c<strong>\u00e1<\/strong>\u201c, trong v\u00ed d\u1ee5 b\u1ea1n l\u01b0u \u00fd kh\u00e1c bi\u1ec7t gi\u1eefa d\u1ea5u * v\u1edbi d\u1ea5u ph\u1ea9y (,).<\/li>\n<li>H\u00e0m SEARCH gi\u00fap ch\u00fang ta t\u00ecm ki\u1ebfm kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef Hoa\/th\u01b0\u1eddng. N\u1ebfu b\u1ea1n c\u1ea7n t\u00ecm ch\u1eef gi\u1ed1ng nhau th\u00ec l\u00fac n\u00e0y c\u00f3 h\u00e0m FIND.<\/li>\n<\/ul>\n<\/li>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"Tinh_tong_tat_ca_cac_sheet_voi_SUMIFS\"><\/span><strong>T\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c sheet v\u1edbi SUMIFS<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ul>\n<li>Khi b\u1ea1n c\u00f3 c\u00e1c sheet kh\u00e1c nhau \u0111\u1ed3ng nh\u1ea5t v\u1ec1 c\u1ea5u tr\u00fac, v\u00ed d\u1ee5 b\u1ea3ng ch\u1ea5m c\u00f4ng t\u1eebng th\u00e1ng trong n\u0103m. B\u1ea1n l\u00e0m b\u00e1o c\u00e1o t\u1ed5ng k\u1ebft cu\u1ed1i n\u0103m, l\u00fac n\u00e0y h\u00e0m SUMPRODUCT+SUMIFS+INDIRECT s\u1ebd gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c n\u00e0y.<br \/>\nHo\u1eb7c b\u1ea1n c\u00f3 danh s\u00e1ch s\u1ea3n ph\u1ea9m t\u1eebng th\u00e1ng, b\u1ea1n c\u1ea7n t\u00ednh s\u1ed1 l\u01b0\u1ee3ng t\u01b0\u01a1ng \u1ee9ng. L\u00fac n\u00e0y b\u1ea1n ch\u1ec9 c\u1ea7n li\u1ec7t k\u00ea danh s\u00e1ch t\u00ean c\u00e1c sheet, v\u00e0 v\u00f9ng d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng. V\u1eady l\u00e0 ta c\u00f3 \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-tinh-tong-qua-cac-sheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24329\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-tinh-tong-qua-cac-sheet.jpg\" width=\"925\" height=\"411\" title=\"sumproduct-tinh-tong-qua-cac-sheet\"><\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>T\u00e1ch chu\u1ed7i ra \u0111\u1ec3 l\u1ea5y s\u1ed1 li\u1ec7u t\u00ednh to\u00e1n:<\/strong>\n<ul>\n<li>B\u00e0i to\u00e1n \u0111\u1eb7t ra b\u1ea1n c\u00f3 chu\u1ed7i k\u00fd t\u1ef1: u, x, 3g, nhu\u1ed9m. V\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00e1ch ra theo c\u00e1c \u0111\u01a1n v\u1ecb t\u00ednh t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<li>V\u1eadn d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m TEXT \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c s\u1ed1, ch\u1eef, v\u00e0 s\u1ed1 0 th\u00e0nh con s\u1ed1 t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-text-substitute-tach-chuoi-tinh-toan.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-31285\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-text-substitute-tach-chuoi-tinh-toan.png\" width=\"1215\" height=\"230\" title=\"sumproduct-text-substitute-tach-chuoi-tinh-toan\"><\/a><\/p>\n<ul>\n<li><strong>Chuy\u1ec3n chu\u1ed7i k\u00fd t\u1ef1 bi\u1ec3u th\u1ee9c c\u1ed9ng tr\u1eeb th\u00e0nh k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n:<\/strong>\n<ul>\n<li>B\u01b0\u1edbc 1: Ch\u00fang ta s\u1ebd t\u00ecm thay th\u1ebf k\u00fd t\u1ef1 \u201c-\u201d th\u00e0nh \u201c+-\u201c.<\/li>\n<li>B\u01b0\u1edbc 2: Ch\u00fang ta s\u1ebd t\u00ecm thay th\u1ebf k\u00fd t\u1ef1 \u201c+\u201d v\u1edbi h\u00e0m REPT(\u201d \u201c,99) nh\u1eb1m ch\u00e8n thay th\u1ebf 99 k\u00fd t\u1ef1 \u201d \u201c.<\/li>\n<li>B\u01b0\u1edbc 3: H\u00e0m MID s\u1ebd t\u00e1ch c\u00e1c ph\u1ea7n ra gi\u1eefa 99 k\u00fd t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam qua b\u00e0i vi\u1ebft<strong> <a href=\"http:\/\/blog.ezworkapp.com\/substitute-va-40-ten-cuop.html\" target=\"_blank\" rel=\"noopener noreferrer\">SUBSTITUTE v\u00e0 40 t\u00ean c\u01b0\u1edbp<\/a><\/strong>.<\/li>\n<li>B\u01b0\u1edbc 4: Kh\u00e1c v\u1edbi h\u00e0m TRIM, ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m TEXT nh\u1eadn d\u1ea1ng k\u00fd t\u1ef1.<\/li>\n<li>B\u01b0\u1edbc 5: V\u1edbi h\u00e0m SUMPRODUCT k\u1ebft h\u1ee3p d\u1ea5u <code>-- (d\u00f9ng \u0111\u1ec3 chuy\u1ec3n ch\u1eef th\u00e0nh s\u1ed1)<\/code>, sau \u0111\u00f3 c\u1ed9ng d\u1ed3n l\u1ea1i v\u1edbi nhau.<\/li>\n<li>K\u1ebft qu\u1ea3:<code class=\"excel-formula\">=SUMPRODUCT(--TEXT(MID(SUBSTITUTE(SUBSTITUTE(A2,\"-\",\"+-\"),\"+\",REPT(\" \",99)),ROW(INDIRECT(\"1:\"&amp;LEN(A2)))*99-98,99),\"0.00;-0.00;0;\"))<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-28456 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-cong-tru-chuoi-bieu-thuc.png\" width=\"724\" height=\"288\" title=\"sumproduct-cong-tru-chuoi-bieu-thuc\"><\/p>\n<ul>\n<li><strong>\u0110\u1ebfm duy nh\u1ea5t v\u1edbi SUMPRODUCT:<\/strong><\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-dem-so-duy-nhat-tinh-tong.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-28030 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-dem-so-duy-nhat-tinh-tong.png\" width=\"858\" height=\"412\" title=\"sumproduct-dem-so-duy-nhat-tinh-tong\"><\/a><\/p>\n<ul>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"Tinh_so_gio_di_muon_ve_som_gio_lam_cua_nhan_vien_voi_ham_SUMPRODUCT\"><\/span>T\u00ednh s\u1ed1 gi\u1edd \u0111i mu\u1ed9n, v\u1ec1 s\u1edbm, gi\u1edd l\u00e0m c\u1ee7a nh\u00e2n vi\u00ean v\u1edbi h\u00e0m SUMPRODUCT.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ul>\n<li>Ta quy \u01b0\u1edbc gi\u1edd \u0111i mu\u1ed9n v\u00e0o \u00f4 BM1, l\u00e0 8:00, n\u1ebfu \u0111i sau gi\u1edd \u0111\u00f3 t\u00ednh l\u00e0 mu\u1ed9n.<\/li>\n<li>SUMPRODUCT l\u00fac n\u00e0y l\u1ea5y gi\u1edd checkin, tr\u1eeb cho gi\u1edd quy \u0111\u1ecbnh.<\/li>\n<li>\u0110\u1ec3 quy ra s\u1ed1 ph\u00fat, ta c\u1ea7n nh\u00e2n cho 24 gi\u1edd x 60 ph\u00fat. V\u00ec th\u1eddi gian trong Excel l\u00e0 m\u1ed9t con s\u1ed1 th\u1eadp ph\u00e2n t\u1eeb 0 -&gt; 1.<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-chamcong.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25386\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-chamcong.jpg\" width=\"1326\" height=\"337\" title=\"sumproduct-chamcong\"><\/a><\/li>\n<\/ul>\n<\/li>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"Ung_dung_SUMPRODUCT_trong_viec_cham_cong_tinh_cong_cho_nhan_vien\"><\/span>\u1ee8ng d\u1ee5ng SUMPRODUCT trong vi\u1ec7c ch\u1ea5m c\u00f4ng, t\u00ednh c\u00f4ng cho nh\u00e2n vi\u00ean.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ul>\n<li>B\u1ea1n c\u00f3 th\u1ec3 l\u1eadp b\u1ea3ng k\u00fd hi\u1ec7u, v\u00e0 quy \u0111\u1ed5i k\u00fd hi\u1ec7u \u0111\u00f3 sang ng\u00e0y c\u00f4ng t\u01b0\u01a1ng \u1ee9ng. R\u1ed3i t\u1eeb \u0111\u00f3 b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u00ednh ng\u00e0y c\u00f4ng.<\/li>\n<li>V\u00ed d\u1ee5 nh\u01b0 sau, ta th\u1ea5y c\u00f3 4x = 4 ng\u00e0y c\u00f4ng, 1np = 1 ng\u00e0y c\u00f4ng, x2 = 2 ng\u00e0y c\u00f4ng. K\u1ebft qu\u1ea3 7 l\u00e0 ch\u00ednh x\u00e1c.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-cham-cong.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24333\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-cham-cong.jpg\" width=\"789\" height=\"256\" title=\"sumproduct-cham-cong\"><\/a><\/li>\n<li>\u1ee8ng d\u1ee5ng ch\u1ea5m c\u00f4ng theo gi\u1edd, t\u00ednh t\u0103ng ca ngo\u00e0i gi\u1edd v\u00e0 Ch\u1ee7 nh\u1eadt.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/ung-dung-sumproduct-cham-cong-thoi-gian.png\"><br \/>\n<\/a><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/ung-dung-sumproduct-cham-cong-thoi-gian-lam-viec.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-29920 alignnone\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ung-dung-sumproduct-cham-cong-thoi-gian-lam-viec-1024x385-1.png\" width=\"1024\" height=\"385\" title=\"ung-dung-sumproduct-cham-cong-thoi-gian-lam-viec-1024x385-1\"><\/a><\/li>\n<li>\u1ee8ng d\u1ee5ng SUMPRODUCT k\u1ebft h\u1ee3p SUBTOTAL \u0111\u1ec3 t\u00ednh to\u00e1n b\u1ecf qua c\u00e1c d\u00f2ng \u1ea9n, c\u1ed9t \u1ea9n:<br \/>\nB\u00e0i to\u00e1n \u0111\u1eb7t ra: S\u1ebd t\u00ednh t\u1ed5ng s\u1ed1\u00a0nh\u00e2n c\u00f4ng theo t\u1eebng ng\u00e0y, v\u00e0 h\u1ecd c\u00f3 th\u1ec3 ngh\u1ec9 l\u1ec5 nh\u01b0ng v\u1eabn \u0111i l\u00e0m n\u00ean c\u1ea7n t\u00ednh c\u00f4ng t\u1eebng ng\u00e0y.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-ket-hop-SUBTOTAL-de-tinh-bo-qua-dong-an-cot-an.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-30672 alignnone\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-ket-hop-subtotal-de-tinh-bo-qua-dong-an-cot-an-1024x561-1.png\" width=\"1024\" height=\"561\" title=\"sumproduct-ket-hop-subtotal-de-tinh-bo-qua-dong-an-cot-an-1024x561-1\"><\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>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 <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/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-82.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1157,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1156","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\/1156","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=1156"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1156\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1157"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}