{"id":101049,"date":"2024-10-11T14:29:34","date_gmt":"2024-10-11T07:29:34","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=101049"},"modified":"2024-10-11T14:29:37","modified_gmt":"2024-10-11T07:29:37","slug":"tong-hop-ham-dem-co-dieu-kien-excel","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft 2024"},"content":{"rendered":"\n<p>Trong Excel, h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch, gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/phongvu.vn\/cong-nghe\">Phong V\u0169 Tech News<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian, n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c c\u0169ng nh\u01b0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u. H\u00e3y c\u00f9ng kh\u00e1m ph\u00e1 v\u00e0 l\u00e0m ch\u1ee7 c\u00e1c h\u00e0m \u0111\u1ebfm \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 tr\u1edf th\u00e0nh m\u1ed9t \u201ccao th\u1ee7\u201d Excel trong th\u1eddi \u0111\u1ea1i c\u00f4ng ngh\u1ec7 s\u1ed1 nh\u00e9!<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/\">C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m ROUND, ROUNDUP<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-khac-phuc-loi-man-hinh-laptop-bi-giat\/\">Nguy\u00ean nh\u00e2n, c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i m\u00e0n h\u00ecnh laptop b\u1ecb gi\u1eadt d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng nh\u1ea5t<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/xu-ly-tai-khoan-zalo-bi-vo-hieu-hoa\/\">Nguy\u00ean nh\u00e2n t\u00e0i kho\u1ea3n zalo b\u1ecb v\u00f4 hi\u1ec7u h\u00f3a v\u00e0 c\u00e1ch l\u1ea5y l\u1ea1i t\u00e0i kho\u1ea3n d\u1ec5 d\u00e0ng<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a21d9645086d\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a21d9645086d\"  type=\"checkbox\" id=\"item-6a21d9645086d\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#Tong_hop_cac_loai_ham_dem_co_dieu_kien_trong_Excel\" title=\"T\u1ed5ng h\u1ee3p c\u00e1c lo\u1ea1i h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel \">T\u1ed5ng h\u1ee3p c\u00e1c lo\u1ea1i h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#Cong_dung_va_cach_su_dung_cua_tung_loai_ham_dem\" title=\"C\u00f4ng d\u1ee5ng v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a t\u1eebng lo\u1ea1i h\u00e0m \u0111\u1ebfm \">C\u00f4ng d\u1ee5ng v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a t\u1eebng lo\u1ea1i h\u00e0m \u0111\u1ebfm <\/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:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#COUNT_Dem_cac_o_chua_so\" title=\"COUNT: \u0110\u1ebfm c\u00e1c \u00f4 ch\u1ee9a s\u1ed1. \">COUNT: \u0110\u1ebfm c\u00e1c \u00f4 ch\u1ee9a s\u1ed1. <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#COUNTA_Dem_cac_o_khong_trong\" title=\"COUNTA: \u0110\u1ebfm c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng. \">COUNTA: \u0110\u1ebfm c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng. <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#COUNTBLANK_Dem_cac_o_trong\" title=\"COUNTBLANK: \u0110\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng. \">COUNTBLANK: \u0110\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng. <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#COUNTIF_Dem_cac_o_thoa_man_dieu_kien\" title=\"COUNTIF: \u0110\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n. \">COUNTIF: \u0110\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n. <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#COUNTIFS_Dem_cac_o_thoa_man_nhieu_dieu_kien\" title=\"COUNTIFS: \u0110\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. \">COUNTIFS: \u0110\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#DCOUNT_Dem_so_o_trong_bang_du_lieu_dua_tren_dieu_kien\" title=\"DCOUNT: \u0110\u1ebfm s\u1ed1 \u00f4 trong b\u1ea3ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n. \">DCOUNT: \u0110\u1ebfm s\u1ed1 \u00f4 trong b\u1ea3ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n. <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#SUMPRODUCT_Dem_voi_dieu_kien_phuc_tap\" title=\"SUMPRODUCT: \u0110\u1ebfm v\u1edbi \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p. \">SUMPRODUCT: \u0110\u1ebfm v\u1edbi \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p. <\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-ham-dem-co-dieu-kien-excel\/#Ket_luan\" title=\"K\u1ebft lu\u1eadn \">K\u1ebft lu\u1eadn <\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tong_hop_cac_loai_ham_dem_co_dieu_kien_trong_Excel\"><\/span><strong>T\u1ed5ng h\u1ee3p c\u00e1c lo\u1ea1i h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong th\u1eddi \u0111\u1ea1i s\u1ed1 h\u00f3a hi\u1ec7n nay, Excel \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng. V\u1edbi kh\u1ea3 n\u0103ng x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, Excel gi\u00fap ch\u00fang ta ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 \u0111\u01b0a ra nh\u1eefng quy\u1ebft \u0111\u1ecbnh ch\u00ednh x\u00e1c h\u01a1n. M\u1ed9t trong nh\u1eefng t\u00ednh n\u0103ng quan tr\u1ecdng c\u1ee7a Excel l\u00e0 c\u00e1c h\u00e0m \u0111\u1ebfm, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4, s\u1ed1 l\u01b0\u1ee3ng \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n, hay s\u1ed1 l\u01b0\u1ee3ng \u00f4 tr\u1ed1ng trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-1024x640.jpg\" alt=\"\" class=\"wp-image-101237\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-8.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n\n\n\n<p>\u0110\u1eb7c bi\u1ec7t v\u1edbi c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 h\u1ea1n ch\u1ebf sai s\u00f3t khi so v\u1edbi c\u00e1ch \u0111\u1ebfm th\u1ee7 c\u00f4ng. C\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n Excel c\u01a1 b\u1ea3n bao g\u1ed3m:<\/p>\n\n\n\n<ul>\n<li><strong>H\u00e0m COUNT<\/strong>: D\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 ch\u1ee9a d\u1eef li\u1ec7u s\u1ed1 trong m\u1ed9t v\u00f9ng ho\u1eb7c to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh.<\/li>\n\n\n\n<li><strong>H\u00e0m COUNTA<\/strong>: \u0110\u1ebfm s\u1ed1 \u00f4 c\u00f3 ch\u1ee9a b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u n\u00e0o, kh\u00f4ng ph\u00e2n bi\u1ec7t ki\u1ec3u d\u1eef li\u1ec7u, nh\u01b0 s\u1ed1, v\u0103n b\u1ea3n, hay ng\u00e0y th\u00e1ng.<\/li>\n\n\n\n<li><strong>H\u00e0m COUNTIF<\/strong>: \u0110\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 \u00f4 th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3.<\/li>\n\n\n\n<li><strong>H\u00e0m COUNTIFS<\/strong>: H\u00e0m n\u00e0y cho ph\u00e9p \u0111\u1ebfm s\u1ed1 \u00f4 th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau, r\u1ea5t h\u1eefu \u00edch khi d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p.<\/li>\n\n\n\n<li><strong>H\u00e0m RANK<\/strong>: D\u00f9ng \u0111\u1ec3 x\u1ebfp h\u1ea1ng m\u1ed9t gi\u00e1 tr\u1ecb so v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c trong c\u00f9ng m\u1ed9t danh s\u00e1ch.<\/li>\n\n\n\n<li><strong>H\u00e0m COLUMN<\/strong>: Tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t trong b\u1ea3ng t\u00ednh, ho\u1eb7c c\u00f3 th\u1ec3 d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 c\u1ed9t trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>H\u00e0m DATEDIF<\/strong>: Gi\u00fap t\u00ednh t\u1ed5ng s\u1ed1 ng\u00e0y, th\u00e1ng, ho\u1eb7c n\u0103m gi\u1eefa hai ng\u00e0y c\u1ee5 th\u1ec3.<\/li>\n\n\n\n<li><strong>H\u00e0m LEN<\/strong>: D\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 c\u00f3 trong m\u1ed9t \u00f4 d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>H\u00e0m DCOUNT<\/strong>: \u0110\u1ebfm s\u1ed1 \u00f4 trong m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u1eb7t ra.<\/li>\n\n\n\n<li><strong>H\u00e0m SUMPRODUCT<\/strong>: \u0110\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n c\u1ea7n \u0111\u1ebfm v\u1edbi nh\u1eefng \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p, b\u1eb1ng c\u00e1ch nh\u00e2n v\u00e0 t\u1ed5ng h\u1ee3p c\u00e1c \u0111i\u1ec1u ki\u1ec7n l\u1ea1i.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-1024x640.jpg\" alt=\"\" class=\"wp-image-101238\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-9.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n\n\n\n<p>C\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c, c\u00e1c h\u00e0m \u0111\u1ebfm trong Excel l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch gi\u00fap ch\u00fang ta nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u. B\u1eb1ng c\u00e1ch hi\u1ec3u r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p, t\u1ea1o c\u00e1c b\u00e1o c\u00e1o chi ti\u1ebft, ti\u1ebft ki\u1ec7m th\u1eddi gian h\u01a1n. H\u00e3y c\u00f9ng Phong V\u0169 \u0111i\u1ec3m danh chi ti\u1ebft c\u00e1c lo\u1ea1i h\u00e0m \u0111\u1ebfm trong Excel d\u01b0\u1edbi \u0111\u00e2y nh\u00e9. <\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cong_dung_va_cach_su_dung_cua_tung_loai_ham_dem\"><\/span><strong>C\u00f4ng d\u1ee5ng v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a t\u1eebng lo\u1ea1i h\u00e0m \u0111\u1ebfm <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Th\u1ef1c t\u1ebf, c\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng. V\u1edbi kh\u1ed1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn, vi\u1ec7c t\u00ecm ki\u1ebfm v\u00e0 \u0111\u1ebfm nh\u1eefng \u00f4 th\u1ecfa m\u00e3n m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 tr\u1edf n\u00ean v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. C\u00e1c h\u00e0m nh\u01b0 <strong>COUNTIF<\/strong> v\u00e0 <strong>COUNTIFS<\/strong> kh\u00f4ng ch\u1ec9 gi\u00fap \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb theo t\u1eebng \u0111i\u1ec1u ki\u1ec7n m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 vi\u1ec7c t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u theo nh\u1eefng ti\u00eau ch\u00ed kh\u00e1c nhau. <\/p>\n\n\n\n<p>Vi\u1ec7c hi\u1ec3u r\u00f5 c\u00f4ng d\u1ee5ng v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a t\u1eebng lo\u1ea1i h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n s\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1eadn d\u1ee5ng t\u1ed1i \u0111a s\u1ee9c m\u1ea1nh c\u1ee7a Excel trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 th\u00f4ng tin chi ti\u1ebft cho t\u1eebng lo\u1ea1i h\u00e0m \u0111\u1ebfn c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"COUNT_Dem_cac_o_chua_so\"><\/span><strong>COUNT: \u0110\u1ebfm c\u00e1c \u00f4 ch\u1ee9a s\u1ed1. <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m <strong>COUNT<\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u1ebfm \u0111\u01a1n gi\u1ea3n v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel. H\u00e0m n\u00e0y cho ph\u00e9p b\u1ea1n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 trong m\u1ed9t ph\u1ea1m vi ho\u1eb7c m\u1ea3ng \u00f4 nh\u1ea5t \u0111\u1ecbnh. \u0110i\u1ec1u n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n ki\u1ec3m tra s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u s\u1ed1 trong m\u1ed9t b\u1ea3ng t\u00ednh.<\/p>\n\n\n\n<ul>\n<li><strong>C\u00fa ph\u00e1p<\/strong>: <strong>=COUNT(value1, [value2], &#8230;)<\/strong>. Trong \u0111\u00f3, value1, value2&#8230; l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5<\/strong>: Gi\u1ea3 s\u1eed trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y, c\u00e1c h\u1ecdc sinh c\u00f3 m\u00e3 s\u1ed1 t\u1eeb A1 \u0111\u1ebfn A10 c\u00f3 \u0111i\u1ec3m t\u1ed5ng k\u1ebft To\u00e1n k\u1ef3 1 v\u00e0 to\u00e1n k\u1ef3 2 d\u01b0\u1edbi 10 \u0111i\u1ec3m \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 l\u00e0 Tr\u01b0\u1ee3t (K\u00fd hi\u1ec7u Tr trong b\u1ea3ng). N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh \u0111\u1ed7 trong k\u1ef3 t\u1ed5ng k\u1ebft, t\u1ee9c l\u00e0 s\u1ed1 l\u01b0\u1ee3ng h\u1ecdc sinh \u0111\u1ea1t gi\u00e1 tr\u1ecb s\u1ed1 t\u1ea1i c\u1ed9t E (\u0110\u1ed7\/Tr\u01b0\u1ee3t), h\u00e3y s\u1eed d\u1ee5ng h\u00e0m COUNT \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb s\u1ed1 xu\u1ea5t hi\u1ec7n. V\u00ed d\u1ee5 c\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1m ki\u1ec7n n\u00e0y \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n trong b\u1ea3ng b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-1024x640.jpg\" alt=\"\" class=\"wp-image-101239\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">\u0110\u1ebfm c\u00e1c \u00f4 ch\u1ee9a s\u1ed1 \u0111\u01a1n gi\u1ea3n v\u1edbi h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNT.<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"COUNTA_Dem_cac_o_khong_trong\"><\/span><strong>COUNTA: \u0110\u1ebfm c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng. <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Kh\u00f4ng gi\u1ed1ng nh\u01b0 h\u00e0m <strong>COUNT<\/strong>, h\u00e0m <strong>COUNTA<\/strong> \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng, b\u1ea5t k\u1ec3 d\u1eef li\u1ec7u trong \u00f4 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n, hay k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. H\u00e0m n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh s\u1ed1 l\u01b0\u1ee3ng \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp li\u1ec7u.<\/p>\n\n\n\n<ul>\n<li><strong>C\u00fa ph\u00e1p<\/strong>:<strong> =COUNTA(value1, [value2], &#8230;)<\/strong>. Trong \u0111\u00f3, value1, value2&#8230; l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5<\/strong>: N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m m\u00e3 s\u1ed1, h\u1ecd t\u00ean h\u1ecdc sinh, \u0111i\u1ec3m to\u00e1n k\u1ef3 1, \u0111i\u1ec3m to\u00e1n k\u1ef3 2, v\u00e0 quy\u1ebft \u0111\u1ecbnh \u0110\u1ed7\/Tr\u01b0\u1ee3t t\u1eeb c\u1ed9t A \u0111\u1ebfn c\u1ed9t E v\u00e0 h\u00e0ng A3 \u0111\u1ebfn A12 nh\u01b0 b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y. Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp d\u1eef li\u1ec7u, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTA v\u1edbi c\u00fa ph\u00e1p nh\u01b0 b\u1ea3ng b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-1024x640.jpg\" alt=\"\" class=\"wp-image-101240\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTA.<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"COUNTBLANK_Dem_cac_o_trong\"><\/span><strong>COUNTBLANK: \u0110\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng. <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m <strong>COUNTBLANK<\/strong> l\u00e0 m\u1ed9t h\u00e0m h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 tr\u1ed1ng trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh nhanh ch\u00f3ng c\u00f3 bao nhi\u00eau \u00f4 ch\u01b0a c\u00f3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp, t\u1eeb \u0111\u00f3 ki\u1ec3m tra \u0111\u1ed9 \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh.<\/p>\n\n\n\n<ul>\n<li><strong>C\u00fa ph\u00e1p<\/strong>:<strong> =COUNTBLANK(range)<\/strong>. Trong \u0111\u00f3, range l\u00e0 ph\u1ea1m vi c\u00e1c \u00f4 c\u1ea7n \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5<\/strong>: N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m H\u1ecd v\u00e0 t\u00ean, L\u1edbp, To\u00e1n, V\u0103n, Ngo\u1ea1i ng\u1eef t\u1eeb c\u1ed9t A \u0111\u1ebfn c\u1ed9t E v\u00e0 h\u00e0ng A3 \u0111\u1ebfn A9 nh\u01b0 b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y. Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u01b0a \u0111\u01b0\u1ee3c nh\u1eadp d\u1eef li\u1ec7u, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTBLANK v\u1edbi c\u00fa ph\u00e1p nh\u01b0 b\u1ea3ng b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-1024x640.jpg\" alt=\"\" class=\"wp-image-101241\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-7.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Th\u1ef1c hi\u1ec7n \u0111\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng v\u1edbi h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTBLANK.<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"COUNTIF_Dem_cac_o_thoa_man_dieu_kien\"><\/span><strong>COUNTIF: \u0110\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n. <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>COUNTIF<\/strong> l\u00e0 m\u1ed9t h\u00e0m m\u1ea1nh m\u1ebd trong Excel, cho ph\u00e9p b\u1ea1n \u0111\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. \u0110i\u1ec1u ki\u1ec7n n\u00e0y c\u00f3 th\u1ec3 l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n m\u1ed9t s\u1ed1 c\u1ee5 th\u1ec3, b\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3, ho\u1eb7c th\u1ecfa m\u00e3n c\u00e1c quy t\u1eafc logic kh\u00e1c.<\/p>\n\n\n\n<ul>\n<li><strong>C\u00fa ph\u00e1p<\/strong>: <strong>=COUNTIF(range, criteria)<\/strong>. Trong \u0111\u00f3, range l\u00e0 ph\u1ea1m vi c\u00e1c \u00f4 c\u1ea7n \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng; criteria l\u00e0 ph\u1ea1m vi \u0111i\u1ec1u ki\u1ec7n (bao g\u1ed3m t\u00ean c\u1ed9t v\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3).<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5<\/strong>: Tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m To\u00e1n k\u1ef3 2 n\u1eb1m \u1edf c\u1ed9t D t\u1eeb D1 \u0111\u1ebfn D10 b\u1eb1ng 6 trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTIF \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb s\u1ed1 6 xu\u1ea5t hi\u1ec7n trong c\u1ed9t D. V\u00ed d\u1ee5 c\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1m ki\u1ec7n n\u00e0y \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n trong b\u1ea3ng b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-1024x640.jpg\" alt=\"\" class=\"wp-image-101242\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch d\u00f9ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTIF.<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"COUNTIFS_Dem_cac_o_thoa_man_nhieu_dieu_kien\"><\/span><strong>COUNTIFS: \u0110\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>N\u1ebfu b\u1ea1n c\u1ea7n \u0111\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n <strong>nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong> \u0111\u1ed3ng th\u1eddi, h\u00e0m <strong>COUNTIFS<\/strong> l\u00e0 c\u00f4ng c\u1ee5 ph\u00f9 h\u1ee3p. H\u00e0m n\u00e0y cho ph\u00e9p b\u1ea1n \u0111\u1eb7t nhi\u1ec1u ti\u00eau ch\u00ed v\u00e0 \u0111\u1ebfm s\u1ed1 \u00f4 th\u1ecfa m\u00e3n t\u1ea5t c\u1ea3 c\u00e1c ti\u00eau ch\u00ed \u0111\u00f3.<\/p>\n\n\n\n<ul>\n<li>C\u00fa ph\u00e1p: <strong>=COUNTIFS(range1, criteria1, [range2], [criteria2], &#8230;).<\/strong> Trong \u0111\u00f3 range1, range2&#8230; l\u00e0 c\u00e1c ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ea7n ki\u1ec3m tra; criteria1, criteria2&#8230; l\u00e0 c\u00e1c \u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng ph\u1ea1m vi.<\/li>\n\n\n\n<li>V\u00ed d\u1ee5: Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m to\u00e1n k\u1ef3 1 n\u1eb1m \u1edf c\u1ed9t C t\u1eeb C3 \u0111\u1ebfn C10 v\u00e0 \u0111i\u1ec3m to\u00e1n k\u1ef3 2 n\u1eb1m \u1edf c\u1ed9t D t\u1eeb D3 \u0111\u1ebfn D10 b\u1eb1ng 7, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTIFS \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m to\u00e1n k\u1ef3 1 v\u00e0 to\u00e1n k\u1ef3 2 th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi 2 ti\u00eau ch\u00ed l\u00e0 b\u1eb1ng 7 theo c\u00f4ng th\u1ee9c b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y.  <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-1024x640.jpg\" alt=\"\" class=\"wp-image-101243\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTIFS.<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"DCOUNT_Dem_so_o_trong_bang_du_lieu_dua_tren_dieu_kien\"><\/span><strong>DCOUNT: \u0110\u1ebfm s\u1ed1 \u00f4 trong b\u1ea3ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n. <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>DCOUNT l\u00e0 m\u1ed9t h\u00e0m \u0111\u1ebfm chuy\u00ean d\u00f9ng cho c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u d\u1ea1ng b\u1ea3ng. N\u00f3 s\u1ebd \u0111\u1ebfm s\u1ed1 \u00f4 trong m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh c\u1ee7a b\u1ea3ng, d\u1ef1a tr\u00ean m\u1ed9t t\u1eadp \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u01b0a ra.<\/p>\n\n\n\n<ul>\n<li>C\u00fa ph\u00e1p: <strong>=DCOUNT(database, field, criteria).<\/strong> Trong \u0111\u00f3 database l\u00e0 ph\u1ea1m vi to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u; field l\u00e0 t\u00ean c\u1ed9t ho\u1eb7c ch\u1ec9 s\u1ed1 c\u1ed9t c\u1ea7n \u0111\u1ebfm (c\u00f3 th\u1ec3 nh\u1eadp t\u00ean c\u1ed9t d\u01b0\u1edbi d\u1ea1ng chu\u1ed7i ho\u1eb7c s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t trong b\u1ea3ng); criteria l\u00e0 ph\u1ea1m vi \u0111i\u1ec1u ki\u1ec7n (bao g\u1ed3m t\u00ean c\u1ed9t v\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3).<\/li>\n\n\n\n<li>V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed cho m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u t\u1ed5ng h\u1ee3p \u0111i\u1ec3m m\u00f4n to\u00e1n \u1edf c\u1ed9t D, m\u00f4n v\u0103n \u1edf c\u1ed9t E v\u00e0 m\u00f4n ngo\u1ea1i ng\u1eef \u1edf c\u1ed9t F c\u1ee7a 6 h\u1ecdc sinh l\u1edbp 12 d\u01b0\u1edbi \u0111\u00e2y. Tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m c\u1ea3 3 m\u00f4n \u0111\u1ec1u tr\u00ean 8, h\u00e3y th\u1ef1c hi\u1ec7n c\u00fa ph\u00e1p h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n DCOUNT nh\u01b0 b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-1024x640.jpg\" alt=\"\" class=\"wp-image-101247\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-5.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 c\u00fa ph\u00e1p h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n DCOUNT.<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"SUMPRODUCT_Dem_voi_dieu_kien_phuc_tap\"><\/span><strong>SUMPRODUCT: \u0110\u1ebfm v\u1edbi \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p. <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMPRODUCT c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng t\u00edch c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c m\u1ea3ng, ho\u1eb7c \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n logic. <\/p>\n\n\n\n<ul>\n<li>C\u00fa ph\u00e1p: <strong>=SUMPRODUCT(array1, [array2], [array3], \u2026)<\/strong>. Trong \u0111\u00f3, array1, array2, array3&#8230; l\u00e0 c\u00e1c ph\u1ea1m vi ho\u1eb7c m\u1ea3ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n nh\u00e2n t\u01b0\u01a1ng \u1ee9ng v\u00e0 sau \u0111\u00f3 t\u00ednh t\u1ed5ng c\u00e1c k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n\n\n\n<ul>\n<li>V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed cho m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m c\u00e1c s\u1ea3n ph\u1ea9m \u0111i\u1ec7n tho\u1ea1i th\u00f4ng minh, gi\u00e1 b\u00e1n v\u00e0 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n ra c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m d\u01b0\u1edbi \u0111\u00e2y. Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng doanh thu c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m, tr\u00ean th\u1ef1c t\u1ebf ch\u00fang c\u1ea7n l\u1ea5y gi\u00e1 b\u00e1n * s\u1ed1 l\u01b0\u1ee3ng b\u00e1n v\u00e0 c\u1ed9ng t\u1ed5ng t\u1ea5t c\u1ea3. Tuy nhi\u00ean h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMPRODUCT s\u1ebd gi\u00fap ch\u00fang ta th\u1ef1c hi\u1ec7n d\u1ec5 d\u00e0ng h\u01a1n. H\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng nh\u00e2n \u0111\u01a1n gi\u00e1 \u1edf c\u1ed9t C v\u00e0 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n \u1edf c\u1ed9t D theo m\u1ed7i s\u1ea3n ph\u1ea9m v\u00e0 sau \u0111\u00f3 c\u1ed9ng d\u1ed3n t\u1ea5t c\u1ea3. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-1024x640.jpg\" alt=\"\" class=\"wp-image-101244\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-dem-co-dieu-kien-trong-excel-6.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMPRODUCT.<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span><strong>K\u1ebft lu\u1eadn <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>S\u1eed d\u1ee5ng \u0111\u00fang c\u00e1ch c\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd m\u1ecdi y\u00eau c\u1ea7u ph\u1ee9c t\u1ea1p m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, t\u1eeb \u0111\u00f3 t\u1ed1i \u01b0u h\u00f3a qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u tr\u00ean Excel. Vi\u1ec7c n\u1eafm v\u1eefng c\u00f4ng d\u1ee5ng v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a c\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap t\u0103ng hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c m\u00e0 c\u00f2n \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c trong c\u00e1c ph\u00e9p t\u00ednh v\u00e0 b\u00e1o c\u00e1o. Phong V\u0169 hi v\u1ecdng nh\u1eefng th\u00f4ng tin tr\u00ean c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n &#8220;th\u00e0nh th\u1ea1o&#8221; h\u01a1n trong vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong Excel, h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch, gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c. Trong b\u00e0i vi\u1ebft n\u00e0y, Phong V\u0169 Tech News s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":101238,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[74,1029,24],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/101049"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=101049"}],"version-history":[{"count":4,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/101049\/revisions"}],"predecessor-version":[{"id":101249,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/101049\/revisions\/101249"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/101238"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=101049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=101049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=101049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}