{"id":11079,"date":"2022-11-08T09:47:20","date_gmt":"2022-11-08T02:47:20","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11079"},"modified":"2022-12-08T10:39:02","modified_gmt":"2022-12-08T03:39:02","slug":"cach-su-dung-ham-sumif","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3"},"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;11079&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;5&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 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3&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 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">H\u00e0m Sumif l\u00e0 m\u1ed9t thu\u1eadt to\u00e1n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn nh\u1edd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 th\u1eddi gian l\u00e0m vi\u1ec7c tr\u00ean Excel. N\u1ebfu b\u1ea1n \u0111ang \u201ct\u1eadp t\u00e0nh\u201d s\u1eed d\u1ee5ng Excel th\u00ec \u0111\u1eebng b\u1ecf qua c\u00e1c th\u00f4ng tin h\u01b0\u1edbng d\u1eabn chi ti\u1ebft <\/span><b>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif<\/b><span style=\"font-weight: 400;\"> ngay sau \u0111\u00e2y nh\u00e9!<\/span><\/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\/cach-su-dung-ham-sumif\/#Ham_Sumif_la_gi\" >H\u00e0m Sumif 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-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#Cong_thuc_ham_Sumif\" >C\u00f4ng th\u1ee9c h\u00e0m Sumif<\/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\/cach-su-dung-ham-sumif\/#4_Cach_su_dung_ham_Sumif_trong_Excel_hieu_qua\" >4 C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3<\/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\/cach-su-dung-ham-sumif\/#Cach_su_dung_ham_Sumif_tinh_tong_theo_tieu_thuc_lon_hon_nho_hon_hoac_bang\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif t\u00ednh t\u1ed5ng theo ti\u00eau th\u1ee9c l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/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\/cach-su-dung-ham-sumif\/#Cach_su_dung_ham_Sumif_tinh_tong_cua_tieu_thuc_lap_lai\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif t\u00ednh t\u1ed5ng c\u1ee7a ti\u00eau th\u1ee9c l\u1eb7p l\u1ea1i<\/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\/cach-su-dung-ham-sumif\/#Cach_su_dung_ham_Sumif_theo_tieu_thuc_thoi_gian\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif theo ti\u00eau th\u1ee9c th\u1eddi gian<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#Dung_ham_Sumif_de_tinh_tong_cua_cac_o_chua_khong_chua_tieu_thuc\" >D\u00f9ng h\u00e0m Sumif \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 ch\u1ee9a kh\u00f4ng ch\u1ee9a ti\u00eau th\u1ee9c<\/a><\/li><\/ul><\/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\/cach-su-dung-ham-sumif\/#Cach_su_dung_ham_Sumif_khac_gi_voi_ham_Sumifs\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif kh\u00e1c g\u00ec v\u1edbi h\u00e0m Sumifs?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#Mot_so_loi_gap_phai_khi_su_dung_ham_Sumif_trong_Excel\" >M\u1ed9t s\u1ed1 l\u1ed7i g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng 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-10\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#Cac_luu_y_de_su_dung_ham_Sumif_hieu_qua\" >C\u00e1c l\u01b0u \u00fd \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Sumif hi\u1ec7u qu\u1ea3<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Sumif_la_gi\"><\/span><span style=\"color: #000000;\"><b>H\u00e0m Sumif l\u00e0 g\u00ec?<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m Sumif \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 h\u00e0m t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh, d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t. Nh\u1edd bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif, tr\u00ecnh \u0111\u1ed9 Excel c\u1ee7a b\u1ea1n s\u1ebd \u0111i l\u00ean m\u1ed9t level m\u1edbi khi kh\u00f4ng c\u00f2n lo ng\u1ea1i v\u1ec1 c\u00e1ch t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb theo y\u00eau c\u1ea7u. \u0110\u1ed3ng th\u1eddi, h\u00e0m Sumif c\u00f2n c\u00f3 kh\u1ea3 n\u0103ng k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c trong Excel n\u00ean r\u1ea5t thu\u1eadn ti\u1ec7n cho c\u00f4ng vi\u1ec7c v\u00e0 ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c nhi\u1ec1u th\u1eddi gian x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/span><\/p>\n<figure id=\"attachment_11080\" aria-describedby=\"caption-attachment-11080\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11080 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-1.jpg\" alt=\"T\u00ecm hi\u1ec3u h\u00e0m SumIf trong Excel\" width=\"600\" height=\"289\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-1-400x193.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11080\" class=\"wp-caption-text\">T\u00ecm hi\u1ec3u h\u00e0m SumIf trong Excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_Sumif\"><\/span><span style=\"color: #000000;\"><b>C\u00f4ng th\u1ee9c h\u00e0m Sumif<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m Sumif \u0111\u01b0\u1ee3c t\u00ednh theo c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">=SUMIF (range, criteria, [sum_range])<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Range: Ph\u1ea1m vi khoanh v\u00f9ng c\u00e1c d\u1eef li\u1ec7u \u0111i\u1ec1u ki\u1ec7n, ph\u1ea3i ch\u1ee9a t\u00ean, s\u1ed1 ho\u1eb7c tham chi\u1ebfu ch\u1ee9a s\u1ed1 (c\u00e1c gi\u00e1 tr\u1ecb tr\u1ed1ng trong ph\u1ea1m vi t\u00ednh \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng b\u1ecf qua)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Criteria: Ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh t\u1ed5ng d\u01b0\u1edbi d\u1ea1ng bi\u1ec3u th\u1ee9c, s\u1ed1, ho\u1eb7c th\u1eadm ch\u00ed l\u00e0 d\u1ea1ng v\u0103n b\u1ea3n<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Sum_range: Ph\u1ea1m vi c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u1ec3 t\u00ednh t\u1ed5ng..<\/span><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"H\u00e0m excel th\u00f4ng d\u1ee5ng: h\u00e0m SumIF\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/mABQYadzKh8?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<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"4_Cach_su_dung_ham_Sumif_trong_Excel_hieu_qua\"><\/span><span style=\"color: #000000;\"><b>4 C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">\u0110\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t, ch\u00fang ta s\u1ebd gi\u1ea3 s\u1eed v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u00ednh tr\u1ea3i t\u1eeb c\u1ed9t A t\u1edbi c\u1ed9t D, k\u00e9o d\u00e0i 10 d\u00f2ng. Sau \u0111\u00f3, t\u00f9y theo t\u1eebng c\u00f4ng th\u1ee9c, ch\u00fang ta s\u1ebd c\u00f3 t\u00ean g\u1ecdi kh\u00e1c nhau cho t\u1eebng \u0111i\u1ec1u ki\u1ec7n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng ph\u1ed5 bi\u1ebfn b\u1eb1ng h\u00e0m Sumif:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Sumif_tinh_tong_theo_tieu_thuc_lon_hon_nho_hon_hoac_bang\"><\/span><span style=\"color: #000000;\"><b><i>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif t\u00ednh t\u1ed5ng theo ti\u00eau th\u1ee9c l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/i><\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">C\u00f4ng th\u1ee9c t\u00ednh h\u00e0m Sumif n\u00e0y \u0111\u01b0\u1ee3c d\u00f9ng trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng m\u1ed9t m\u1ed1c gi\u00e1 tr\u1ecb cho tr\u01b0\u1edbc theo y\u00eau c\u1ea7u. V\u00ed d\u1ee5 khi \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb &gt; X, ta c\u00f3 c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">=SUMIF(A1:A10;&#8221;&gt;X&#8221;;D1:D10)\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">A1:A10: V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n X<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">&#8220;&gt;X&#8221;: \u0110i\u1ec1u ki\u1ec7n t\u00ednh t\u1ed5ng (c\u00f3 th\u1ec3 thay b\u1eb1ng d\u1ea5u \u201c&lt;\u201d ho\u1eb7c \u201c=\u201d t\u00f9y theo y\u00eau c\u1ea7u)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">D1:D10: V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ec3 t\u00ednh t\u1ed5ng.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_11081\" aria-describedby=\"caption-attachment-11081\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11081 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-2.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m Sumif t\u00ednh t\u1ed5ng theo ti\u00eau th\u1ee9c l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng\" width=\"600\" height=\"453\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-2-400x302.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11081\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Sumif t\u00ednh t\u1ed5ng theo ti\u00eau th\u1ee9c l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Sumif_tinh_tong_cua_tieu_thuc_lap_lai\"><\/span><span style=\"color: #000000;\"><b><i>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif t\u00ednh t\u1ed5ng c\u1ee7a ti\u00eau th\u1ee9c l\u1eb7p l\u1ea1i<\/i><\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u, s\u1ebd c\u00f3 l\u00fac b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c ti\u00eau th\u1ee9c l\u1eb7p l\u1ea1i v\u00e0 c\u0169ng c\u1ea7n d\u00f9ng t\u1edbi h\u00e0m Sumif. V\u00ed d\u1ee5: T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a ti\u00eau th\u1ee9c Y \u0111\u01b0\u1ee3c l\u1eb7p l\u1ea1i nhi\u1ec1u l\u1ea7n trong b\u1ea3ng d\u1eef li\u1ec7u. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n qua c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">=SUMIF(A1:A10,&#8221;Y&#8221;,D1:D10)<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">A1:A10: V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n Y<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">\u201cY\u201d: T\u00ean ti\u00eau th\u1ee9c c\u1ea7n t\u00ednh t\u1ed5ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">D1:D10: V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb t\u1ea1i Y.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Sumif_theo_tieu_thuc_thoi_gian\"><\/span><span style=\"color: #000000;\"><b><i>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif theo ti\u00eau th\u1ee9c th\u1eddi gian<\/i><\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb theo ti\u00eau th\u1ee9c th\u1eddi gian c\u00f3 d\u1ea1ng: xx\/yy\/zzzz th\u00ec cachs s\u1eed d\u1ee5ng h\u00e0m Sumif nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif \u0111\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean th\u1eddi gian c\u1ee5 th\u1ec3:<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">= SUMIF (A1:A10,\u201cxx\/yy\/zzzz\u201d,D1:D10)\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif \u0111\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng t\u1ea1i th\u1eddi gian c\u1ee5 th\u1ec3:<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">= SUMIF (A1:A10,\u201c&gt;=xx\/yy\/zzzz\u201d,D1:D10)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">A1:A10: V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c ti\u00eau th\u1ee9c th\u1eddi gian<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">xx\/yy\/zzzz: \u0110i\u1ec1u ki\u1ec7n th\u1eddi gian \u0111\u1ec3 t\u00ednh t\u1ed5ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">D1:D10: V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh t\u1ed5ng c\u1ee7a ti\u00eau th\u1ee9c th\u1eddi gian.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dung_ham_Sumif_de_tinh_tong_cua_cac_o_chua_khong_chua_tieu_thuc\"><\/span><span style=\"color: #000000;\"><b><i>D\u00f9ng h\u00e0m Sumif \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 ch\u1ee9a kh\u00f4ng ch\u1ee9a ti\u00eau th\u1ee9c<\/i><\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 kh\u00f4ng ch\u1ee9a ti\u00eau th\u1ee9c (b\u1ecb b\u1ecf tr\u1ed1ng), h\u00e0m Sumif c\u0169ng s\u1ebd gi\u00fap b\u1ea1n t\u00ednh t\u1ed5ng nhanh ch\u00f3ng. Ta c\u00f3 c\u00f4ng th\u1ee9c:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">=SUMIFS(A1:A10;\u201c\u201d;D1:D10)\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">A1:A10: V\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u \u0111i\u1ec1u ki\u1ec7n<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">\u201c\u201d: \u0110\u1ea1i di\u1ec7n cho ti\u00eau th\u1ee9c tr\u1ed1ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">D1:D10: V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh c\u1ee7a ti\u00eau th\u1ee9c tr\u1ed1ng.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_11082\" aria-describedby=\"caption-attachment-11082\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11082 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-3.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 ch\u1ee9a kh\u00f4ng ch\u1ee9a ti\u00eau th\u1ee9c\" width=\"600\" height=\"336\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-3-400x224.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11082\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 ch\u1ee9a kh\u00f4ng ch\u1ee9a ti\u00eau th\u1ee9c<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Sumif_khac_gi_voi_ham_Sumifs\"><\/span><span style=\"color: #000000;\"><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif kh\u00e1c g\u00ec v\u1edbi h\u00e0m Sumifs?<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">N\u1ebfu h\u00e0m Sumif ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng v\u1edbi duy nh\u1ea5t 1 \u0111i\u1ec1u ki\u1ec7n th\u00ec h\u00e0m Sumif s\u1ebd gi\u00fap b\u1ea1n t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumifs \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh theo c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], &#8230;)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Sum_range: V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Criteria_range1: V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n 1, kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Criteria1: \u0110i\u1ec1u ki\u1ec7n 1 c\u1ea7n \u00e1p d\u1ee5ng, l\u00e0 m\u1ed9t bi\u1ec3u th\u1ee9c, s\u1ed1 ho\u1eb7c tham s\u1ed1<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Criteria_range2,criteria2,\u2026: C\u00e1c v\u00f9ng \u0111i\u1ec1u ki\u1ec7n v\u00e0 \u0111i\u1ec1u ki\u1ec7n ti\u1ebfp theo<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">L\u01b0u \u00fd:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">M\u1ed7i \u00f4 trong ph\u1ea1m vi sum_range n\u1ebfu x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang cho \u00f4 \u0111\u00f3 m\u1edbi \u0111\u01b0\u1ee3c c\u1ed9ng t\u1ed5ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Sum_range v\u00e0 Criteria_range ph\u1ea3i \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh theo c\u00f9ng m\u1ed9t ph\u1ea1m vi (tr\u00f9ng s\u1ed1 h\u00e0ng v\u00e0 s\u1ed1 c\u1ed9t)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">C\u00e1c \u00f4 trong sum_range n\u1ebfu ch\u1ee9a TRUE th\u00ec t\u00ednh l\u00e0 1, ch\u1ee9a FALSE th\u00ec t\u00ednh l\u00e0 0.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Mot_so_loi_gap_phai_khi_su_dung_ham_Sumif_trong_Excel\"><\/span><span style=\"color: #000000;\"><b>M\u1ed9t s\u1ed1 l\u1ed7i g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Khi s\u1eed d\u1ee5ng h\u00e0m Sumif, r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p \u0111\u00e3 t\u00ednh t\u1ed5ng kh\u00f4ng th\u00e0nh c\u00f4ng do m\u1eafc ph\u1ea3i m\u1ed9t ho\u1eb7c m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m Sumif kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng do \u0111\u1ecbnh ngh\u0129a sai ti\u00eau ch\u00ed, \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u sai ho\u1eb7c s\u1eed d\u1ee5ng ph\u00e9p to\u00e1n so s\u00e1nh ch\u01b0a \u0111\u00fang: Kh\u1eafc ph\u1ee5c b\u1eb1ng c\u00e1ch \u0111\u1ed1i chi\u1ebfu v\u1edbi c\u00f4ng th\u1ee9c g\u1ed1c v\u00e0 ki\u1ec3m tra l\u1ea1i c\u00e1c d\u1ea5u, k\u00fd t\u1ef1, \u0111i\u1ec1u ki\u1ec7n, d\u1eef li\u1ec7u,&#8230;xem \u0111\u00e3 \u0111\u00fang hay ch\u01b0a<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">L\u1ed7i VALUE khi s\u1eed d\u1ee5ng h\u00e0m SUMIF Excel do c\u00e1c \u00f4 tham chi\u1ebfu c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u00f3ng, kh\u00f4ng \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c: Kh\u1eafc ph\u1ee5c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM v\u00e0 h\u00e0m IF theo c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 m\u1edf c\u00e1c Workbook kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">L\u1ed7i v\u01b0\u1ee3t qu\u00e1 255 k\u00fd t\u1ef1 cho ph\u00e9p trong c\u00e1c ti\u00eau ch\u00ed c\u1ee7a h\u00e0m: Kh\u1eafc ph\u1ee5c b\u1eb1ng c\u00e1ch r\u00fat ng\u1eafn k\u00fd t\u1ef1 ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m CONCATENATE hay to\u00e1n t\u1eed (&amp;) \u0111\u1ec3 chia th\u00e0nh nhi\u1ec1u chu\u1ed7i gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_11083\" aria-describedby=\"caption-attachment-11083\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11083 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-4.png\" alt=\"M\u1ed9t s\u1ed1 l\u1ed7i g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-4.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-4-400x200.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11083\" class=\"wp-caption-text\">M\u1ed9t s\u1ed1 l\u1ed7i g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_luu_y_de_su_dung_ham_Sumif_hieu_qua\"><\/span><span style=\"color: #000000;\"><b>C\u00e1c l\u01b0u \u00fd \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Sumif hi\u1ec7u qu\u1ea3<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">\u0110\u1ec3 h\u1ea1n ch\u1ebf m\u1eafc ph\u1ea3i nh\u1eefng l\u1ed7i nh\u01b0 tr\u00ean, ch\u00fang ta ph\u1ea3i bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif ch\u00ednh x\u00e1c h\u01a1n. Mu\u1ed1n v\u1eady, b\u1ea1n c\u1ea7n ghi nh\u1edb m\u1ed9t s\u1ed1 l\u01b0u \u00fd d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m Sumif ch\u1ec9 tr\u1ea3 v\u1ec1 t\u1ed5ng theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t n\u00ean \u0111\u1eebng nh\u1ea7m l\u1eabn v\u1edbi h\u00e0m Sumifs<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Trong tr\u01b0\u1eddng h\u1ee3p bi\u1ebfn s\u1ed1 sum_range b\u1ecb b\u1ecf qua, h\u1ec7 th\u1ed1ng s\u1ebd t\u00ednh t\u1ed5ng theo Range.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">\u1ede \u0111i\u1ec1u ki\u1ec7n Criteria, n\u1ebfu ph\u1ea1m vi kh\u00e1c \u0111\u1ecbnh d\u1ea1ng ch\u1eef ho\u1eb7c k\u00fd hi\u1ec7u to\u00e1n h\u1ecdc \u0111\u1ec1u ph\u1ea3i \u0111\u01b0\u1ee3c ch\u1ee9a trong d\u1ea5u ngo\u1eb7c k\u00e9p, n\u1ebfu d\u1ea1ng s\u1ed1 th\u00ec kh\u00f4ng c\u1ea7n d\u00f9ng. D\u00f9ng sai d\u1ea5u th\u00ec c\u00f4ng th\u1ee9c s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Trong Criteria c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 ? v\u00e0 *, trong \u0111\u00f3 d\u1ea5u h\u1ecfi ch\u1ea5m d\u00f9ng cho c\u00e1c k\u00fd t\u1ef1 \u0111\u01a1n, d\u1ea5u sao d\u00f9ng cho chu\u1ed7i k\u00fd t\u1ef1. Trong tr\u01b0\u1eddng h\u1ee3p mu\u1ed1n t\u00ecm m\u1ed9t trong hai lo\u1ea1i d\u1ea5u kia, ch\u1ec9 c\u1ea7n g\u00f5 (~) tr\u01b0\u1edbc k\u00fd t\u1ef1 l\u00e0 \u0111\u01b0\u1ee3c.<\/span><\/li>\n<\/ul>\n<p><!--more--><\/p>\n<p><strong>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam:<\/strong> <a href=\"https:\/\/teky.edu.vn\/blog\/cach-in-2-mat\/\"><strong>C\u00e1ch in 2 m\u1eb7t trong Word, Excel, PDF nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a?<\/strong><\/a><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Nh\u01b0 v\u1eady, tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c th\u00f4ng tin h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel. Hy v\u1ecdng ch\u00fang s\u1ebd h\u1eefu \u00edch v\u1edbi b\u1ea1n trong c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n d\u1eef li\u1ec7u v\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i c\u00e1c b\u00e0i vi\u1ebft ti\u1ebfp theo c\u1ee7a ch\u00fang t\u00f4i \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c Excel th\u00fa v\u1ecb kh\u00e1c!<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-tong-trong-word-don-gian-va-nhanh-chong-nhat\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch t\u00ednh t\u1ed5ng trong Word \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/\" target=\"_blank\" rel=\"noopener\">\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Sumif l\u00e0 m\u1ed9t thu\u1eadt to\u00e1n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn nh\u1edd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 th\u1eddi gian l\u00e0m vi\u1ec7c tr\u00ean Excel. N\u1ebfu b\u1ea1n \u0111ang \u201ct\u1eadp t\u00e0nh\u201d s\u1eed d\u1ee5ng Excel th\u00ec \u0111\u1eebng b\u1ecf qua c\u00e1c th\u00f4ng tin h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif ngay sau \u0111\u00e2y nh\u00e9! H\u00e0m Sumif l\u00e0 &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11084,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11079","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"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>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3<\/title>\n<meta name=\"description\" content=\"N\u1ebfu b\u1ea1n \u0111ang \u201ct\u1eadp t\u00e0nh\u201d s\u1eed d\u1ee5ng Excel th\u00ec \u0111\u1eebng b\u1ecf qua c\u00e1c th\u00f4ng tin h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif ngay sau. Tham kh\u1ea3o ngay!\" \/>\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\/cach-su-dung-ham-sumif\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3\" \/>\n<meta property=\"og:description\" content=\"N\u1ebfu b\u1ea1n \u0111ang \u201ct\u1eadp t\u00e0nh\u201d s\u1eed d\u1ee5ng Excel th\u00ec \u0111\u1eebng b\u1ecf qua c\u00e1c th\u00f4ng tin h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif ngay sau. Tham kh\u1ea3o ngay!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/\" \/>\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=\"2022-11-08T02:47:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T03:39:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\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=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 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\/cach-su-dung-ham-sumif\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3\",\"datePublished\":\"2022-11-08T02:47:20+00:00\",\"dateModified\":\"2022-12-08T03:39:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/\"},\"wordCount\":2232,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg\",\"datePublished\":\"2022-11-08T02:47:20+00:00\",\"dateModified\":\"2022-12-08T03:39:02+00:00\",\"description\":\"N\u1ebfu b\u1ea1n \u0111ang \u201ct\u1eadp t\u00e0nh\u201d s\u1eed d\u1ee5ng Excel th\u00ec \u0111\u1eebng b\u1ecf qua c\u00e1c th\u00f4ng tin h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif ngay sau. Tham kh\u1ea3o ngay!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg\",\"width\":800,\"height\":450,\"caption\":\"c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3\"}]},{\"@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\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3","description":"N\u1ebfu b\u1ea1n \u0111ang \u201ct\u1eadp t\u00e0nh\u201d s\u1eed d\u1ee5ng Excel th\u00ec \u0111\u1eebng b\u1ecf qua c\u00e1c th\u00f4ng tin h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif ngay sau. Tham kh\u1ea3o ngay!","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\/cach-su-dung-ham-sumif\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3","og_description":"N\u1ebfu b\u1ea1n \u0111ang \u201ct\u1eadp t\u00e0nh\u201d s\u1eed d\u1ee5ng Excel th\u00ec \u0111\u1eebng b\u1ecf qua c\u00e1c th\u00f4ng tin h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif ngay sau. Tham kh\u1ea3o ngay!","og_url":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/","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":"2022-11-08T02:47:20+00:00","article_modified_time":"2022-12-08T03:39:02+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3","datePublished":"2022-11-08T02:47:20+00:00","dateModified":"2022-12-08T03:39:02+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/"},"wordCount":2232,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/","url":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/","name":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg","datePublished":"2022-11-08T02:47:20+00:00","dateModified":"2022-12-08T03:39:02+00:00","description":"N\u1ebfu b\u1ea1n \u0111ang \u201ct\u1eadp t\u00e0nh\u201d s\u1eed d\u1ee5ng Excel th\u00ec \u0111\u1eebng b\u1ecf qua c\u00e1c th\u00f4ng tin h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif ngay sau. Tham kh\u1ea3o ngay!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg","width":800,"height":450,"caption":"c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3"}]},{"@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\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11079","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11079"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11079\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11084"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}