{"id":12216,"date":"2022-11-26T11:10:37","date_gmt":"2022-11-26T04:10:37","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12216"},"modified":"2022-12-06T16:15:33","modified_gmt":"2022-12-06T09:15:33","slug":"cach-su-dung-ham-sumifs-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch"},"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;12216&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;4&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 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch&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 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 h\u1eefu \u00edch cho nh\u1eefng ai l\u00e0m vi\u1ec7c li\u00ean quan nhi\u1ec1u \u0111\u1ebfn gi\u1ea5y t\u1edd, s\u1ed5 s\u00e1ch, \u0111\u00f2i h\u1ecfi vi\u1ec7c th\u1ed1ng k\u00ea, t\u00ednh to\u00e1n li\u00ean t\u1ee5c. <\/span><b>H\u00e0m sumifs trong excel<\/b><span style=\"font-weight: 400;\"> theo \u0111\u00f3 c\u0169ng l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn kh\u00f4ng k\u00e9m. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch th\u1ee9c s\u1eed d\u1ee5ng <\/span><b><i>h\u00e0m sumifs<\/i><\/b><span style=\"font-weight: 400;\"> n\u00e0y. H\u00e3y c\u00f9ng \u0111i\u1ec3m qua \u0111\u1ec3 n\u1eafm b\u1eaft r\u00f5 h\u01a1n. T\u1eeb \u0111\u00f3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng, ph\u1ee5c v\u1ee5 nhu c\u1ea7u c\u00f4ng vi\u1ec7c, h\u1ecdc t\u1eadp c\u1ee7a b\u1ea3n th\u00e2n \u0111\u01b0\u1ee3c t\u1ed1i \u01b0u nh\u1ea5t nh\u00e9.<\/span><\/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-sumifs-trong-excel\/#Ham_sumifs_trong_excel_va_ung_dung_tren_thuc_te_co_the_ban_chua_biet\" >H\u00e0m sumifs trong excel v\u00e0 \u1ee9ng d\u1ee5ng tr\u00ean th\u1ef1c t\u1ebf c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft<\/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-sumifs-trong-excel\/#Phan_biet_giua_ham_sumifs_va_sumif\" >Ph\u00e2n bi\u1ec7t gi\u1eefa h\u00e0m sumifs v\u00e0 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-sumifs-trong-excel\/#Cau_truc_ham_sumifs_trong_excel_the_nao\" >C\u1ea5u tr\u00fac h\u00e0m sumifs trong excel th\u1ebf n\u00e0o?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#Cac_nguyen_tac_khi_su_dung_ham_sumifs_co_the_ban_chua_biet\" >C\u00e1c nguy\u00ean t\u1eafc khi s\u1eed d\u1ee5ng h\u00e0m sumifs c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#Huong_dan_chi_tiet_cach_thuc_su_dung_ham_sumifs_trong_excel\" >H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m sumifs trong excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#Trong_do\" >Trong \u0111\u00f3:<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_sumifs_trong_excel_va_ung_dung_tren_thuc_te_co_the_ban_chua_biet\"><\/span><b>H\u00e0m sumifs trong excel v\u00e0 \u1ee9ng d\u1ee5ng tr\u00ean th\u1ef1c t\u1ebf c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong excel c\u00f3 kh\u00e1 nhi\u1ec1u h\u00e0m, ph\u1ee5c v\u1ee5 cho nhu c\u1ea7u t\u00ednh to\u00e1n c\u1ee7a ng\u01b0\u1eddi d\u00f9ng m\u1ed9t c\u00e1ch linh ho\u1ea1t, ti\u1ec7n \u00edch h\u01a1n. Trong \u0111\u00f3, n\u1ebfu nh\u01b0 <\/span><b><i>h\u00e0m sum l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3<\/i><\/b><span style=\"font-weight: 400;\"> h\u1ed7 tr\u1ee3 th\u1ef1c hi\u1ec7n vi\u1ec7c t\u00ednh t\u1ed5ng trong 1 ph\u1ea1m vi, d\u00e3y \u00f4 th\u00ec <\/span><b><i>h\u00e0m sumifs<\/i><\/b><span style=\"font-weight: 400;\"> c\u0169ng \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng cho vi\u1ec7c t\u00ednh t\u1ed5ng, tuy nhi\u00ean \u0111i k\u00e8m \u0111\u00f3 l\u00e0 vi\u1ec7c t\u00ednh t\u1ed5ng tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m SUMIFS th\u00f4ng minh (c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/3cgyec-ygnU?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 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ee9c, so v\u1edbi <\/span><b><i>h\u00e0m sum trong excel<\/i><\/b><span style=\"font-weight: 400;\"> ch\u1ec9 ph\u1ee5c v\u1ee5 nhu c\u1ea7u c\u1ed9ng l\u1ea1i s\u1ed1 li\u1ec7u gi\u1eefa c\u00e1c \u00f4 \u0111\u01a1n thu\u1ea7n, h\u00e0m sumifs s\u1ebd cho ph\u00e9p t\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong 1 ph\u1ea1m vi d\u1eef li\u1ec7u l\u1ef1a ch\u1ecdn th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1eb7t ra.\u00a0<\/span><\/p>\n<figure id=\"attachment_12221\" aria-describedby=\"caption-attachment-12221\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12221\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-2_1.jpg\" alt=\"h\u00e0m sumifs trong Excel\" width=\"600\" height=\"254\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-2_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-2_1-400x169.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12221\" class=\"wp-caption-text\">H\u00e0m sumifs gi\u00fap t\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong 1 ph\u1ea1m vi th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1eb7t ra<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, c\u00f3 th\u1ec3 th\u1ea5y, v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m sumifs trong excel n\u00e0y, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m s\u1eed d\u1ee5ng c\u00f9ng l\u00fac, t\u1ed1i \u01b0u cho t\u00e1c v\u1ee5 t\u00ednh to\u00e1n, th\u1ed1ng k\u00ea t\u01b0\u01a1ng \u1ee9ng m\u00e0 kh\u00f4ng c\u1ea7n chuy\u1ec3n ti\u1ebfp qua nhi\u1ec1u ph\u00e9p t\u00ednh kh\u00e1c nhau.<\/span><\/p>\n<figure id=\"attachment_12218\" aria-describedby=\"caption-attachment-12218\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12218\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-1-1.jpg\" alt=\"h\u00e0m sumifs trong Excel\" width=\"600\" height=\"419\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-1-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-1-1-400x279.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12218\" class=\"wp-caption-text\">T\u1ed1i \u01b0u cho vi\u1ec7c th\u1ed1ng k\u00ea, t\u00ednh to\u00e1n v\u1edbi h\u00e0m sumifs \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Phan_biet_giua_ham_sumifs_va_sumif\"><\/span><b>Ph\u00e2n bi\u1ec7t gi\u1eefa h\u00e0m sumifs v\u00e0 sumif<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m sumifs v\u00e0 sumif th\u01b0\u1eddng l\u00e0 2 h\u00e0m m\u00e0 kh\u00e1 nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng xuy\u00ean nh\u1ea7m l\u1eabn qua l\u1ea1i trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng. Theo \u0111\u00f3, d\u00f9 \u0111\u01b0\u1ee3c d\u00f9ng cho vi\u1ec7c t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n, th\u1ebf nh\u01b0ng, c\u00e1ch th\u1ee9c \u00e1p d\u1ee5ng 2 h\u00e0m n\u00e0y s\u1ebd c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3, sumif s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho vi\u1ec7c t\u00ednh t\u1ed5ng c\u1ee7a 1 \u0111\u1ed1i t\u01b0\u1ee3ng nh\u1ea5t \u0111\u1ecbnh d\u1ef1a tr\u00ean 1 \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t \u0111\u01b0\u1ee3c \u0111\u1eb7t ra. Sumifs c\u0169ng s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng trong v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn, nh\u01b0ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f9ng l\u00fac tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cau_truc_ham_sumifs_trong_excel_the_nao\"><\/span><b>C\u1ea5u tr\u00fac h\u00e0m sumifs trong excel th\u1ebf n\u00e0o?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1eafm \u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac s\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng linh ho\u1ea1t s\u1eed d\u1ee5ng, t\u00ednh to\u00e1n hay th\u1ed1ng k\u00ea 1 c\u00e1ch tu\u1ea7n t\u1ef1, chu\u1ea9n b\u00e0i b\u1ea3n nh\u1ea5t. Theo \u0111\u00f3, c\u1ea5u tr\u00fac h\u00e0m sumifs trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,\u2026).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3, c\u1ea7n ph\u00e2n bi\u1ec7t c\u00e1c th\u00f4ng s\u1ed1 g\u1ed3m:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sum_range: T\u1ee9c c\u00e1c \u00f4 m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n th\u1ef1c hi\u1ec7n t\u00ednh t\u1ed5ng trong b\u1ea3ng d\u1eef li\u1ec7u. \u0110\u00f3 bao g\u1ed3m c\u00e1c s\u1ed1 ho\u1eb7c t\u00ean ho\u1eb7c ph\u1ea1m vi, c\u00e1c tham chi\u1ebfu \u00f4 c\u00f3 ch\u1ee9a s\u1ed1. Hi\u1ec3u m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n h\u01a1n, \u0111\u00e2y l\u00e0 d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 theo \u0111i\u1ec1u ki\u1ec7n m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0a ra.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria_range1: T\u1ee9c ph\u1ea1m vi c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 b\u1eb1ng \u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng \u1ee9ng l\u00e0 Criteria1. \u0110\u00e2y l\u00e0 gi\u00e1 tr\u1ecb mang t\u00ednh ch\u1ea5t b\u1eaft bu\u1ed9c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria1: T\u1ee9c l\u00e0 \u0111i\u1ec1u ki\u1ec7n th\u1ec3 hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng m\u1ed9t s\u1ed1, bi\u1ec3u th\u1ee9c,&#8230; Ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng nh\u1eb1m x\u00e1c \u0111\u1ecbnh \u00f4 n\u00e0o trong Criteria_range1 s\u1ebd \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng. \u0110\u00e2y c\u0169ng l\u00e0 gi\u00e1 tr\u1ecb mang t\u00ednh ch\u1ea5t b\u1eaft bu\u1ed9c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria_range2,criteria2,\u2026 : T\u1ee9c l\u00e0 t\u00f9y ch\u1ecdn c\u00e1c ph\u1ea1m vi hay nh\u1eefng \u0111i\u1ec1u ki\u1ec7n b\u1ed5 sung c\u1ea7n thi\u1ebft.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12219\" aria-describedby=\"caption-attachment-12219\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12219 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-1_1.jpg\" alt=\"h\u00e0m sumifs\" width=\"600\" height=\"288\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-1_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-1_1-400x192.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12219\" class=\"wp-caption-text\">C\u1ea5u tr\u00fac h\u00e0m sumifs c\u1ea7n \u0111\u1ea3m b\u1ea3o \u0111\u1ec3 vi\u1ec7c t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c ti\u1ebfn h\u00e0nh ch\u00ednh x\u00e1c<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_nguyen_tac_khi_su_dung_ham_sumifs_co_the_ban_chua_biet\"><\/span><b>C\u00e1c nguy\u00ean t\u1eafc khi s\u1eed d\u1ee5ng h\u00e0m sumifs c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 \u00e1p d\u1ee5ng h\u00e0m sumifs trong vi\u1ec7c t\u00ednh to\u00e1n, th\u1ed1ng k\u00ea, c\u00e1c nguy\u00ean t\u1eafc ng\u01b0\u1eddi d\u00f9ng c\u1ea7n l\u01b0u t\u00e2m s\u1ebd bao g\u1ed3m:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m sumifs, s\u1ebd ch\u1ec9 c\u00f3 c\u00f3 t\u1ed1i \u0111a 127 c\u1eb7p criteria_range, criteria t\u01b0\u01a1ng \u1ee9ng. Vi\u1ec7c t\u00ednh to\u00e1n s\u1ebd kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c n\u1ebfu v\u01b0\u1ee3t qu\u00e1 127 c\u1eb7p n\u00e0y.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00ec ho\u1ea1t \u0111\u1ed9ng theo bi\u1ec3u th\u1ee9c logic mang t\u00ednh ch\u1ea5t \u0111\u1ed3ng th\u1eddi (AND) n\u00ean m\u1ed7i \u00f4 trong \u0111\u1ed1i s\u1ed1 sum_range s\u1ebd ch\u1ec9 \u0111\u01b0\u1ee3c c\u1ed9ng t\u00ednh t\u1ed5ng n\u1ebfu c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1eb7t ra l\u00e0 \u0111\u00fang v\u00e0 th\u1ecfa m\u00e3n t\u1ea5t c\u1ea3 cho \u00f4 \u0111\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1eddng h\u1ee3p c\u00e1c \u00f4 trong d\u00e3y sum_range c\u00f3 ch\u1ee9a TRUE s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 1. C\u00e1c \u00f4 trong d\u00e3y sum_range c\u00f3 ch\u1ee9a FALSE s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 0.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">M\u1ed7i criteria_range s\u1ebd c\u1ea7n \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u l\u00e0 c\u00f9ng k\u00edch th\u01b0\u1edbc v\u00f9ng ch\u1ecdn gi\u1ed1ng v\u1edbi sum_range. Trong \u0111\u00f3, criteria_range v\u00e0 sum_range ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u00f9ng s\u1ed1 h\u00e0ng, s\u1ed1 c\u1ed9t.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12217\" aria-describedby=\"caption-attachment-12217\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12217 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-4.jpg\" alt=\"\" width=\"600\" height=\"282\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-4-400x188.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12217\" class=\"wp-caption-text\">H\u00e0m sumifs ho\u1ea1t \u0111\u1ed9ng theo bi\u1ec3u th\u1ee9c logic mang t\u00ednh ch\u1ea5t \u0111\u1ed3ng th\u1eddi<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_chi_tiet_cach_thuc_su_dung_ham_sumifs_trong_excel\"><\/span><b>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m sumifs trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u1ef1a v\u00e0o c\u1ea5u tr\u00fac h\u00e0m sumifs tr\u00ean \u0111\u00e2y, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng nhanh khi \u00e1p d\u1ee5ng k\u00e8m 1 s\u1ed1 \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh m\u00e0 kh\u00f4ng ph\u1ea3i e ng\u1ea1i vi\u1ec7c b\u1ecf s\u00f3t c\u00e1c d\u1eef li\u1ec7u t\u00ednh to\u00e1n v\u00ec l\u00fd do b\u1ea5t c\u1ea9n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n, \u0111\u1ec3 th\u1ed1ng k\u00ea Th\u00e0nh ti\u1ec1n c\u1ee7a c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 Nh\u00e2n vi\u00ean K\u1ef9 thu\u1eadt v\u1edbi m\u1ee9c l\u01b0\u01a1ng t\u1eeb 3.000.000 tr\u1edf l\u00ean trong 1 b\u1ea3ng s\u1ed1, h\u00e0m sumifs l\u00fac n\u00e0y s\u1ebd c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u00ednh to\u00e1n nhanh ch\u00f3ng.<\/span><\/p>\n<figure id=\"attachment_12222\" aria-describedby=\"caption-attachment-12222\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12222 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-3-1.jpg\" alt=\"\" width=\"600\" height=\"345\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-3-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-3-1-400x230.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12222\" class=\"wp-caption-text\">T\u00ednh t\u1ed5ng c\u00e1c \u00f4 \u0111i k\u00e8m nh\u1eefng \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh v\u1edbi h\u00e0m Sumifs \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, t\u1ea1i \u00f4 c\u1ea7n x\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng \u1ee9ng v\u1edbi b\u1ea3ng tr\u00ean b\u1ea1n s\u1ebd nh\u1eadp c\u1ea5u tr\u00fac h\u00e0m nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=SUMIFS(D2:D8,C2:C8,&#8221;K\u1ef9 thu\u1eadt&#8221;,D2:D8,&#8221;&gt;3000000&#8243;)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3, nh\u1ea5n Enter \u0111\u1ec3 d\u1eef li\u1ec7u ph\u00e9p t\u00ednh cho h\u00e0m sumifs \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Trong_do\"><\/span><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">SUMIFS ch\u00ednh l\u00e0 l\u1ec7nh \u0111\u1ec3 t\u00ednh h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D2:D8 l\u00e0 d\u1ea3i d\u1eef li\u1ec7u c\u1ea7n x\u00e1c \u0111\u1ecbnh \u0111\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C2:C8 l\u00e0 v\u00f9ng d\u1eef li\u1ec7u tham chi\u1ebfu cho \u0111i\u1ec1u ki\u1ec7n 1 t\u01b0\u01a1ng \u1ee9ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;K\u1ef9 thu\u1eadt&#8221; \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh l\u00e0 \u0111i\u1ec1u ki\u1ec7n 1 &#8211; v\u1edbi y\u00eau c\u1ea7u l\u00e0 x\u00e1c \u0111\u1ecbnh c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 nh\u00e2n vi\u00ean k\u1ef9 thu\u1eadt<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D2:D8 l\u00e0 v\u00f9ng d\u1eef li\u1ec7u tham chi\u1ebfu cho \u0111i\u1ec1u ki\u1ec7n 2 t\u01b0\u01a1ng \u1ee9ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;&gt;3000000&#8221; l\u00e0 \u0111i\u1ec1u ki\u1ec7n 2 &#8211; t\u1ee9c kho\u1ea3ng Th\u00e0nh ti\u1ec1n l\u1edbn h\u01a1n 3.000.000<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12218\" aria-describedby=\"caption-attachment-12218\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12218 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-1-1.jpg\" alt=\"h\u00e0m sumifs \" width=\"600\" height=\"419\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-1-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumifs-trong-excel-1-1-400x279.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12218\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n t\u1ed5ng khi \u0111\u00e3 \u0111\u00e1p \u1ee9ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1eb7t ra<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m sumifs trong excel <\/b>c\u1ee7a <span style=\"font-weight: 400;\"><a href=\"https:\/\/teky.edu.vn\/\">Teky<\/a><\/span> mang \u0111\u1ebfn<b>.<\/b><span style=\"font-weight: 400;\"> Th\u1ef1c t\u1ebf, t\u01b0\u01a1ng t\u1ef1 <\/span><b><i>h\u00e0m sum<\/i><\/b><span style=\"font-weight: 400;\"> hay b\u1ea5t k\u00ec h\u00e0m n\u00e0o kh\u00e1c trong excel, v\u1edbi vi\u1ec7c n\u1eafm b\u1eaft c\u1ea5u tr\u00fac s\u1eed d\u1ee5ng, vi\u1ec7c t\u00ednh to\u00e1n, th\u1ed1ng k\u00ea c\u1ee7a ng\u01b0\u1eddi d\u00f9ng theo \u0111\u00f3 s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n kh\u00e1 nhi\u1ec1u. H\u00e3y tham kh\u1ea3o , \u00e1p d\u1ee5ng, ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n khi c\u1ea7n thi\u1ebft \u0111\u01b0\u1ee3c nhanh ch\u00f3ng, b\u00e0i b\u1ea3n nh\u1ea5t nh\u00e9!<\/span><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam:<\/p>\n<ul style=\"text-align: justify;\">\n<li><a href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel<\/a><\/li>\n<li><a href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-dem-co-dieu-kien-sieu-don-gian-trong-excel\/\">S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/a><\/li>\n<li><a href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\">Nh\u1eefng \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong excel\u00a0<\/a><\/li>\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\/ham-sumifs-trong-excel\/\" target=\"_blank\" rel=\"noopener\">T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel<\/a><\/li>\n<li><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><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 h\u1eefu \u00edch cho nh\u1eefng ai l\u00e0m vi\u1ec7c li\u00ean quan nhi\u1ec1u \u0111\u1ebfn gi\u1ea5y t\u1edd, s\u1ed5 s\u00e1ch, \u0111\u00f2i h\u1ecfi vi\u1ec7c th\u1ed1ng k\u00ea, t\u00ednh to\u00e1n li\u00ean t\u1ee5c. H\u00e0m sumifs trong excel theo \u0111\u00f3 c\u0169ng l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn kh\u00f4ng k\u00e9m. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch th\u1ee9c &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11084,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12216","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"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>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch<\/title>\n<meta name=\"description\" content=\"H\u00e0m sumifs trong excel \u0111\u00e3 v\u00e0 \u0111ang l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 nhi\u1ec1u trong vi\u1ec7c t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. V\u1eady, b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u1ea5u tr\u00fac v\u00e0 s\u1eed d\u1ee5ng h\u00e0m\" \/>\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-sumifs-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m sumifs trong excel \u0111\u00e3 v\u00e0 \u0111ang l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 nhi\u1ec1u trong vi\u1ec7c t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. V\u1eady, b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u1ea5u tr\u00fac v\u00e0 s\u1eed d\u1ee5ng h\u00e0m\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-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=\"2022-11-26T04:10:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T09:15:33+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-sumifs-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch\",\"datePublished\":\"2022-11-26T04:10:37+00:00\",\"dateModified\":\"2022-12-06T09:15:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/\"},\"wordCount\":1921,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#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-sumifs-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg\",\"datePublished\":\"2022-11-26T04:10:37+00:00\",\"dateModified\":\"2022-12-06T09:15:33+00:00\",\"description\":\"H\u00e0m sumifs trong excel \u0111\u00e3 v\u00e0 \u0111ang l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 nhi\u1ec1u trong vi\u1ec7c t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. V\u1eady, b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u1ea5u tr\u00fac v\u00e0 s\u1eed d\u1ee5ng h\u00e0m\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#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-sumifs-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch\"}]},{\"@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":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch","description":"H\u00e0m sumifs trong excel \u0111\u00e3 v\u00e0 \u0111ang l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 nhi\u1ec1u trong vi\u1ec7c t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. V\u1eady, b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u1ea5u tr\u00fac v\u00e0 s\u1eed d\u1ee5ng h\u00e0m","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-sumifs-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch","og_description":"H\u00e0m sumifs trong excel \u0111\u00e3 v\u00e0 \u0111ang l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 nhi\u1ec1u trong vi\u1ec7c t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. V\u1eady, b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u1ea5u tr\u00fac v\u00e0 s\u1eed d\u1ee5ng h\u00e0m","og_url":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-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":"2022-11-26T04:10:37+00:00","article_modified_time":"2022-12-06T09:15:33+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-sumifs-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch","datePublished":"2022-11-26T04:10:37+00:00","dateModified":"2022-12-06T09:15:33+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/"},"wordCount":1921,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#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-sumifs-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif.jpg","datePublished":"2022-11-26T04:10:37+00:00","dateModified":"2022-12-06T09:15:33+00:00","description":"H\u00e0m sumifs trong excel \u0111\u00e3 v\u00e0 \u0111ang l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 nhi\u1ec1u trong vi\u1ec7c t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. V\u1eady, b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u1ea5u tr\u00fac v\u00e0 s\u1eed d\u1ee5ng h\u00e0m","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/#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-sumifs-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch"}]},{"@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\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-Sumif-400x225.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12216","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=12216"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12216\/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=12216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}