{"id":10154,"date":"2024-01-11T23:42:07","date_gmt":"2024-01-11T16:42:07","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=10154"},"modified":"2024-01-23T14:28:09","modified_gmt":"2024-01-23T07:28:09","slug":"ham-sumifs-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/","title":{"rendered":"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;10154&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;6&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (6 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (6 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><em><span style=\"font-weight: 400;\">Ch\u00fang ta \u0111\u00e3 bi\u1ebft \u0111\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng trong Excel, ph\u1ea3i t\u00ecnh b\u1eb1ng h\u00e0m SUM. V\u1eady c\u00f2n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o? \u0110\u00f3 ch\u00ednh l\u00e0 <strong>h\u00e0m SUMIFS<\/strong>. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1<\/span><b> h\u00e0m SUMIFS trong EXCEL<\/b><span style=\"font-weight: 400;\">, c\u00e1ch d\u00f9ng v\u00e0 nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd khi s\u1eed d\u1ee5ng <strong>h\u00e0m SUMIFS trong Excel<\/strong>, \u0111\u1ec3 t\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n nh\u00e9.<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 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\" style=\"cursor:inherit\">N\u1ed9i dung <\/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\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" 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><\/span><\/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:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Tim_hieu_ve_ham_SUMIFS_trong_Excel\" >T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m SUMIFS trong Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Vay_ham_SUMIFS_la_gi\" >V\u1eady h\u00e0m SUMIFS l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Cach_dung_ham_Sumifs_trong_excel\" >C\u00e1ch d\u00f9ng h\u00e0m Sumifs trong excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Cong_thuc_SUMIFS_voi_toan_ham_tu_so_sanh\" >C\u00f4ng th\u1ee9c SUMIFS v\u1edbi to\u00e1n h\u00e0m t\u1eed so s\u00e1nh:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Su_dung_ham_Sumifs_trong_excel_voi_ngay\" >S\u1eed d\u1ee5ng h\u00e0m Sumifs trong excel v\u1edbi ng\u00e0y:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Cong_thuc_SUMIFS_voi_o_trong_va_khong_trong\" >C\u00f4ng th\u1ee9c SUMIFS v\u1edbi \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Nhung_dieu_can_chu_y_khi_dung_ham_SUMIFS_trong_excel\" >Nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd khi d\u00f9ng h\u00e0m SUMIFS trong excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Tim_Hieu_Teky_Hoc_Vien_Cong_Nghe_Tre_Hang_Dau_Viet_Nam\" >T\u00ecm Hi\u1ec3u Teky H\u1ecdc Vi\u1ec7n C\u00f4ng Ngh\u1ec7 Tr\u1ebb H\u00e0ng \u0110\u1ea7u Vi\u1ec7t Nam<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Day_la_chuong_trinh_khong_chi_trang_bi_kien_thuc_lap_trinh_ma_con_ren_luyen_nhom_ky_nang_4Cs_Tre_se_duoc\" >\u0110\u00e2y l\u00e0 ch\u01b0\u01a1ng tr\u00ecnh kh\u00f4ng ch\u1ec9 trang b\u1ecb ki\u1ebfn th\u1ee9c l\u1eadp tr\u00ecnh m\u00e0 c\u00f2n r\u00e8n luy\u1ec7n nh\u00f3m k\u1ef9 n\u0103ng 4Cs. Tr\u1ebb s\u1ebd \u0111\u01b0\u1ee3c:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#Lien_he_ngay_hoc_vien_cong_nghe_sang_tao_TEKY_de_duoc_tu_van_khoa_hoc\" >Li\u00ean h\u1ec7 ngay h\u1ecdc vi\u1ec7n c\u00f4ng ngh\u1ec7 s\u00e1ng t\u1ea1o TEKY \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n kh\u00f3a h\u1ecdc:<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tim_hieu_ve_ham_SUMIFS_trong_Excel\"><\/span><span style=\"font-weight: 400;\">T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m SUMIFS trong Excel?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi t\u00ecm hi\u1ec3u v\u1ec1 <strong>h\u00e0m Sumifs trong excel<\/strong>, m\u00ecnh s\u1ebd gi\u1edbi thi\u1ec7u m\u1ed9t ch\u00fat v\u1ec1 ph\u1ea7n m\u1ec1m Excel. Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh c\u1ee7a Microsoft Office. Excel gi\u00fap l\u01b0u d\u1eef li\u1ec7u, t\u00ednh to\u00e1n, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u, h\u1ed7 tr\u1ee3 c\u00e1c c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch, t\u00ecm ki\u1ebfm,&#8230;Ph\u00f9 h\u1ee3p cho nh\u1eefng \u0111\u1ed1i t\u01b0\u1ee3ng so\u1ea1n th\u1ea3o t\u00e0i li\u1ec7u, t\u00ednh to\u00e1n c\u00e1c con s\u1ed1, ph\u00e2n t\u00edch d\u1eef li\u1ec7u cho ph\u00e9p b\u1ea1n t\u00ednh to\u00e1n nhanh ch\u00f3ng m\u00e0 ko c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ebfn m\u00e1y t\u00ednh hay b\u1ea5t k\u00ec thi\u1ebft b\u1ecb n\u00e0o kh\u00e1c h\u1ed7 tr\u1ee3 t\u00ednh to\u00e1n. C\u00f3 r\u1ea5t nhi\u1ec1u lo\u1ea1i h\u00e0m t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. Tuy nhi\u00ean, trong b\u00e0i vi\u1ebft n\u00e0y, m\u00ecnh s\u1ebd gi\u1edbi thi\u1ec7u cho c\u00e1c b\u1ea1n v\u1ec1 <\/span><b>h\u00e0m SUMIFS trong EXCEL\u00a0<\/b><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vay_ham_SUMIFS_la_gi\"><\/span><span style=\"font-weight: 400;\">V\u1eady h\u00e0m SUMIFS l\u00e0 g\u00ec?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\"><strong>H\u00e0m SUMIFS<\/strong> l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c gh\u00e9p t\u1eeb h\u00e0m SUM v\u00e0 h\u00e0m IFS. Cho n\u00ean h\u00e0m SUMIFS c\u00f3 ch\u1ee9c n\u0103ng t\u00ednh t\u1ed5ng v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng m\u1ed9t l\u00fac.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p trong h\u00e0m SUMIFS \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau: \u201c=SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,\u2026)\u201d<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">sum_range: ph\u1ea1m vi \u00f4 c\u1ea7n th\u1ef1c hi\u1ec7n \u0111\u1ec3 t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u. C\u00f3 th\u1ec3 l\u00e0 m\u1ed9t \u00f4 ho\u1eb7c nhi\u1ec1u \u00f4. Ph\u1ea7n m\u1ec1m s\u1ebd ch\u1ec9 l\u1ecdc \u0111\u1ec3 t\u00ednh t\u1ed5ng nh\u1eefng \u00f4 c\u00f3 d\u1eef li\u1ec7u<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">criteria_range1: ph\u1ea1m vi \u00f4 t\u00ednh th\u1ee9 nh\u1ea5t \u0111\u1ec3 \u00e1p d\u1ee5ng theo \u0111i\u1ec1u ki\u1ec7n s\u1ed1 1<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">criteria1: \u0111i\u1ec1u ki\u1ec7n s\u1ed1 1 c\u1ea7n \u0111\u00e1p \u1ee9ng. C\u00f3 th\u1ec3 l\u00e0 s\u1ed1, \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng v\u0103n b\u1ea3n, tham s\u1ed1,&#8230;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">criteria_range2, criteria2,&#8230;: ph\u1ea1m vi \u00f4 t\u00ednh th\u1ee9 hai v\u00e0 \u0111i\u1ec1u ki\u1ec7n s\u1ed1 2<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Gi\u1edbi h\u1ea1n t\u1ed1i \u0111a l\u00e0 127 cho ph\u1ea1m vi v\u00e0 \u0111i\u1ec1u ki\u1ec7n. Trong h\u00e0m SUMIFS, sum_range r\u1ea5t quan tr\u1ecdng v\u00e0 l\u00e0 b\u1eaft bu\u1ed9c. \u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao n\u00f3 \u0111\u1ee9ng tr\u01b0\u1edbc. T\u00f3m l\u1ea1i, h\u00e3y \u0111\u1ea3m b\u1ea3o \u0111\u1eb7t th\u00f4ng s\u1ed1 theo \u0111\u00fang th\u1ee9 t\u1ef1 nh\u00e9.<\/span><\/p>\n<p>&gt;&gt;&gt; Xem th\u00eam : <a href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot; S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16185335},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\"> S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a<\/span><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Trong h\u00e0m SUMIFS, m\u1ed7i \u201ccriteria_range\u201d ph\u1ea3i ch\u1ee9a c\u00f9ng m\u1ed9t s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t nh\u01b0 tham s\u1ed1 \u201csum_range\u201d.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 1:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">= SUMIF (A5: A13, F1, C5: C13)\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">s\u1ebd cho ra k\u1ebft qu\u1ea3 \u0111\u00fang v\u00ec Excel ch\u1ec9 xem \u00f4 ph\u00eda b\u00ean tr\u00e1i trong \u0111\u1ed1i s\u1ed1 sum_range v\u00e0 sau \u0111\u00f3 \u0111\u1ed1i chi\u1ebfu s\u1ed1 c\u1ed9t v\u00e0 h\u00e0ng, gi\u1ed1ng nh\u01b0 k\u00edch th\u01b0\u1edbc c\u1ee7a \u0111\u1ed1i s\u1ed1 range gi\u1ed1ng nh\u01b0 trong c\u00f4ng th\u1ee9c.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 2:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">= SUMIFS (A5: A13, C5:C13, F1, B5: B10, F5)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">S\u1ebd b\u00e1o l\u1ed7i #VALUE! v\u00ec criter_range2 (B5: B10) kh\u00f4ng kh\u1edbp v\u1edbi criteria_range1 (A5: A13) v\u00e0 sum_range (C5: C13).<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dung_ham_Sumifs_trong_excel\"><\/span><span style=\"font-weight: 400;\">C\u00e1ch d\u00f9ng h\u00e0m Sumifs trong excel\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u1ede ph\u1ea7n tr\u00ean, ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u qua v\u1ec1 <\/span><b>h\u00e0m sumifs trong excel<\/b><span style=\"font-weight: 400;\">. Gi\u1edd ch\u00fang ta c\u00f9ng \u0111\u1ebfn v\u1edbi c\u00e1ch d\u00f9ng h\u00e0m sumifs nh\u00e9.\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_SUMIFS_voi_toan_ham_tu_so_sanh\"><\/span><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c SUMIFS v\u1edbi to\u00e1n h\u00e0m t\u1eed so s\u00e1nh:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ol>\n<figure id=\"attachment_10155\" aria-describedby=\"caption-attachment-10155\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10155\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Cong-thuc-SUMIFS-voi-toan-ham-tu-so-sanh.jpg\" alt=\"C\u00f4ng th\u1ee9c SUMIFS v\u1edbi to\u00e1n h\u00e0m t\u1eed so s\u00e1nh\" width=\"600\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Cong-thuc-SUMIFS-voi-toan-ham-tu-so-sanh.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Cong-thuc-SUMIFS-voi-toan-ham-tu-so-sanh-400x300.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-10155\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c SUMIFS v\u1edbi to\u00e1n h\u00e0m t\u1eed so s\u00e1nh<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Mu\u1ed1n t\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 tr\u00e1i c\u00e2y \u0111\u01b0\u1ee3c Mike cung c\u1ea5p v\u1edbi s\u1ed1 l\u01b0\u1ee3ng t\u1eeb 200 tr\u1edf l\u00ean. B\u1ea1n s\u1eed d\u1ee5ng to\u00e1n t\u1eed so s\u00e1nh \u201cl\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng\u201d (&gt; =) trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n 2 v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">= SUMIFS (C2: C9, B2: B9, \u201cMike\u201d, C2: C9, \u201c&gt; = 200\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: trong c\u00e1c c\u00f4ng th\u1ee9c SUMIFS, c\u00e1c bi\u1ec3u th\u1ee9c to\u00e1n t\u1eed so s\u00e1nh ph\u1ea3i lu\u00f4n lu\u00f4n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p (\u201c\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: ch\u00fang ta mu\u1ed1n t\u00ecm s\u1ed1 tr\u00e1i c\u00e2y \u0111\u01b0\u1ee3c Mike cung c\u1ea5p l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 200 v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 300. Ta vi\u1ebft c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">= SUMIFS (C2: C9, C2: C9, \u201c&gt; = 200\u201d, C2: C9, \u201c&lt;= 300\u201d)<\/span><\/p>\n<p>&gt;&gt;&gt; Xem th\u00eam : <a href=\"https:\/\/teky.edu.vn\/blog\/hinh-nen-powerpoint-dep\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot; H\u01b0\u1edbng d\u1eabn t\u1ea1o h\u00ecnh n\u1ec1n Powerpoint \u0111\u1eb9p cho b\u00e0i thuy\u1ebft tr\u00ecnh&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\"> H\u01b0\u1edbng d\u1eabn t\u1ea1o h\u00ecnh n\u1ec1n Powerpoint \u0111\u1eb9p cho b\u00e0i thuy\u1ebft tr\u00ecnh<\/span><\/a><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_Sumifs_trong_excel_voi_ngay\"><\/span><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m Sumifs trong excel v\u1edbi ng\u00e0y:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ol>\n<figure id=\"attachment_10156\" aria-describedby=\"caption-attachment-10156\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10156\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Su-dung-ham-Sumifs-trong-excel-voi-ngay.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m Sumifs trong excel v\u1edbi ng\u00e0y\" width=\"600\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Su-dung-ham-Sumifs-trong-excel-voi-ngay.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Su-dung-ham-Sumifs-trong-excel-voi-ngay-400x300.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-10156\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Sumifs trong excel v\u1edbi ng\u00e0y<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u1edbi \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m TODAY (). C\u00f4ng th\u1ee9c sau \u0111\u00e2y t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong c\u1ed9t D v\u00e0 c\u1ed9t C r\u01a1i v\u00e0o kho\u1ea3ng th\u1eddi gian 7 ng\u00e0y v\u1eeba qua, c\u00f3 bao g\u1ed3m ng\u00e0y h\u00f4m nay:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">= SUMIFS (D2: D10, C2: C10, \u201c&gt; =\u201d &amp; TODAY SUMIFS() \u2013 7, C2: C10, \u201c&lt;=\u201d &amp; TODAY ())<\/span><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: Khi s\u1eed d\u1ee5ng v\u1edbi m\u1ed9t h\u00e0m kh\u00e1c c\u00f9ng v\u1edbi to\u00e1n t\u1eed \u0111i\u1ec1u ki\u1ec7n, c\u1ea7n s\u1eed d\u1ee5ng th\u00eam k\u00fd hi\u1ec7u d\u1ea5u \u201c&amp;\u201d \u0111\u1ec3 n\u1ed1i v\u1edbi 1 chu\u1ed7i, v\u00ed d\u1ee5: \u201c&lt;=\u2019 &amp; TODAY ().<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_SUMIFS_voi_o_trong_va_khong_trong\"><\/span><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c SUMIFS v\u1edbi \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 ph\u00e2n t\u00edch b\u00e1o c\u00e1o v\u00e0 d\u1eef li\u1ec7u kh\u00e1c nhau, c\u1ea7n ph\u1ea3i t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u00f4 tr\u1ed1ng ho\u1eb7c \u00f4 kh\u00f4ng tr\u1ed1ng.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi nh\u1eefng \u00f4 tr\u1ed1ng, ta s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n \u201c=\u201d:\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u1edbi nh\u1eefng \u00f4 tr\u1ed1ng t\u01b0\u01a1ng \u1ee9ng . Cho ra c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n nh\u01b0 sau: =SUMIFS(C2:C10, A2:A10, \u201c=\u201d, B2:B10)<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V\u1edbi \u00f4 kh\u00f4ng tr\u1ed1ng, ta s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n \u201c&lt;&gt;\u201d:<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">=SUMIFS(C2:C10, A2:A10, \u201c&lt;&gt;\u201d, B2:B10, \u201c&lt;&gt;\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong c\u1ea3 2 \u0111i\u1ec1u ki\u1ec7n tr\u00ean, ch\u00fang ta \u0111\u1ec1u c\u00f3 th\u1ec3 thay th\u1ebf \u201c&lt;&gt;\u201d v\u00e0 \u201c=\u201d th\u00e0nh \u201c\u201d<\/span><\/p>\n<p><span style=\"font-weight: 400;\">T\u1eeb 2 c\u00f4ng th\u1ee9c tr\u00ean, ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u1ea3 2 c\u00f4ng th\u1ee9c c\u00f9ng 1 l\u00fac \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb c\u1ee7a 1 \u00f4 r\u1ed7ng v\u1edbi 1 \u00f4 kh\u00f4ng r\u1ed7ng:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=SUMIFS(D2:D10, B2:B10, \u201c&lt;&gt;\u201d, C2:C10, \u201c=\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Qua nh\u1eefng c\u00e1ch t\u00ednh tr\u00ean, b\u1ea1n l\u1ea1i c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng h\u00f3a d\u1ef1a v\u00e0o h\u00e0m SUMIFS trong excel r\u1ed3i nh\u00e9.<\/span><\/p>\n<p><em><strong>&gt;&gt; Xem th\u00eam:<\/strong> <a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel-2\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Sumifs trong Excel &#8211; Gi\u1ea3i \u0111\u00e1p c\u00e1ch d\u00f9ng ch\u00ednh x\u00e1c nh\u1ea5t<\/a><\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_dieu_can_chu_y_khi_dung_ham_SUMIFS_trong_excel\"><\/span><span style=\"font-weight: 400;\">Nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd khi d\u00f9ng h\u00e0m SUMIFS trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V\u1edbi h\u00e0m SUMIFS, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam t\u1ed1i \u0111a 127 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t l\u1ea7n. Tuy nhi\u00ean,c\u00e0ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00e0ng d\u1ec5 sai s\u00f3t, v\u00ec th\u1ebf c\u00e1c b\u1ea1n n\u00ean c\u1ed1 g\u1eafng vi\u1ebft ng\u1eafn g\u1ecdn.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ebfu c\u00f3 \u00f4 tr\u1ed1ng trong c\u00e1c d\u00e3y \u0111i\u1ec1u ki\u1ec7n(criteria range), Excel s\u1ebd ra k\u1ebft qu\u1ea3 \u201ckh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c\u201d. V\u00ec th\u1ebf, ki\u1ec3m tra th\u1eadt k\u0129 v\u00e0 \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 v\u00e0o c\u00e1c d\u00e3y. \u0110\u1eb7c bi\u1ec7t l\u00e0 criteria range, \u0111\u1ec3 \u0111\u01b0\u1ee3c cho ra \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong c\u00f4ng th\u1ee9c SUMIFS. V\u00ed d\u1ee5: \u201c?\u201d l\u00e0 t\u00ecm ki\u1ebfm m\u1ed9t ch\u1eef c\u00e1i. \u201c*\u201d l\u00e0 ph\u1ea7n c\u00f2n l\u1ea1i sau c\u00e1c ch\u1eef c\u00e1i c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_10157\" aria-describedby=\"caption-attachment-10157\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10157\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Excel-cong-cu-duoc-su-dung-rat-nhieu-hien-nay.jpg\" alt=\"Excel c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u hi\u1ec7n nay\" width=\"650\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Excel-cong-cu-duoc-su-dung-rat-nhieu-hien-nay.jpg 650w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Excel-cong-cu-duoc-su-dung-rat-nhieu-hien-nay-400x246.jpg 400w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption id=\"caption-attachment-10157\" class=\"wp-caption-text\">Excel c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u hi\u1ec7n nay<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201c0\u201d \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb thay b\u1edfi k\u1ebft qu\u1ea3 mong \u0111\u1ee3i: Nh\u1eb1m \u0111\u1ea3m b\u1ea3o Criteria1,2 n\u1eb1m \u1edf trong d\u1ea5u ngo\u1eb7c k\u00e9p \u201c\u201d. N\u1ebfu b\u1ea1n \u0111ang ki\u1ec3m tra v\u1ec1 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 0.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 sai khi Sum_range v\u1edbi gi\u00e1 tr\u1ecb TRUE ho\u1eb7c FALSE: Trong \u0111\u00f3 v\u1edbi gi\u00e1 tr\u1ecb TRUE v\u00e0 FALSE cho Sum_range \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh tr\u1ecb theo c\u00e1c c\u00e1ch kh\u00e1c nhau. C\u00f3 th\u1ec3 d\u1eabn t\u1edbi k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u00fang khi c\u1ed9ng l\u1ea1i. T\u1ea5t c\u1ea3 nh\u1eefng \u00f4 trong Sum_range c\u00f3 ch\u1ee9a TRUE \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh l\u00e0 1. Nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a FALSE \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh l\u00e0 0.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ed1i s\u1ed1 Criteria Range c\u1ea7n ph\u1ea3i ch\u1ee9a v\u1ec1 s\u1ed1 h\u00e0ng v\u00e0 s\u1ed1 c\u1ed9t b\u1eb1ng v\u1edbi \u0111\u1ed1i s\u1ed1 Sum_range.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">h\u00e0m SUMIFS c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng v\u1edbi h\u00e0m AND. Excel s\u1ebd ch\u1ec9 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u00ednh trong ph\u1ea1m vi sum_range \u0111\u00e1p \u1ee9ng t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng \u1ee9ng.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 <\/span><b>h\u00e0m SUMIFS trong excel<\/b><span style=\"font-weight: 400;\"> c\u00e1ch d\u00f9ng, v\u00e0 nh\u1eefng \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh th\u1ea1o trong vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m Sumifs!<\/span><\/p>\n<p>\u0110\u1ecdc th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/cac-trang-web-tai-powerpoint-mien-phi\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;C\u00e1c trang web t\u1ea3i Powerpoint mi\u1ec5n ph\u00ed \u2013 ti\u1ebft ki\u1ec7m th\u1eddi gian hi\u1ec7u qu\u1ea3&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16185335},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\">C\u00e1c trang web t\u1ea3i Powerpoint mi\u1ec5n ph\u00ed \u2013 ti\u1ebft ki\u1ec7m th\u1eddi gian hi\u1ec7u qu\u1ea3<\/span><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tim_Hieu_Teky_Hoc_Vien_Cong_Nghe_Tre_Hang_Dau_Viet_Nam\"><\/span><span style=\"font-size: 20px; color: #339966;\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;C\u00f9ng T\u00ecm Hi\u1ec3u V\u1ec1 Teky H\u1ecdc Vi\u1ec7n 5 sao \u0110\u00e0o T\u1ea1o Tr\u1ebb Em H\u1ecdc L\u1eadp Tr\u00ecnh (4-18 tu\u1ed5i)&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:17153,&quot;3&quot;:{&quot;1&quot;:0},&quot;11&quot;:4,&quot;12&quot;:0,&quot;17&quot;:1}\">T\u00ecm Hi\u1ec3u Teky H\u1ecdc Vi\u1ec7n C\u00f4ng Ngh\u1ec7 Tr\u1ebb H\u00e0ng \u0110\u1ea7u Vi\u1ec7t Nam<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><iframe loading=\"lazy\" title=\"H\u1ecdc l\u1eadp tr\u00ecnh tr\u1ebb em \u1edf \u0111\u00e2u? - Gi\u1edbi thi\u1ec7u h\u1ecdc vi\u1ec7n c\u00f4ng ngh\u1ec7 TEKY h\u00e0ng \u0111\u1ea7u Vi\u1ec7t Nam\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/kGgr0XJAxFM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p><strong>TEKY l\u00e0 H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7<\/strong> v\u1edbi ch\u01b0\u01a1ng tr\u00ecnh gi\u1ea3ng d\u1ea1y STEAM (Science \u2013 Technology \u2013 Engineering \u2013 Art \u2013 Mathematics) theo chu\u1ea9n M\u1ef9 \u0111\u1ea7u ti\u00ean t\u1ea1i Vi\u1ec7t Nam d\u00e0nh cho tr\u1ebb em t\u1eeb 4 \u0111\u1ebfn 18 tu\u1ed5i.<\/p>\n<p>\u0110\u01b0\u1ee3c th\u00e0nh l\u1eadp v\u00e0o th\u00e1ng 6 n\u0103m 2016, TEKY quy\u1ebft t\u00e2m th\u1ef1c hi\u1ec7n s\u1ee9 m\u1ec7nh mang \u0111\u1ebfn cho th\u1ebf h\u1ec7 tr\u1ebb Vi\u1ec7t Nam ki\u1ebfn th\u1ee9c to\u00e0n di\u1ec7n v\u1ec1 STEAM, \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c t\u01b0 duy c\u00f4ng ngh\u1ec7, khoa h\u1ecdc m\u00e1y t\u00ednh v\u00e0 k\u1ef9 n\u0103ng th\u1ebf k\u1ef7 21 \u2013 4Cs (Critical Thinking: T\u01b0 duy ph\u1ea3n bi\u1ec7n \u2013 Communication: Giao ti\u1ebfp \u2013 Creativity: S\u00e1ng t\u1ea1o \u2013 Collaboration: L\u00e0m vi\u1ec7c nh\u00f3m).<\/p>\n<figure id=\"attachment_14828\" aria-describedby=\"caption-attachment-14828\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/teky.edu.vn\/?utm_source=Blog&amp;utm_medium=baiviet\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14828 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/03\/Trai-nghiem-hoc-lap-trinh-mien-phi.jpg\" alt=\"Tr\u1ea3i nghi\u1ec7m h\u1ecdc l\u1eadp tr\u00ecnh mi\u1ec5n ph\u00ed\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/03\/Trai-nghiem-hoc-lap-trinh-mien-phi.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/03\/Trai-nghiem-hoc-lap-trinh-mien-phi-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/03\/Trai-nghiem-hoc-lap-trinh-mien-phi-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><figcaption id=\"caption-attachment-14828\" class=\"wp-caption-text\">Tr\u1ea3i nghi\u1ec7m h\u1ecdc l\u1eadp tr\u00ecnh mi\u1ec5n ph\u00ed<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Day_la_chuong_trinh_khong_chi_trang_bi_kien_thuc_lap_trinh_ma_con_ren_luyen_nhom_ky_nang_4Cs_Tre_se_duoc\"><\/span>\u0110\u00e2y l\u00e0 ch\u01b0\u01a1ng tr\u00ecnh kh\u00f4ng ch\u1ec9 trang b\u1ecb ki\u1ebfn th\u1ee9c l\u1eadp tr\u00ecnh m\u00e0 c\u00f2n r\u00e8n luy\u1ec7n nh\u00f3m k\u1ef9 n\u0103ng 4Cs. Tr\u1ebb s\u1ebd \u0111\u01b0\u1ee3c:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u00a0H\u1ecdc t\u01b0 duy ph\u1ea3n bi\u1ec7n th\u00f4ng qua vi\u1ec7c ph\u00e2n t\u00edch c\u00e1c v\u1ea5n \u0111\u1ec1.<\/li>\n<li>\u00a0H\u1ecdc t\u00ednh s\u00e1ng t\u1ea1o t\u01b0 duy Logic th\u00f4ng qua vi\u1ec7c l\u1eafp \u0111\u1eb7t v\u00e0 l\u1eadp tr\u00ecnh robot th \u00f4ng qua c\u00e1c m\u00f4 h\u00ecnh Lego Mindstorm, app tr\u00f2 ch\u01a1i. Gi\u00fap con h\u1ecdc gi\u1ecfi m\u00f4n To\u00e1n tr\u00ean l\u1edbp<\/li>\n<li>\u00a0K\u1ef9 n\u0103ng h\u1ee3p t\u00e1c th\u00f4ng qua c\u00e1c tr\u00f2 ch\u01a1i team-building, c\u00e1c d\u1ef1 \u00e1n nh\u00f3m tr\u00ean l\u1edbp.<\/li>\n<li>\u00a0Ph\u00e1t huy kh\u1ea3 n\u0103ng giao ti\u1ebfp hi\u1ec7u qu\u1ea3 b\u1eb1ng nhi\u1ec1u b\u00e0i t\u1eadp v\u00e0 ho\u1ea1t \u0111\u1ed9ng h\u1ea5p d\u1eabn.<\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"Shark Nguy\u1ec5n Ho\u00e0 B\u00ecnh \u0111\u1ed3ng h\u00e0nh c\u00f9ng con h\u1ecdc l\u1eadp tr\u00ecnh t\u1ea1i h\u1ecdc vi\u1ec7n c\u00f4ng ngh\u1ec7 Teky h\u00e0ng \u0111\u1ea7u Vi\u1ec7t Nam\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/q6QbqIs6ll8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>C\u00e1c b\u1ed9 m\u00f4n gi\u1ea3ng d\u1ea1y t\u1ea1i Teky g\u1ed3m: <span style=\"font-weight: 400;\">L\u1eadp tr\u00ecnh v\u00e0 ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">l\u1eadp tr\u00ecnh game<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">l\u1eadp tr\u00ecnh web v\u1edbi python<\/span> <span style=\"font-weight: 400;\">\u00a0<\/span><span style=\"font-weight: 400;\">L\u1eadp tr\u00ecnh Scratch<\/span> <span style=\"font-weight: 400;\">Robotics<\/span> Engineering, C\u00f4ng ngh\u1ec7 3D v\u00e0 MultiMedia. Ch\u00fang t\u00f4i tin r\u1eb1ng tr\u1ebb em Vi\u1ec7t Nam c\u00f3 c\u01a1 h\u1ed9i ph\u00e1t tri\u1ec3n m\u1ea1nh m\u1ebd trong m\u1ed9t n\u1ec1n kinh t\u1ebf s\u1ed1 v\u00e0 c\u1ea7n \u0111\u01b0\u1ee3c trang b\u1ecb s\u1eb5n s\u00e0ng \u0111\u1ec3 tr\u1edf th\u00e0nh nh\u1eefng doanh nh\u00e2n c\u00f4ng ngh\u1ec7 trong t\u01b0\u01a1ng lai.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lien_he_ngay_hoc_vien_cong_nghe_sang_tao_TEKY_de_duoc_tu_van_khoa_hoc\"><\/span><span style=\"color: #008000;\"><b>Li\u00ean h\u1ec7 ngay h\u1ecdc vi\u1ec7n c\u00f4ng ngh\u1ec7 s\u00e1ng t\u1ea1o TEKY \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n kh\u00f3a h\u1ecdc:<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cam k\u00eat 7 tu\u1ed5i c\u00f3 th\u1ec3 l\u1eadp tr\u00ecnh<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Top 10 d\u1ef1 \u00e1n gi\u00e1o d\u1ee5c c\u00f3 t\u1ea7m \u1ea3nh h\u01b0\u1edfng nh\u1ea5t \u0110\u00f4ng Nam \u00c1 2017 &amp; 2018<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Top 3 D\u1ef1 \u00e1n xu\u1ea5t s\u1eafc nh\u1ea5t, NextGen \u2013 Th\u1ee5y S\u0129<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0Hotline H\u00e0 N\u1ed9i: 024-7109-6668 | 0975-241-015<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0Hotline H\u1ed3 Ch\u00ed Minh: 028-7109 9948 | 097-900-8642<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Website <\/span><a href=\"https:\/\/teky.edu.vn\/\"><span style=\"font-weight: 400;\">https:\/\/teky.edu.vn<\/span><\/a><span style=\"font-weight: 400;\"> | Email: support@teky.edu.vn |<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ch\u00fang ta \u0111\u00e3 bi\u1ebft \u0111\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng trong Excel, ph\u1ea3i t\u00ecnh b\u1eb1ng h\u00e0m SUM. V\u1eady c\u00f2n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o? \u0110\u00f3 ch\u00ednh l\u00e0 h\u00e0m SUMIFS. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m SUMIFS trong EXCEL, c\u00e1ch d\u00f9ng v\u00e0 nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd &hellip;<\/p>\n","protected":false},"author":10,"featured_media":10158,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10154","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-cong-nghe"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?<\/title>\n<meta name=\"description\" content=\"H\u00e0m SUMIFS trong EXCEL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o, \u00fd ngh\u0129a ra sao? C\u00e1c b\u1ea1n h\u00e3y t\u00ecm hi\u1ec3u ngay trong b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m SUMIFS trong EXCEL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o, \u00fd ngh\u0129a ra sao? C\u00e1c b\u1ea1n h\u00e3y t\u00ecm hi\u1ec3u ngay trong b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-11T16:42:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T07:28:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Kh\u00e1nh Kim\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kh\u00e1nh Kim\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/\"},\"author\":{\"name\":\"Kh\u00e1nh Kim\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/8f946d2123e4e2277107e392790a1bd6\"},\"headline\":\"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?\",\"datePublished\":\"2024-01-11T16:42:07+00:00\",\"dateModified\":\"2024-01-23T07:28:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/\"},\"wordCount\":2482,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg\",\"articleSection\":[\"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/\",\"name\":\"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg\",\"datePublished\":\"2024-01-11T16:42:07+00:00\",\"dateModified\":\"2024-01-23T07:28:09+00:00\",\"description\":\"H\u00e0m SUMIFS trong EXCEL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o, \u00fd ngh\u0129a ra sao? C\u00e1c b\u1ea1n h\u00e3y t\u00ecm hi\u1ec3u ngay trong b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg\",\"width\":600,\"height\":450,\"caption\":\"H\u00e0m Sumif trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt\",\"item\":\"https:\/\/teky.edu.vn\/blog\/tin-cong-nghe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/8f946d2123e4e2277107e392790a1bd6\",\"name\":\"Kh\u00e1nh Kim\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ab08c4bbf1d0787f26b32ab04d2cb7e329a3a082ea3dcb6ba78fb27076b856a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ab08c4bbf1d0787f26b32ab04d2cb7e329a3a082ea3dcb6ba78fb27076b856a9?s=96&d=mm&r=g\",\"caption\":\"Kh\u00e1nh Kim\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/kimkhanh\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?","description":"H\u00e0m SUMIFS trong EXCEL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o, \u00fd ngh\u0129a ra sao? C\u00e1c b\u1ea1n h\u00e3y t\u00ecm hi\u1ec3u ngay trong b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?","og_description":"H\u00e0m SUMIFS trong EXCEL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o, \u00fd ngh\u0129a ra sao? C\u00e1c b\u1ea1n h\u00e3y t\u00ecm hi\u1ec3u ngay trong b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!","og_url":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2024-01-11T16:42:07+00:00","article_modified_time":"2024-01-23T07:28:09+00:00","og_image":[{"width":600,"height":450,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg","type":"image\/jpeg"}],"author":"Kh\u00e1nh Kim","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Kh\u00e1nh Kim","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"10 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/"},"author":{"name":"Kh\u00e1nh Kim","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/8f946d2123e4e2277107e392790a1bd6"},"headline":"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?","datePublished":"2024-01-11T16:42:07+00:00","dateModified":"2024-01-23T07:28:09+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/"},"wordCount":2482,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg","articleSection":["C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/","name":"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg","datePublished":"2024-01-11T16:42:07+00:00","dateModified":"2024-01-23T07:28:09+00:00","description":"H\u00e0m SUMIFS trong EXCEL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o, \u00fd ngh\u0129a ra sao? C\u00e1c b\u1ea1n h\u00e3y t\u00ecm hi\u1ec3u ngay trong b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/Ham-Sumif-trong-excel-duoc-su-dung-nhu-the-nao.jpg","width":600,"height":450,"caption":"H\u00e0m Sumif trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt","item":"https:\/\/teky.edu.vn\/blog\/tin-cong-nghe\/"},{"@type":"ListItem","position":2,"name":"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/8f946d2123e4e2277107e392790a1bd6","name":"Kh\u00e1nh Kim","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ab08c4bbf1d0787f26b32ab04d2cb7e329a3a082ea3dcb6ba78fb27076b856a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab08c4bbf1d0787f26b32ab04d2cb7e329a3a082ea3dcb6ba78fb27076b856a9?s=96&d=mm&r=g","caption":"Kh\u00e1nh Kim"},"url":"https:\/\/teky.edu.vn\/blog\/author\/kimkhanh\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=10154"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10154\/revisions"}],"predecessor-version":[{"id":23663,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10154\/revisions\/23663"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/10158"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=10154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=10154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=10154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}