{"id":11891,"date":"2022-11-20T22:11:00","date_gmt":"2022-11-20T15:11:00","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11891"},"modified":"2022-12-06T14:44:10","modified_gmt":"2022-12-06T07:44:10","slug":"ham-tinh-tong-co-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/","title":{"rendered":"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng"},"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;11891&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\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng&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;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 th\u1ea5y h\u00e0m SUM t\u00ednh t\u1ed5ng trong excel v\u00f4 c\u00f9ng d\u1ec5 th\u1ef1c hi\u1ec7n v\u00e0 ai c\u0169ng c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u00e0m \u0111\u01b0\u1ee3c. Th\u1ebf nh\u01b0ng <\/span><b>h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\"> SUMIFS l\u1ea1i khi\u1ebfn cho nhi\u1ec1u ng\u01b0\u1eddi c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n, kh\u00f4ng bi\u1ebft \u0111\u1eb7t h\u00e0m nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang c\u00fa ph\u00e1p.\u00a0 \u0110\u1ec3 r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch t\u00ednh h\u00e0m SUMIFS c\u00f3 \u0111i\u1ec1u ki\u1ec7n th\u00ec h\u00e3y theo d\u00f5i chi ti\u1ebft b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Teky.<\/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\/ham-tinh-tong-co-dieu-kien-trong-excel\/#Thong_tin_tong_quan_ve_ham_SUMIF_va_ham_SUMIFS\" >Th\u00f4ng tin t\u1ed5ng quan v\u1ec1 h\u00e0m SUMIF v\u00e0 h\u00e0m SUMIFS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#Cu_phap_su_dung_cua_ham_tinh_tong_co_dieu_kien_SUMIF_va_ham_SUMIFS\" >C\u00fa ph\u00e1p s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIF v\u00e0 h\u00e0m SUMIFS<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#Cu_phap_cua_ham_tinh_tong_dieu_kien_SUMIF\" >C\u00fa ph\u00e1p c\u1ee7a h\u00e0m t\u00ednh t\u1ed5ng \u0111i\u1ec1u ki\u1ec7n SUMIF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#Cu_phap_cua_ham_tinh_tong_dieu_kien_SUMIFS\" >C\u00fa ph\u00e1p c\u1ee7a h\u00e0m t\u00ednh t\u1ed5ng \u0111i\u1ec1u ki\u1ec7n SUMIFS<\/a><\/li><\/ul><\/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\/ham-tinh-tong-co-dieu-kien-trong-excel\/#Mot_so_dieu_ban_can_biet_khi_su_dung_ham_tinh_tong_co_dieu_kien_trong_excel\" >M\u1ed9t s\u1ed1 \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft khi s\u1eed d\u1ee5ng h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n 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\/ham-tinh-tong-co-dieu-kien-trong-excel\/#Chu_y_toi_trinh_tu_cac_doi_so\" >Ch\u00fa \u00fd t\u1edbi tr\u00ecnh t\u1ef1 c\u00e1c \u0111\u1ed1i s\u1ed1<\/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\/ham-tinh-tong-co-dieu-kien-trong-excel\/#Chu_y_toi_kich_thuoc_cua_cac_doi_so_sum_range_va_doi_so_criteria_range\" >Ch\u00fa \u00fd t\u1edbi k\u00edch th\u01b0\u1edbc c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1 sum_range v\u00e0 \u0111\u1ed1i s\u1ed1 criteria_range<\/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\/ham-tinh-tong-co-dieu-kien-trong-excel\/#Loi_ket\" >L\u1eddi k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thong_tin_tong_quan_ve_ham_SUMIF_va_ham_SUMIFS\"><\/span><b>Th\u00f4ng tin t\u1ed5ng quan v\u1ec1 h\u00e0m SUMIF v\u00e0 h\u00e0m SUMIFS<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11893 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-2.jpg\" alt=\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel \" width=\"600\" height=\"261\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-2-400x174.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00fang nh\u01b0 c\u00e1i t\u00ean c\u1ee7a n\u00f3, h\u00e0m SUMIF ch\u00ednh l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m SUM c\u00f9ng v\u1edbi h\u00e0m IF trong excel. C\u0169ng b\u1edfi s\u1ef1 k\u1ebft h\u1ee3p n\u00e0y n\u00ean c\u00e1c ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m SUMIF s\u1ebd bao g\u1ed3m \u0111\u1ea7y \u0111\u1ee7 ch\u1ee9c n\u0103ng c\u1ee7a c\u1ea3 h\u00e0m SUM v\u00e0 h\u00e0m IF. Do \u0111\u00f3, khi s\u1eed d\u1ee5ng h\u00e0m SUMIF b\u1ea1n c\u00f3 th\u1ec3 v\u1eeba th\u1ef1c hi\u1ec7n t\u00ednh t\u1ed5ng v\u00e0 \u00e1p d\u1ee5ng th\u00eam \u0111i\u1ec1u ki\u1ec7n cho d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m SUMIFS c\u0169ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi h\u00e0m SUMIF nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f9ng l\u00fac nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac. \u0110i\u1ec1u n\u00e0y gi\u00fap ch\u00fang ta t\u00ednh t\u1ed5ng v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong c\u00f9ng m\u1ed9t l\u00fac. \u0110i\u1ec1u n\u00e0y c\u0169ng s\u1ebd gi\u00fap cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u00ean excel tr\u1edf n\u00ean khoa h\u1ecdc h\u01a1n, thu\u1eadn ti\u1ec7n h\u01a1n r\u1ea5t nhi\u1ec1u.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"H\u00e0m SUMIFS t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/EyiwrDND82Y?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=\"Cu_phap_su_dung_cua_ham_tinh_tong_co_dieu_kien_SUMIF_va_ham_SUMIFS\"><\/span><b>C\u00fa ph\u00e1p s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIF v\u00e0 h\u00e0m SUMIFS<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi c\u00fa ph\u00e1p t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n th\u00ec c\u1ea3 hai h\u00e0m c\u0169ng kh\u00f4ng c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t nhi\u1ec1u. C\u1ee5 th\u1ec3:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_tinh_tong_dieu_kien_SUMIF\"><\/span><b>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m t\u00ednh t\u1ed5ng \u0111i\u1ec1u ki\u1ec7n SUMIF<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng c\u1ee7a h\u00e0m SUMIF ch\u1ec9 d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00ean c\u00f3 c\u00f4ng th\u1ee9c kh\u00e1 \u0111\u01a1n gi\u1ea3n. \u0110\u00f3 l\u00e0:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=SUMIF(<\/span><span style=\"font-weight: 400;\">range,Criteria, [sum_range])<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Range: \u0110\u00e2u ch\u00ednh l\u00e0 d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 theo \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0a ra v\u00e0 \u0111\u00e2y ch\u00ednh l\u00e0 b\u1ed9 ph\u1eadn b\u1eaft bu\u1ed9c c\u1ea7n c\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria: \u0110\u00e2y ch\u00ednh l\u00e0 \u0111i\u1ec1u c\u1ea7n c\u1ea7n ph\u1ea3i \u0111\u00e1p \u1ee9ng trong h\u00e0m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sum_range: \u0110\u00e2y ch\u00ednh l\u00e0 c\u00e1c \u00f4 t\u00ednh n\u1ebfu th\u1ecfa \u0111i\u1ec1u ki\u1ec7n v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t d\u1ea3i \u00f4, m\u1ed9t \u00f4 ho\u1eb7c c\u00e1c \u00f4 t\u00ednh \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_tinh_tong_dieu_kien_SUMIFS\"><\/span><b>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m t\u00ednh t\u1ed5ng \u0111i\u1ec1u ki\u1ec7n SUMIFS<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi h\u00e0m SUMIFS b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c ph\u00e9p t\u00ednh t\u1ed5ng c\u00f9ng l\u00fac nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel. C\u1ee5 th\u1ec3 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIFS c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=SUMIFS(<\/span><span style=\"font-weight: 400;\">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:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><b>Sum_range: <\/b><span style=\"font-weight: 400;\">\u0110\u00e2y ch\u00ednh l\u00e0 gi\u1edbi h\u1ea1n, ph\u1ea1m vi c\u1ee7a c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n t\u00ednh t\u1ed5ng c\u00e1c d\u1eef li\u1ec7u. \u0110\u1ed1i v\u1edbi ph\u1ea1m vi n\u00e0y th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn 1 \u00f4 duy nh\u1ea5t, m\u1ed9t d\u1ea3i \u00f4 li\u00ean ti\u1ebfp ho\u1eb7c c\u00e1c \u00f4 t\u00e1ch r\u1eddi nhau \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Criteria_range1: <\/b><span style=\"font-weight: 400;\">\u0110\u00e2y ch\u00ednh l\u00e0 ph\u1ea1m vi \u00f4 \u0111\u1ea7u ti\u00ean \u0111\u1ec3 b\u1ea1n th\u1ef1c hi\u1ec7n \u0111\u00e1nh gi\u00e1 theo \u0111i\u1ec1u ki\u1ec7n th\u1ee9 nh\u1ea5t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Criteria1: <\/b><span style=\"font-weight: 400;\">\u0110\u00e2y ch\u00ednh l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u00e1p \u1ee9ng . \u0110\u1ed1i v\u00f9ng n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft tham s\u1ed1 \u0111i\u1ec1u ki\u1ec7n d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n, s\u1ed1, c\u0169ng c\u00f3 th\u1ec3 vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c hay bi\u1ec3u th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Criteria_range2,criteria2,\u2026:<\/b><span style=\"font-weight: 400;\"> \u0110\u00e2y ch\u00ednh l\u00e0 c\u00e1c c\u1eb7p ph\u1ea1m vi \u0111i\u1ec1u ki\u1ec7n kh\u00e1c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u01b0a v\u00e0o trong h\u00e0m t\u00ednh t\u1ed5ng \u0111i\u1ec1u ki\u1ec7n. Gi\u1edbi h\u1ea1n t\u1ed1i \u0111a c\u1ee7a c\u1eb7p ph\u1ea1m vi \u0111i\u1ec1u ki\u1ec7n n\u00e0y trong c\u00f4ng th\u1ee9c t\u00ednh h\u00e0m SUMIFS l\u00e0 127.\u00a0\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11892 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-1.jpg\" alt=\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng-1\" width=\"600\" height=\"336\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-1-400x224.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Mot_so_dieu_ban_can_biet_khi_su_dung_ham_tinh_tong_co_dieu_kien_trong_excel\"><\/span><b>M\u1ed9t s\u1ed1 \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft khi s\u1eed d\u1ee5ng h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong excel \u0111\u1ec3 t\u00ednh to\u00e1n, s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o <\/span><b>h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\"> th\u00ec b\u1ea1n c\u1ea7n nh\u1edb t\u1edbi m\u1ed9t s\u1ed1 \u0111i\u1ec1u d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Chu_y_toi_trinh_tu_cac_doi_so\"><\/span><b>Ch\u00fa \u00fd t\u1edbi tr\u00ecnh t\u1ef1 c\u00e1c \u0111\u1ed1i s\u1ed1<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong c\u00e1c h\u00e0m t\u00ednh t\u1ed5ng trong excel th\u00ec tr\u00ecnh c\u00e1c \u0111\u1ed1i s\u1ed1 l\u00e0 kh\u00f4ng gi\u1ed1ng nhau n\u00ean b\u1ea1n c\u1ea7n ch\u00fa \u00fd \u0111\u1ec3 kh\u00f4ng b\u1ecb nh\u1ea7m l\u1eabn. C\u1ee5 th\u1ec3 \u0111\u1ed1i s\u1ed1 sum_range \u0111\u1ee9ng \u1edf v\u1ecb tr\u00ed th\u1ee9 3 c\u1ee7a h\u00e0m SUMIF nh\u01b0ng l\u1ea1i \u0111\u1ee9ng \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean c\u1ee7a h\u00e0m SUMIFS.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi m\u1edbi b\u1eaft \u0111\u1ea7u h\u1ecdc v\u00e0 s\u1eed d\u1ee5ng h\u00e0m t\u00ednh t\u1ed5ng n\u00e0y c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y kh\u00f3, ph\u1ee9c t\u1ea1p. Th\u1ebf nh\u01b0ng, sau khi \u0111\u00e3 th\u1ef1c hi\u1ec7n nhi\u1ec1u l\u1ea7n, xem x\u00e9t k\u1ef9 th\u00ec b\u1ea1n s\u1ebd hi\u1ec3u r\u00f5 h\u01a1n \u00fd ngh\u0129a \u0111\u1eb1ng sau \u0111\u00f3.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u1ee5 th\u1ec3 l\u00e0 \u0111\u1ed1i s\u1ed1 sum_range trong h\u00e0m SUMIF l\u00e0 m\u1ed9t t\u00f9y ch\u1ecdn. Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n b\u1ecf qua n\u00f3 th\u00ec <\/span><span style=\"font-weight: 400;\">c\u00f4ng th\u1ee9c SUMIF s\u1ebd th\u1ef1c hi\u1ec7n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong range.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f2n \u0111\u1ed1i v\u1edbi h\u00e0m SUMIFS th\u00ec <\/span><span style=\"font-weight: 400;\">sum_range l\u00e0 b\u1eaft bu\u1ed9c, \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong h\u00e0m v\u00e0 kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u01b0\u1ee3c. \u0110\u00e2y c\u0169ng ch\u00ednh l\u00e0 l\u00fd do m\u00e0 n\u00f3 xu\u1ea5t hi\u1ec7n \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Chu_y_toi_kich_thuoc_cua_cac_doi_so_sum_range_va_doi_so_criteria_range\"><\/span><b>Ch\u00fa \u00fd t\u1edbi k\u00edch th\u01b0\u1edbc c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1 sum_range v\u00e0 \u0111\u1ed1i s\u1ed1 criteria_range<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 cho h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a m\u00ecnh kh\u00f4ng g\u1eb7p l\u1ed7i th\u00ec b\u1ea1n c\u1ea7n ch\u00fa \u00fd t\u1edbi k\u00edch th\u01b0\u1edbc c\u1ee7a c\u00e1c \u0111\u00f4i s\u1ed1. B\u1edfi trong h\u00e0m SUMIF th\u00ec \u0111\u1ed1i s\u1ed1 sum_range kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f9ng k\u00edch th\u01b0\u1edbc v\u1edbi \u0111\u1ed1i s\u1ed1 range, ch\u1ec9 c\u1ea7n b\u1ea1n c\u00f3 \u00f4 ph\u00eda tr\u00ean b\u00ean tr\u00e1i. Th\u1ebf nh\u01b0ng trong h\u00e0m SUMIFS m\u1ed7i \u0111\u1ed1i s\u1ed1 criteria_range c\u1ea7n ph\u1ea3i ch\u1ee9a s\u1ed1 h\u00e0ng, s\u1ed1 c\u1ed9t gi\u1ed1ng nh\u01b0 \u0111\u1ed1i s\u1ed1 sum_range.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11894 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg\" alt=\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\" width=\"600\" height=\"326\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3-400x217.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed \u0111\u1ed1i v\u1edbi h\u00e0m SUMIF ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=SUMIF(A2:A9, F1, C12:C18)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c tr\u00ean l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh v\u00e0 s\u1ebd gi\u00fap tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00fang l\u00e0 t\u1ed5ng s\u1ed1 li\u1ec7u trong ph\u1ea1m vi sum_range \u0111\u00e1p \u1ee9ng \u0111\u00fang \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m. C\u0169ng b\u1edfi do excel ch\u1ec9 c\u1ea7n x\u00e1c \u0111\u1ecbnh \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean trong tham s\u1ed1 c\u1ee7a \u0111\u1ed1i s\u1ed1 sum_range c\u1ee5 th\u1ec3 l\u00e0 \u00f4 C2. \u0110\u1ed3ng th\u1eddi s\u1ebd t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng t\u00ednh to\u00e1n cho ph\u1ea1m vi t\u01b0\u01a1ng \u0111\u01b0\u01a1ng k\u00edch th\u01b0\u1edbc c\u1ee7a d\u1ea3i A2:A9.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi h\u00e0m SUMIFS ch\u00fang ta c\u0169ng c\u00f3 c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=SUMIFS(C2:C9, A2:A9, \u201capple\u201d, B2:B10, Pete)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n nh\u1eadp h\u00e0m SUMIFS v\u1edbi c\u00f4ng th\u1ee9c n\u00e0y th\u00ec s\u1ebd b\u1ecb b\u00e1o l\u1ed7i #VALUE! Nguy\u00ean do l\u00e0 trong c\u00f4ng th\u1ee9c n\u00e0y k\u00edch th\u01b0\u1edbc c\u1ee7a \u0111\u1ed1i s\u1ed1 criteria 2 (B2:B10) kh\u00f4ng \u0111\u00fang v\u1edbi k\u00edch th\u01b0\u1edbc c\u1ee7a \u0111\u1ed1i s\u1ed1 sum_range (C2:C9).<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loi_ket\"><\/span><b>L\u1eddi k\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 to\u00e0n b\u1ed9 nh\u1eefng th\u00f4ng tin h\u01b0\u1edbng d\u1eabn li\u00ean quan t\u1edbi <\/span><b>h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\"> m\u00e0 teky mu\u1ed1n chia s\u1ebb t\u1edbi qu\u00fd b\u1ea1n. Hy v\u1ecdng v\u1edbi nh\u1eefng th\u00f4ng tin tr\u00ean s\u1ebd gi\u00fap qu\u00fd b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0y. \u0110\u1ed3ng th\u1eddi c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng th\u00e0nh t\u1ea1o \u0111\u01b0\u1ee3c h\u00e0m SUMIF v\u00e0 h\u00e0m SUMIFS trong excel.<\/span><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch<\/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<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\/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<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>C\u00f3 th\u1ec3 th\u1ea5y h\u00e0m SUM t\u00ednh t\u1ed5ng trong excel v\u00f4 c\u00f9ng d\u1ec5 th\u1ef1c hi\u1ec7n v\u00e0 ai c\u0169ng c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u00e0m \u0111\u01b0\u1ee3c. Th\u1ebf nh\u01b0ng h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIFS l\u1ea1i khi\u1ebfn cho nhi\u1ec1u ng\u01b0\u1eddi c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n, kh\u00f4ng bi\u1ebft \u0111\u1eb7t h\u00e0m nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang c\u00fa ph\u00e1p.\u00a0 \u0110\u1ec3 r\u00f5 h\u01a1n &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11894,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11891","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\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/title>\n<meta name=\"description\" content=\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIFS l\u1ea1i khi\u1ebfn cho nhi\u1ec1u ng\u01b0\u1eddi c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n, kh\u00f4ng bi\u1ebft \u0111\u1eb7t h\u00e0m nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang c\u00fa ph\u00e1p\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIFS l\u1ea1i khi\u1ebfn cho nhi\u1ec1u ng\u01b0\u1eddi c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n, kh\u00f4ng bi\u1ebft \u0111\u1eb7t h\u00e0m nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang c\u00fa ph\u00e1p\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-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-20T15:11:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T07:44:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"326\" \/>\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=\"6 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\",\"datePublished\":\"2022-11-20T15:11:00+00:00\",\"dateModified\":\"2022-12-06T07:44:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/\"},\"wordCount\":1752,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/\",\"name\":\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg\",\"datePublished\":\"2022-11-20T15:11:00+00:00\",\"dateModified\":\"2022-12-06T07:44:10+00:00\",\"description\":\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIFS l\u1ea1i khi\u1ebfn cho nhi\u1ec1u ng\u01b0\u1eddi c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n, kh\u00f4ng bi\u1ebft \u0111\u1eb7t h\u00e0m nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang c\u00fa ph\u00e1p\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg\",\"width\":600,\"height\":326},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-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\":\"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\"}]},{\"@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\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng","description":"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIFS l\u1ea1i khi\u1ebfn cho nhi\u1ec1u ng\u01b0\u1eddi c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n, kh\u00f4ng bi\u1ebft \u0111\u1eb7t h\u00e0m nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang c\u00fa ph\u00e1p","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng","og_description":"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIFS l\u1ea1i khi\u1ebfn cho nhi\u1ec1u ng\u01b0\u1eddi c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n, kh\u00f4ng bi\u1ebft \u0111\u1eb7t h\u00e0m nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang c\u00fa ph\u00e1p","og_url":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-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-20T15:11:00+00:00","article_modified_time":"2022-12-06T07:44:10+00:00","og_image":[{"width":600,"height":326,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.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":"6 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng","datePublished":"2022-11-20T15:11:00+00:00","dateModified":"2022-12-06T07:44:10+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/"},"wordCount":1752,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/","name":"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg","datePublished":"2022-11-20T15:11:00+00:00","dateModified":"2022-12-06T07:44:10+00:00","description":"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIFS l\u1ea1i khi\u1ebfn cho nhi\u1ec1u ng\u01b0\u1eddi c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n, kh\u00f4ng bi\u1ebft \u0111\u1eb7t h\u00e0m nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang c\u00fa ph\u00e1p","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-tinh-tong-co-dieu-kien-3.jpg","width":600,"height":326},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-tinh-tong-co-dieu-kien-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":"H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng"}]},{"@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\/11891","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=11891"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11891\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11894"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}