{"id":103802,"date":"2024-11-02T07:44:59","date_gmt":"2024-11-02T00:44:59","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=103802"},"modified":"2024-11-05T14:19:17","modified_gmt":"2024-11-05T07:19:17","slug":"ham-sumif-trong-excel-cu-phap-cach-su-dung","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/","title":{"rendered":"H\u00e0m Sumif trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda 2024"},"content":{"rendered":"\n<p>H\u00e0m Sumif l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi \u0111\u00e1p \u1ee9ng x\u00e1c \u0111\u1ecbnh. B\u00e0i vi\u1ebft n\u00e0y <a href=\"https:\/\/phongvu.vn\/cong-nghe\">Phong V\u0169 Tech News<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF m\u1ed9t c\u00e1ch chi ti\u1ebft, k\u00e8m theo c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf \u0111\u1ec3 b\u1ea1n d\u1ec5 d\u00e0ng n\u1eafm b\u1eaft.<\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-match-trong-excel\/\">H\u00e0m MATCH trong Excel \u2013 H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/trong-excel-la-loi-gi-cach-sua-loi-nhanh\/\">#### trong Excel l\u00e0 l\u1ed7i g\u00ec? C\u00e1ch s\u1eeda l\u1ed7i nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/\">C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m ROUND, ROUNDUP<\/a><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXe7_2rbGIoIjhw-Cef_ragFLlNU_-Ro3sUCKx48eGUfm1IsQ2LIb7e71wGfrzS5MwsotPyHBj-tedY0KTMf4xmL7-4eT6qwpq4CLMAkrq9yQAf1wMOyjKBcfzxAdm-WkrVvxCiuREuSS-nreYnS0NgxfCsE?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"H\u00e0m Sumif trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda 2024\n\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>H\u00e0m Sumif trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda 2024<\/em><\/figcaption><\/figure>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a2628b5c99d3\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a2628b5c99d3\"  type=\"checkbox\" id=\"item-6a2628b5c99d3\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#Sumif_la_ham_gi_Ham_Sumif_trong_Excel_duoc_dung_de_lam_gi\" title=\"Sumif l\u00e0 h\u00e0m g\u00ec? H\u00e0m Sumif trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?\">Sumif l\u00e0 h\u00e0m g\u00ec? H\u00e0m Sumif trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#Cu_phap_ham_Sumif_trong_Excel\" title=\"C\u00fa ph\u00e1p h\u00e0m Sumif trong Excel\">C\u00fa ph\u00e1p h\u00e0m Sumif trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#Cach_dung_ham_Sumif_kem_vi_du_minh_hoa\" title=\"C\u00e1ch d\u00f9ng h\u00e0m Sumif k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\">C\u00e1ch d\u00f9ng h\u00e0m Sumif k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#Can_luu_y_gi_khi_dung_ham_Sumif\" title=\"C\u1ea7n l\u01b0u \u00fd g\u00ec khi d\u00f9ng h\u00e0m Sumif\">C\u1ea7n l\u01b0u \u00fd g\u00ec khi d\u00f9ng h\u00e0m Sumif<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#Phan_biet_ham_Sumif_va_Sumifs_trong_Excel\" title=\"Ph\u00e2n bi\u1ec7t h\u00e0m Sumif v\u00e0 Sumifs trong Excel\">Ph\u00e2n bi\u1ec7t h\u00e0m Sumif v\u00e0 Sumifs trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#Mot_so_cau_hoi_thuong_gap_ve_ham_Sumif_trong_Excel\" title=\"M\u1ed9t s\u1ed1 c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m Sumif trong Excel\">M\u1ed9t s\u1ed1 c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m Sumif trong Excel<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#SUMIF_co_the_su_dung_voi_du_lieu_dang_Text_khong\" title=\"SUMIF c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng Text kh\u00f4ng?\">SUMIF c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng Text kh\u00f4ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#Lam_sao_de_su_dung_SUMIF_voi_nhieu_dieu_kien\" title=\"L\u00e0m sao \u0111\u1ec3 s\u1eed d\u1ee5ng SUMIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n?\">L\u00e0m sao \u0111\u1ec3 s\u1eed d\u1ee5ng SUMIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#Cach_khac_phuc_khi_ham_SUMIF_khong_hoat_dong\" title=\"C\u00e1ch kh\u1eafc ph\u1ee5c khi h\u00e0m SUMIF kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng?\">C\u00e1ch kh\u1eafc ph\u1ee5c khi h\u00e0m SUMIF kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/#Tong_ket\" title=\"T\u1ed5ng k\u1ebft\">T\u1ed5ng k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Sumif_la_ham_gi_Ham_Sumif_trong_Excel_duoc_dung_de_lam_gi\"><\/span><strong>Sumif l\u00e0 h\u00e0m g\u00ec? H\u00e0m Sumif trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sumif l\u00e0 h\u00e0m t\u00ednh t\u1ed5ng h\u1eefu \u00edch trong Excel. H\u00e0m Sumif t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc.<\/p>\n\n\n\n<p>H\u00e0m Sumif trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng d\u00e3y s\u1ed1 theo \u0111i\u1ec1u ki\u1ec7n m\u00e0 ng\u01b0\u1eddi d\u00f9ng x\u00e1c \u0111\u1ecbnh m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. H\u00e0m Sumif c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c trong Excel \u0111\u1ec3 c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n c\u1ee7a ng\u01b0\u1eddi d\u00f9ng tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n. \u0110\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng hay k\u1ebf to\u00e1n, h\u00e0m Sumif \u0111\u1eb7c bi\u1ec7t ti\u1ec7n l\u1ee3i, thu\u1eadn ti\u1ec7n trong c\u00f4ng vi\u1ec7c.<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXd40b74nxi2QLDm8a9U8sho82jqSMjLMu8KDI_YRxgKWev5hlxExAOSmmjXFlGSL4n7oka9dWoHx9J5ziOSJE6bhk-di_3tTuaqHi4-7q92Le-LWdt_rT0TbzcWYCt4TMXhD4xykZLhg4kuyf2_0IXVMuQ?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"Sumif l\u00e0 h\u00e0m g\u00ec? H\u00e0m Sumif trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?\n\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>Sumif l\u00e0 h\u00e0m g\u00ec? H\u00e0m Sumif trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/em><\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_ham_Sumif_trong_Excel\"><\/span><strong>C\u00fa ph\u00e1p h\u00e0m Sumif trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Sumif, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ph\u1ea3i nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p sau:<\/p>\n\n\n\n<p>=SUMIF (range; criteria; sum_range)<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfRgHURURROI9OwyJLFwZTMlPRiKXZZJBbu-N5YRbdYsGU-_6pbvbzATLUwnM1X4qrdJ9gX4l4axQ3zjFXLZNtm6-xjhQT_PvlKrfN8s3E8uAKVBXaJOe8GCZLFuHBsmjD-1000yhPL5SXbn2oAYnaEr7Mz?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"C\u00fa ph\u00e1p h\u00e0m Sumif trong Excel\n\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>C\u00fa ph\u00e1p h\u00e0m Sumif trong Excel<\/em><\/figcaption><\/figure>\n\n\n\n<p>C\u00fa ph\u00e1p h\u00e0m Sumif trong Excel bao g\u1ed3m c\u00e1c \u0111\u1ed1i s\u1ed1 sau:<\/p>\n\n\n\n<ul>\n<li><strong>Range<\/strong>: V\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn c\u00f3 ch\u1ee9a c\u00e1c \u00f4 \u0111i\u1ec1u ki\u1ec7n. L\u01b0u \u00fd c\u00e1c \u00f4 trong ph\u1ea1m vi ph\u1ea3i l\u00e0 s\u1ed1, t\u00ean, m\u1ea3ng hay tham chi\u1ebfu ch\u1ee9a s\u1ed1. C\u00e1c gi\u00e1 tr\u1ecb tr\u1ed1ng v\u00e0 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n s\u1ebd b\u1ecb b\u1ecf qua.\u00a0<\/li>\n\n\n\n<li><strong>Criteria: <\/strong>\u0110i\u1ec1u ki\u1ec7n th\u1ef1c hi\u1ec7n h\u00e0m. \u0110i\u1ec1u ki\u1ec7n \u1edf d\u1ea1ng s\u1ed1, bi\u1ec3u th\u1ee9c, tham chi\u1ebfu \u00f4, v\u0103n b\u1ea3n ho\u1eb7c h\u00e0m x\u00e1c \u0111\u1ecbnh s\u1ebd c\u1ed9ng c\u00e1c \u00f4 n\u00e0o. K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c bao g\u1ed3m d\u1ea5u ch\u1ea5m h\u1ecfi (?) \u0111\u1ec3 kh\u1edbp v\u1edbi b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 \u0111\u01a1n n\u00e0o, d\u1ea5u sao (*) \u0111\u1ec3 kh\u1edbp v\u1edbi b\u1ea5t k\u1ef3 chu\u1ed7i k\u00fd t\u1ef1 n\u00e0o. N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm m\u1ed9t d\u1ea5u ch\u1ea5m h\u1ecfi hay d\u1ea5u sao th\u1ef1c s\u1ef1, h\u00e3y g\u00f5 d\u1ea5u ng\u00e3 (~) tr\u01b0\u1edbc k\u00fd t\u1ef1.<\/li>\n\n\n\n<li><strong>Sum_range: <\/strong>V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u00ednh t\u1ed5ng. \u00d4 Sum_range b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn \u0111i\u1ec1n ho\u1eb7c kh\u00f4ng. N\u1ebfu kh\u00f4ng \u0111i\u1ec1n, Excel s\u1ebd m\u1eb7c \u0111\u1ecbnh c\u1ed9ng c\u00e1c \u00f4 trong \u0111\u1ed1i s\u1ed1 Range. Ch\u00fa \u00fd sum_range ph\u1ea3i c\u00f9ng k\u00edch c\u1ee1 v\u00e0 h\u00ecnh d\u1ea1ng v\u1edbi d\u1ea3i \u00f4. Ng\u01b0\u1ee3c l\u1ea1i n\u1ebfu kh\u00f4ng c\u00f9ng k\u00edch c\u1ee1 v\u00e0 h\u00ecnh d\u1ea1ng, hi\u1ec7u su\u1ea5t c\u00f3 th\u1ec3 b\u1ecb \u1ea3nh h\u01b0\u1edfng v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd t\u00ednh t\u1ed5ng m\u1ed9t ph\u1ea1m vi \u00f4 b\u1eaft \u0111\u1ea7u v\u1edbi \u00f4 \u0111\u1ea7u ti\u00ean trong sum_range nh\u01b0ng c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc v\u1edbi ph\u1ea1m vi.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cach_dung_ham_Sumif_kem_vi_du_minh_hoa\"><\/span><strong>C\u00e1ch d\u00f9ng h\u00e0m Sumif k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch d\u00f9ng h\u00e0m Sumif chi ti\u1ebft m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o \u00e1p d\u1ee5ng v\u00e0o d\u1eef li\u1ec7u t\u00ednh c\u1ee7a m\u00ecnh.<\/p>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 d\u1eef li\u1ec7u doanh s\u1ed1 s\u1ea3n ph\u1ea9m c\u1ee7a c\u00f4ng ty m\u1ef9 ph\u1ea9m A trong n\u0103m 2024 nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdMJfeOQtg1D6V7RH7ElBrql9uEEi6WTRoA42XJqCao7THdeRIMIPbtdALvK249OG58yrOMOY0mrvY_JJOvXrEETq3zeA9GShv63CvHUM-YT_QtZIwln40T9tnuVPyK2Xs4xSYHXhPeec_MM3AOmSQvyRjl?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"D\u1eef li\u1ec7u doanh s\u1ed1 s\u1ea3n ph\u1ea9m c\u1ee7a c\u00f4ng ty m\u1ef9 ph\u1ea9m A n\u0103m 2024\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>D\u1eef li\u1ec7u doanh s\u1ed1 s\u1ea3n ph\u1ea9m c\u1ee7a c\u00f4ng ty m\u1ef9 ph\u1ea9m A n\u0103m 2024<\/em><\/figcaption><\/figure>\n\n\n\n<p>V\u00ed d\u1ee5 1: T\u00ednh t\u1ed5ng nh\u1eefng s\u1ea3n ph\u1ea9m Qu\u00fd 1 c\u00f3 t\u1ea1i nhi\u1ec1u h\u01a1n 50 chi nh\u00e1nh<\/p>\n\n\n\n<ul>\n<li><strong>Range:<\/strong> ph\u1ea1m vi ch\u1ee9a \u201cS\u1ed1 chi nh\u00e1nh b\u00e1n\u201d, t\u1ee9c l\u00e0 t\u1eeb F2:F7<\/li>\n\n\n\n<li><strong>Criteria: <\/strong>&gt; 50. L\u01b0u \u00fd do c\u00f3 t\u1ed3n t\u1ea1i k\u00fd hi\u1ec7u to\u00e1n h\u1ecdc n\u00ean ph\u1ea3i vi\u1ebft \u201c&gt; 50\u201d\u00a0<\/li>\n\n\n\n<li><strong>Sum_range:<\/strong> To\u00e0n b\u1ed9 ph\u1ea1m vi c\u1ea7n t\u00ednh t\u1ed5ng. Trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 to\u00e0n b\u1ed9 c\u1ed9t qu\u00fd 1, t\u1ee9c l\u00e0 B2:B7<\/li>\n<\/ul>\n\n\n\n<p>T\u1ea1i \u00f4 H9 nh\u1eadp c\u00f4ng th\u1ee9c =SUMIF(F2:F7,&#8221;&gt;50&#8243;,B2:B7) r\u1ed3i nh\u1ea5n Enter<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXes4qgxWneIH1u0Kijsge9mK9f90iCYlbJvKw7Jf0JuRXjsyhOAfs6A4R_KuWvh7Bm2FBEs5wPQDeI3HAn8BZxTBomhJI5PQhBYd46M960ABZ4AIWcaD22hgh35jchQmulaDVuG14YsS_1M7tESpPezQkc?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"T\u1ea1i \u00f4 H9 nh\u1eadp c\u00f4ng th\u1ee9c SUMIF(F2:F7,&quot;&gt;50&quot;,B2:B7) r\u1ed3i nh\u1ea5n Enter\n\" title=\"\"><figcaption class=\"wp-element-caption\"><em>T\u1ea1i \u00f4 H9 nh\u1eadp c\u00f4ng th\u1ee9c =SUMIF(F2:F7,&#8221;&gt;50&#8243;,B2:B7) r\u1ed3i nh\u1ea5n Enter<\/em><\/figcaption><\/figure>\n\n\n\n<p>V\u00ed d\u1ee5 2: S\u1eed d\u1ee5ng b\u1ea3ng s\u1ed1 li\u1ec7u tr\u00ean, t\u00ednh t\u1ed5ng s\u1ed1 chi nh\u00e1nh b\u00e1n c\u00f3 s\u1ed1 s\u1ea3n ph\u1ea9m Qu\u00fd 3 b\u1eb1ng 30<\/p>\n\n\n\n<ul>\n<li><strong>Range: <\/strong>Ph\u1ea1m vi c\u1ed9t Qu\u00fd 3, t\u1ee9c l\u00e0 D2:D7<\/li>\n\n\n\n<li><strong>Criteria:<\/strong> \u0110i\u1ec1u ki\u1ec7n y\u00eau c\u1ea7u b\u1eb1ng 30, nh\u1eadp v\u00e0o h\u00e0m \u201c30\u201d<\/li>\n\n\n\n<li><strong>Sum_range:<\/strong> Ph\u1ea1m vi c\u1ed9t ch\u1ee9a s\u1ed1 chi nh\u00e1nh b\u00e1n c\u1ea7n t\u00ednh t\u1ed5ng, t\u1ee9c l\u00e0 F2:F7<\/li>\n<\/ul>\n\n\n\n<p>T\u1ea1i \u00f4 H10, nh\u1eadp c\u00f4ng th\u1ee9c =SUMIF(D2:D7,&#8221;=30&#8243;,F2:F6) r\u1ed3i nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfpe_50qF5dsl1C9cpzCQqhpDEC9ueNsMhCUTgeJLe5cWkeuq6EpGfi2Ca3nA68JM4vhnLCwneVffOmz2dCiAVoQbqR3nP6JZg9fqJOfrtZkFzboX09um_Z02w_OjFgMAd6VxeGd113RY3sF1sWx77dNQrK?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"T\u1ea1i \u00f4 H10, nh\u1eadp c\u00f4ng th\u1ee9c SUMIF(D2:D7,&quot;=30&quot;,F2:F6) r\u1ed3i nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3\n\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>T\u1ea1i \u00f4 H10, nh\u1eadp c\u00f4ng th\u1ee9c =SUMIF(D2:D7,&#8221;=30&#8243;,F2:F6) r\u1ed3i nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3<\/em><\/figcaption><\/figure>\n\n\n\n<p>V\u00ed d\u1ee5 3: Ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng b\u1ea3ng s\u1ed1 li\u1ec7u tr\u00ean, t\u00ednh t\u1ed5ng gi\u00e1 ti\u1ec1n t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m c\u00f3 gi\u00e1 tr\u00ean 250<\/p>\n\n\n\n<ul>\n<li><strong>Range:<\/strong> Ph\u1ea1m vi c\u1ed9t th\u00e0nh ti\u1ec1n, t\u1ee9c l\u00e0 G2:G7<\/li>\n\n\n\n<li><strong>Criteria:<\/strong> Gi\u00e1 ti\u1ec1n s\u1ea3n ph\u1ea9m tr\u00ean 250, nh\u1eadp \u201c&gt;250\u201d<\/li>\n\n\n\n<li><strong>Sum_range:<\/strong> B\u1ecf tr\u1ed1ng, Excel s\u1ebd m\u1eb7c \u0111\u1ecbnh t\u00ednh theo c\u1ed9t Range<\/li>\n<\/ul>\n\n\n\n<p>T\u1ea1i \u00f4 H11, nh\u1eadp c\u00f4ng th\u1ee9c =SUMIF(G2:G7,&#8221;&gt;250&#8243;) r\u1ed3i nh\u1ea5n Enter&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcV_Sr8BG8J7N_SmyTymosnBMmqVgl0-knISOSG5fN13Blmf4Izzrhsh4wnZdErdgIyQlsXs4qGSawG6EsPa6NwNl0SrarrwukI0v7APtS_9qrYlo8fpyDUKqIbODsv4mlfbw5EVrOQr_tbRPFZJzmO9P0E?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"T\u1ea1i \u00f4 H11, nh\u1eadp c\u00f4ng th\u1ee9c =SUMIF(G2:G7,&quot;&gt;250&quot;) r\u1ed3i nh\u1ea5n Enter \n\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>T\u1ea1i \u00f4 H11, nh\u1eadp c\u00f4ng th\u1ee9c =SUMIF(G2:G7,&#8221;&gt;250&#8243;) r\u1ed3i nh\u1ea5n Enter&nbsp;<\/em><\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Can_luu_y_gi_khi_dung_ham_Sumif\"><\/span><strong>C\u1ea7n l\u01b0u \u00fd g\u00ec khi d\u00f9ng h\u00e0m Sumif<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, h\u00e0m SUMIF l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c gi\u00fap t\u00ednh to\u00e1n t\u1ed5ng nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c. Tuy nhi\u00ean, \u0111\u1ec3 khai th\u00e1c t\u1ed1i \u0111a hi\u1ec7u qu\u1ea3 c\u1ee7a h\u00e0m n\u00e0y c\u1ea7n n\u1eafm r\u00f5 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n\n\n\n<ul>\n<li>N\u1ebfu kh\u00f4ng \u0111i\u1ec1n d\u1eef li\u1ec7u v\u00e0o h\u00e0m sum_range, Excel s\u1ebd m\u1eb7c \u0111\u1ecbnh t\u00ednh t\u1ed5ng theo range<\/li>\n\n\n\n<li>\u0110i\u1ec1u ki\u1ec7n c\u00f3 ch\u1ee9a ch\u1eef ho\u1eb7c c\u00e1c k\u00fd t\u1ef1 to\u00e1n h\u1ecdc nh\u01b0 &gt;, &lt; ,=,&#8230; \u0111\u1ec1u ph\u1ea3i \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p \u201c.\u201d<\/li>\n\n\n\n<li>Ph\u1ea1m vi x\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c cung c\u1ea5p l\u00e0 s\u1ed1 s\u1ebd kh\u00f4ng ph\u1ea3i d\u00f9ng \u0111\u1ebfn d\u1ea5u ngo\u1eb7c<\/li>\n\n\n\n<li>K\u1ebft qu\u1ea3 h\u00e0m Sumif tr\u1ea3 v\u1ec1 s\u1ebd kh\u00f4ng ch\u00ednh x\u00e1c n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c chu\u1ed7i d\u00e0i h\u01a1n 255 k\u00fd t\u1ef1 ho\u1eb7c v\u1edbi chu\u1ed7i #VALUE!<\/li>\n\n\n\n<li>Sumif kh\u00f4ng ph\u00e2n bi\u1ec7t k\u00fd t\u1ef1 vi\u1ebft hoa<\/li>\n\n\n\n<li>Sumif c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 SUM, AVERAGE, COUNT \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p h\u01a1n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfKvpFGsyLaJU04V0shDOPt_HXuDqOAVNDQRDBGdpfxxS4FlnanARkVZ_8IbZAGxgeWRoc4EQZH-qn8LkCZu74XMkU2MD8l8nFNX5G7MkccNY92vmbTXlo9oXrSy6Ldio7OIMgGwyxsuRL5lNR_smAproE?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel<\/em><\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Phan_biet_ham_Sumif_va_Sumifs_trong_Excel\"><\/span><strong>Ph\u00e2n bi\u1ec7t h\u00e0m Sumif v\u00e0 Sumifs trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sumif v\u00e0 Sumifs \u0111\u1ec1u l\u00e0 hai h\u00e0m t\u00ednh t\u1ed5ng h\u1eefu \u00edch trong Excel. Ch\u00fang \u0111\u1ec1u \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1ef1a tr\u00ean m\u1ed9t hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau. Tuy nhi\u00ean, Sumif v\u00e0 Sumifs c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec3m kh\u00e1c bi\u1ec7t m\u00e0 b\u1ea1n c\u1ea7n l\u01b0u \u00fd \u0111\u1ec3 tr\u00e1nh ch\u1ecdn nh\u1ea7m h\u00e0m khi s\u1eed d\u1ee5ng.<\/p>\n\n\n\n<ul>\n<li><strong>H\u00e0m Sumif: <\/strong>d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t. C\u00fa ph\u00e1p: SUMIF(range,criteria, sum_range)<\/li>\n\n\n\n<li><strong>H\u00e0m Sumifs:<\/strong> t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. C\u00fa ph\u00e1p SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], &#8230;)<\/li>\n<\/ul>\n\n\n\n<p>Nh\u01b0 v\u1eady c\u00f3 th\u1ec3 th\u1ea5y h\u00e0m Sumifs s\u1ebd c\u00f3 \u0111\u1ed9 ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0ng c\u0169ng linh ho\u1ea1t h\u01a1n. Vi\u1ec7c l\u1ef1a ch\u1ecdn h\u00e0m Sumif hay Sumifs ph\u1ee5 thu\u1ed9c v\u00e0o y\u00eau c\u1ea7u c\u1ee7a b\u00e0i to\u00e1n.<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfAVm6w2vHLUGHWAn7dL-G1SzkYiE5Y4-FG55thWqcQX41MI39NcHaRxHfRBbznki9Pz-ykGt62Jl5IzHcxFTXtV0EJxmCiUhU_9YDaLY6iylPkIXNc4KSRqAskiCGiStingEjhPHSRr57bmDXnhb3oDHI?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"Ph\u00e2n bi\u1ec7t h\u00e0m Sumif v\u00e0 Sumifs trong Excel\n\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>Ph\u00e2n bi\u1ec7t h\u00e0m Sumif v\u00e0 Sumifs trong Excel<\/em><\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_cau_hoi_thuong_gap_ve_ham_Sumif_trong_Excel\"><\/span><strong>M\u1ed9t s\u1ed1 c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m Sumif trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m Sumif l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong Excel. Tuy nhi\u00ean v\u1edbi nh\u1eefng ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u l\u00e0m quen s\u1ebd g\u1eb7p ph\u1ea3i m\u1ed9t s\u1ed1 c\u00e2u h\u1ecfi. D\u01b0\u1edbi \u0111\u00e2y Phong V\u0169 Tech News s\u1ebd gi\u1ea3i \u0111\u00e1p nh\u1eefng th\u1eafc m\u1eafc th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m Sumif trong Excel, gi\u00fap b\u1ea1n t\u1ef1 tin h\u01a1n trong vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"SUMIF_co_the_su_dung_voi_du_lieu_dang_Text_khong\"><\/span><strong>SUMIF c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng Text kh\u00f4ng?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m SUMIF r\u1ea5t linh ho\u1ea1t v\u00e0 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean nhi\u1ec1u lo\u1ea1i ti\u00eau ch\u00ed kh\u00e1c nhau. Do \u0111\u00f3 SUMIF ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng Text trong Excel. Tuy nhi\u00ean khi nh\u1eadp c\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIF, \u0111\u1eebng qu\u00ean \u0111\u1eb7t chu\u1ed7i v\u0103n b\u1ea3n trong d\u1ea5u ngo\u1eb7c k\u00e9p \u0111\u1ec3 Excel hi\u1ec3u \u0111\u00f3 l\u00e0 m\u1ed9t d\u1eef li\u1ec7u d\u1ea1ng Text.<\/p>\n\n\n\n<p>V\u00ed d\u1ee5 gi\u1ea3 s\u1eed&nbsp; b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u b\u00e1n h\u00e0ng v\u1edbi c\u00e1c c\u1ed9t: S\u1ea3n ph\u1ea9m, S\u1ed1 l\u01b0\u1ee3ng, v\u00e0 Gi\u00e1 b\u00e1n. B\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng th\u00e0nh ti\u1ec1n m\u00e3 s\u1ea3n ph\u1ea9m &#8220;SRM&#8221;. C\u00f4ng th\u1ee9c SUMIF s\u1ebd l\u00e0: =SUMIF(A2:A7, \u201cSRM\u201d,G2:G7)<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcUPaNWBvkfLjkRdL3w0Wf9Y6arb2m2Q5BFbDCJJU3p0rLoWBRhQOhoVmDduBnjowWZEMW2GK_Mh1baBqUZ8tryDNfhICiVv-AiCUHhgKgC9BY31MTsql-0vB2Vg95Zx1fExjSwGFATo-mXyawvpXsMqs0?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"SUMIF c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng Text kh\u00f4ng?\n\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>SUMIF c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng Text kh\u00f4ng?<\/em><\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Lam_sao_de_su_dung_SUMIF_voi_nhieu_dieu_kien\"><\/span><strong>L\u00e0m sao \u0111\u1ec3 s\u1eed d\u1ee5ng SUMIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Tr\u01b0\u1eddng h\u1ee3p mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau, h\u00e0m SUMIF \u0111\u01a1n thu\u1ea7n s\u1ebd kh\u00f4ng \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c. L\u00fac n\u00e0y b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. SUMIFS cho ph\u00e9p b\u1ea1n \u0111\u1eb7t nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac, gi\u00fap b\u1ea1n ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch chi ti\u1ebft h\u01a1n.&nbsp;<\/p>\n\n\n\n<p><strong>C\u00fa ph\u00e1p: <\/strong>=Sumif(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], \u2026)<\/p>\n\n\n\n<p>V\u00ed d\u1ee5 gi\u1ea3 s\u1eed&nbsp; b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u b\u00e1n h\u00e0ng v\u1edbi c\u00e1c c\u1ed9t: S\u1ea3n ph\u1ea9m, Khu v\u1ef1c, Doanh s\u1ed1. B\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng doanh s\u1ed1 c\u1ee7a s\u1ea3n ph\u1ea9m &#8220;B\u00fat&#8221; t\u1ea1i khu v\u1ef1c &#8220;H\u00e0 N\u1ed9i&#8221;. L\u00fac n\u00e0y b\u1ea1n c\u1ea7n nh\u1eadp h\u00e0m theo c\u00fa ph\u00e1p =SUMIFS(ph\u1ea1m vi ch\u1ee9a doanh s\u1ed1, ph\u1ea1m vi ch\u1ee9a t\u00ean s\u1ea3n ph\u1ea9m, &#8220;B\u00fat&#8221;, ph\u1ea1m vi ch\u1ee9a khu v\u1ef1c, &#8220;H\u00e0 N\u1ed9i&#8221;)<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdgTDPs7xRtWK8woirBuyykmHAoUv6PV0r1U_5Yx6QdrXDfP9aJvxOAO6Kx0epm2EpBV9mh2szz6I0u35aQ-JNr-sx9FpTuShXheJcTTYYlVhYkAILoej3Y4A80wmlt-ncCf4kezrKmIxOWFbr7ByNXRjt1?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"S\u1eed d\u1ee5ng h\u00e0m SUMIFS n\u1ebfu b\u00e0i to\u00e1n c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" title=\"\"><figcaption class=\"wp-element-caption\"><em>S\u1eed d\u1ee5ng h\u00e0m SUMIFS n\u1ebfu b\u00e0i to\u00e1n c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/em><\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Cach_khac_phuc_khi_ham_SUMIF_khong_hoat_dong\"><\/span><strong>C\u00e1ch kh\u1eafc ph\u1ee5c khi h\u00e0m SUMIF kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u0110\u00f4i khi h\u00e0m SUMIF c\u00f3 th\u1ec3 kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng nh\u01b0 mong \u0111\u1ee3i do sai c\u00fa ph\u00e1p, l\u1ed7i \u0111\u1ecbnh d\u1ea1ng, ti\u00eau ch\u00ed, l\u1ed7i ph\u1ea1m vi\u2026 B\u00ean c\u1ea1nh \u0111\u00f3 c\u00f2n c\u00f3 nguy\u00ean nh\u00e2n kh\u00e1c l\u00e0 do l\u1ed7i #VALUE!, ngh\u0129a l\u00e0 d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7 ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 kh\u00f4ng t\u1ed3n t\u1ea1i. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n c\u00f3 th\u1ec3 th\u1eed \u00e1p d\u1ee5ng c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n<ul>\n<li>Ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c, \u0111\u1ea3m b\u1ea3o kh\u00f4ng c\u00f3 l\u1ed7i \u0111\u00e1nh m\u00e1y hay sai c\u00fa ph\u00e1p<\/li>\n\n\n\n<li>Nh\u1ea5n F9 \u0111\u1ec3 ki\u1ec3m tra gi\u00e1 tr\u1ecb t\u1eebng ph\u1ea7n trong c\u00f4ng th\u1ee9c<\/li>\n\n\n\n<li>\u0110\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdoF_s8UxSfqMnmiYYuQY-Qivyvd3prAjeTOvPBPYKKbBkDJgahtUjSv66mxlRRS-EY5QghlbybuUujDqWJJEFiQgT_bP497D19E6sSQwQE9dn6qyPsmlW7dZ6GlU8-WRa38i0o5eFhZtKxiptgnwO4BZ8c?key=Jg4SDYt_ly6T6LRR2fWdDKjP\" alt=\"C\u00e1ch kh\u1eafc ph\u1ee5c khi h\u00e0m SUMIF kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng?\n\" width=\"1068\" height=\"667\" title=\"\"><figcaption class=\"wp-element-caption\"><em>C\u00e1ch kh\u1eafc ph\u1ee5c khi h\u00e0m SUMIF kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng?<\/em><\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Tong_ket\"><\/span><strong>T\u1ed5ng k\u1ebft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110\u1ec3 th\u00e0nh th\u1ea1o h\u00e0m SUMIF, c\u00e1ch t\u1ed1t nh\u1ea5t l\u00e0 b\u1ea1n n\u00ean th\u01b0\u1eddng xuy\u00ean luy\u1ec7n t\u1eadp. H\u00e3y th\u1eed \u00e1p d\u1ee5ng h\u00e0m SUMIF v\u00e0o c\u00e1c b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c \u0111\u1ec3 l\u00e0m quen v\u00e0 kh\u00e1m ph\u00e1 th\u00eam nhi\u1ec1u t\u00ednh n\u0103ng th\u00fa v\u1ecb c\u1ee7a n\u00f3. N\u1ebfu g\u1eb7p b\u1ea5t k\u1ef3 kh\u00f3 kh\u0103n n\u00e0o \u0111\u1eebng ng\u1ea7n ng\u1ea1i \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn ph\u00eda d\u01b0\u1edbi \u0111\u1ec3 Phong V\u0169 Tech News c\u00f3 th\u1ec3 gi\u1ea3i \u0111\u00e1p nhanh nh\u1ea5t c\u00f3 th\u1ec3 cho b\u1ea1n nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Sumif l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi \u0111\u00e1p \u1ee9ng x\u00e1c \u0111\u1ecbnh. B\u00e0i vi\u1ebft n\u00e0y Phong V\u0169 Tech News s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF m\u1ed9t c\u00e1ch chi ti\u1ebft, k\u00e8m theo c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf \u0111\u1ec3 b\u1ea1n d\u1ec5 [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":103804,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[24,1029],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/103802"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=103802"}],"version-history":[{"count":3,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/103802\/revisions"}],"predecessor-version":[{"id":104093,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/103802\/revisions\/104093"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/103804"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=103802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=103802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=103802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}