{"id":3485,"date":"2024-12-03T02:41:23","date_gmt":"2024-12-03T02:41:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cac-ham-cong-thuc-va-nhung-hang-so-mang-trong-excel-vi-du-va-huong-dan-su-dung\/"},"modified":"2024-12-03T02:41:23","modified_gmt":"2024-12-03T02:41:23","slug":"cac-ham-cong-thuc-va-nhung-hang-so-mang-trong-excel-vi-du-va-huong-dan-su-dung","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cac-ham-cong-thuc-va-nhung-hang-so-mang-trong-excel-vi-du-va-huong-dan-su-dung\/","title":{"rendered":"C\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c v\u00e0 nh\u1eefng h\u1eb1ng s\u1ed1 m\u1ea3ng trong Excel, v\u00ed d\u1ee5 v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd \u00a0h\u01b0\u1edbng d\u1eabn c\u00f4ng th\u1ee9c m\u1ea3ng Excel, c\u00e1ch \u0111\u1ec3 nh\u1eadp n\u00f3 ch\u00ednh x\u00e1c trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u1eb1ng s\u1ed1 v\u00e0 c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel.<\/p>\n<p style=\"text-align: justify\">C\u00e1c <strong>c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel<\/strong> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch v\u00e0 c\u0169ng kh\u00f3 nh\u1ea5t \u0111\u1ec3 ki\u1ec3m so\u00e1t \u0111\u01b0\u1ee3c n\u00f3. M\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng Excel \u0111\u01a1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nhi\u1ec1u ph\u00e9p t\u00ednh v\u00e0 thay th\u1ebf h\u00e0ng ng\u00e0n c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng. Tuy nhi\u00ean, \u01b0\u1edbc ch\u1eebng \u0111\u1ebfn 90% ng\u01b0\u1eddi d\u00f9ng Excel ch\u01b0a bao gi\u1edd s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng trong b\u1ea3ng t\u00ednh, ch\u1ec9 v\u00ec h\u1ecd s\u1ee3 ph\u1ea3i b\u1eaft \u0111\u1ea7u h\u1ecdc ch\u00fang t\u1eeb con s\u1ed1 0.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674e6fd27bb17\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Ham_mang_trong_Excel_la_gi\" title=\"H\u00e0m m\u1ea3ng trong Excel l\u00e0 g\u00ec?\">H\u00e0m m\u1ea3ng trong Excel l\u00e0 g\u00ec?<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Vi_du_don_gian_cua_cong_thuc_mang_Excel\" title=\"V\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng Excel\">V\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Tai_sao_phai_su_dung_cong_thuc_mang_trong_Excel\" title=\"T\u1ea1i sao ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel?\">T\u1ea1i sao ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel?<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Lam_the_nao_de_nhap_cong_thuc_mang_trong_Excel_Ctrl_Shift_Enter\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel (Ctrl + Shift + Enter)\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel (Ctrl + Shift + Enter)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Su_dung_phim_F9_de_danh_gia_cac_phan_trong_mot_cong_thuc_mang\" title=\"S\u1eed d\u1ee5ng ph\u00edm F9 \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 c\u00e1c ph\u1ea7n trong m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng:\">S\u1eed d\u1ee5ng ph\u00edm F9 \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 c\u00e1c ph\u1ea7n trong m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Cong_thuc_mang_voi_mot_o_va_nhieu_o_trong_Excel\" title=\"C\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi m\u1ed9t \u00f4 v\u00e0 nhi\u1ec1u \u00f4 trong Excel\">C\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi m\u1ed9t \u00f4 v\u00e0 nhi\u1ec1u \u00f4 trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Vi_du_1_Mot_cong_thuc_mang_voi_o_don\" title=\"V\u00ed d\u1ee5 1. M\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi \u00f4 \u0111\u01a1n\">V\u00ed d\u1ee5 1. M\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi \u00f4 \u0111\u01a1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Vi_du_2_Cong_thuc_mang_da_o_trong_Excel\" title=\"V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c m\u1ea3ng \u0111a \u00f4 trong Excel\">V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c m\u1ea3ng \u0111a \u00f4 trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Vi_du_3_Su_dung_mot_ham_mang_Excel_de_tra_ve_mang_nhieu_o\" title=\"V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng m\u1ed9t h\u00e0m m\u1ea3ng Excel \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ea3ng nhi\u1ec1u \u00f4\">V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng m\u1ed9t h\u00e0m m\u1ea3ng Excel \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ea3ng nhi\u1ec1u \u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Lam_the_nao_de_lam_viec_voi_cac_cong_thuc_mang_nhieu_o\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng nhi\u1ec1u \u00f4\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng nhi\u1ec1u \u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Hang_so_mang_cua_Excel\" title=\"H\u1eb1ng s\u1ed1 m\u1ea3ng c\u1ee7a Excel\">H\u1eb1ng s\u1ed1 m\u1ea3ng c\u1ee7a Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#1_Hang_so_cua_mang_ngang\" title=\"1. H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng ngang\">1. H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng ngang<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#2_Hang_so_cua_mang_doc\" title=\"2. H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng d\u1ecdc:\">2. H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng d\u1ecdc:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#3_Hang_so_cua_mang_hai_chieu\" title=\"3. H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng hai chi\u1ec1u\">3. H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng hai chi\u1ec1u<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Lam_viec_voi_hang_so_mang_cua_Excel\" title=\"L\u00e0m vi\u1ec7c v\u1edbi h\u1eb1ng s\u1ed1 m\u1ea3ng c\u1ee7a Excel\">L\u00e0m vi\u1ec7c v\u1edbi h\u1eb1ng s\u1ed1 m\u1ea3ng c\u1ee7a Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#1_Cac_thanh_phan_cua_mot_hang_so_mang\" title=\"1. C\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng\">1. C\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#2_Hang_so_mang_duoc_dat_ten\" title=\"2. H\u1eb1ng s\u1ed1 m\u1ea3ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean:\">2. H\u1eb1ng s\u1ed1 m\u1ea3ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#3_Ngan_chan_loi\" title=\"3. Ng\u0103n ch\u1eb7n l\u1ed7i\">3. Ng\u0103n ch\u1eb7n l\u1ed7i<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Su_dung_hang_so_mang_trong_cong_thuc_cua_Excel\" title=\"S\u1eed d\u1ee5ng h\u1eb1ng s\u1ed1 m\u1ea3ng trong c\u00f4ng th\u1ee9c c\u1ee7a Excel\">S\u1eed d\u1ee5ng h\u1eb1ng s\u1ed1 m\u1ea3ng trong c\u00f4ng th\u1ee9c c\u1ee7a Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Vi_du_1_Cong_N_cac_so_lon_nhat_nho_nhat_trong_mot_dai\" title=\"V\u00ed d\u1ee5 1. C\u1ed9ng N c\u00e1c s\u1ed1 l\u1edbn nh\u1ea5t \/ nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u1ea3i\">V\u00ed d\u1ee5 1. C\u1ed9ng N c\u00e1c s\u1ed1 l\u1edbn nh\u1ea5t \/ nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u1ea3i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Vi_du_2_Cong_thuc_mang_de_tinh_cac_o_thoa_nhieu_dieu_kien\" title=\"V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ednh c\u00e1c \u00f4 th\u1ecfa nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ednh c\u00e1c \u00f4 th\u1ecfa nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Cac_toan_tu_AND_va_OR_trong_cong_thuc_mang_cua_Excel\" title=\"C\u00e1c to\u00e1n t\u1eed AND v\u00e0 OR trong c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a Excel\">C\u00e1c to\u00e1n t\u1eed AND v\u00e0 OR trong c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Cong_thuc_mang_voi_toan_tu_AND\" title=\"C\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi to\u00e1n t\u1eed AND\">C\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi to\u00e1n t\u1eed AND<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#i\" title=\"\u00a0\">\u00a0<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Cong_thuc_mang_Excel_voi_toan_tu_OR\" title=\"C\u00f4ng th\u1ee9c m\u1ea3ng Excel v\u1edbi to\u00e1n t\u1eed OR\">C\u00f4ng th\u1ee9c m\u1ea3ng Excel v\u1edbi to\u00e1n t\u1eed OR<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html#Toan_tu_don_vi_doi_dieu_hanh_trong_cong_thuc_mang_cua_Excel\" title=\"To\u00e1n t\u1eed \u0111\u01a1n v\u1ecb \u0111\u00f4i \u0111i\u1ec1u h\u00e0nh trong c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a Excel\">To\u00e1n t\u1eed \u0111\u01a1n v\u1ecb \u0111\u00f4i \u0111i\u1ec1u h\u00e0nh trong c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_mang_trong_Excel_la_gi\"><\/span>H\u00e0m m\u1ea3ng trong Excel l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc khi ch\u00fang ta b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m v\u00e0 c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng Excel, th\u00ec ch\u00fang ta h\u00e3y t\u00ecm hi\u1ec3u r\u1eb1ng th\u1ebf n\u00e0o l\u00e0 thu\u1eadt ng\u1eef \u201cm\u1ea3ng\u201d. V\u1ec1 c\u01a1 b\u1ea3n, m\u1ed9t m\u1ea3ng trong Excel l\u00e0 m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c m\u1ee5c. C\u00e1c m\u1ee5c c\u00f3 th\u1ec3 l\u00e0 v\u0103n b\u1ea3n ho\u1eb7c s\u1ed1 v\u00e0 ch\u00fang c\u00f3 th\u1ec3 n\u1eb1m trong m\u1ed9t h\u00e0ng\/c\u1ed9t, ho\u1eb7c trong nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n nh\u1eadp danh s\u00e1ch mua h\u00e0ng h\u00e0ng tu\u1ea7n c\u1ee7a b\u1ea1n v\u00e0o m\u1ed9t \u0111\u1ecbnh d\u1ea1ng m\u1ea3ng Excel, th\u00ec n\u00f3 s\u1ebd ki\u1ec3u nh\u01b0:<\/p>\n<p style=\"text-align: justify\">{\u201cMilk\u201d, \u201cEggs\u201d, \u201cButter\u201d, \u201cCorn flakes\u201d}<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, n\u1ebfu b\u1ea1n ch\u1ecdn c\u00e1c \u00f4 t\u1eeb A1 \u0111\u1ebfn D1, th\u00ec h\u00e3y nh\u1eadp m\u1ea3ng \u1edf tr\u00ean v\u1edbi d\u1ea5u b\u1eb1ng (=) tr\u00ean thanh c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n CTRL + SHIFT + ENTER, v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-array.png\" alt=\"Creating an array in Excel\" title=\"excel-array\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-116.gif\" title=\"vba101_92019-nho-116\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-269.gif\" title=\"ex101_92019-nho-269\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Nh\u1eefng g\u00ec b\u1ea1n v\u1eeba l\u00e0m l\u00e0 t\u1ea1o m\u1ed9t m\u1ea3ng m\u1ed9t chi\u1ec1u theo chi\u1ec1u ngang. N\u00e3y gi\u1edd m\u1ecdi th\u1ee9 v\u1eabn r\u1ea5t \u0111\u01a1n gi\u1ea3n, ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, c\u00f4ng th\u1ee9c m\u1ea3ng Excel l\u00e0 g\u00ec? S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa m\u1ed9t h\u00e0m m\u1ea3ng v\u00e0 c\u00e1c h\u00e0m Excel th\u00f4ng th\u01b0\u1eddng kh\u00e1c l\u00e0 h\u00e0m m\u1ea3ng s\u1ebd x\u1eed l\u00fd nhi\u1ec1u thay v\u00ec ch\u1ec9 m\u1ed9t gi\u00e1 tr\u1ecb m\u00e0 th\u00f4i. N\u00f3i c\u00e1ch kh\u00e1c, m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel s\u1ebd \u0111\u00e1nh gi\u00e1 t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang l\u1ebb trong m\u1ed9t m\u1ea3ng, v\u00e0 th\u1ef1c hi\u1ec7n nhi\u1ec1u ph\u00e9p t\u00ednh tr\u00ean m\u1ed9t ho\u1eb7c nhi\u1ec1u m\u1ee5c m\u00e0 c\u00f3 th\u1ecfa c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb trong c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng kh\u00f4ng ch\u1ec9 x\u1eed l\u00fd \u0111\u1ed3ng th\u1eddi m\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb, m\u00e0 n\u00f3 c\u0169ng c\u00f3 th\u1ec3 c\u00f9ng 1 l\u00fac tr\u1ea3 l\u1ea1i m\u1ed9t s\u1ed1 c\u00e1c gi\u00e1 tr\u1ecb. V\u00ec th\u1ebf, c\u00e1c k\u1ebft qu\u1ea3 tr\u1ea3 l\u1ea1i b\u1edfi c\u00f4ng th\u1ee9c m\u1ea3ng c\u0169ng l\u00e0 m\u1ed9t m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c m\u1ea3ng c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n c\u1ee7a Excel 2013, <a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">Excel 2010<\/a>, Excel 2007 v\u00e0 tr\u01b0\u1edbc \u0111\u00f3 n\u1eefa.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, c\u00f3 v\u1ebb nh\u01b0 \u0111\u00e3 \u0111\u1ebfn l\u00fac b\u1ea1n n\u00ean t\u1ea1o c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ea7u ti\u00ean cho b\u1ea1n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_don_gian_cua_cong_thuc_mang_Excel\"><\/span>V\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 m\u1ee5c trong c\u1ed9t B, v\u00e0 c\u1ed9t C bi\u1ec3u th\u1ecb gi\u00e1 c\u1ee7a ch\u00fang, b\u00e0i to\u00e1n c\u1ee7a b\u1ea1n l\u00e0 t\u00ednh t\u1ed5ng doanh thu.<\/p>\n<p style=\"text-align: justify\">T\u1ea5t nhi\u00ean, kh\u00f4ng c\u00f3 g\u00ec ng\u0103n c\u1ea3n b\u1ea1n t\u00ednh c\u00e1c t\u1ed5ng ph\u1ee5 (Sub total) trong m\u1ed7i h\u00e0ng v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n nh\u01b0 = B2 * C2, v\u00e0 r\u1ed3i sau \u0111\u00f3 c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 l\u1ea1i v\u1edbi nhau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/usual-excel-formula.png\" alt=\"A usual Excel formula\" title=\"usual-excel-formula\"><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng c\u00f3 th\u1ec3 mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng \u0111i\u1ec3m \u0111\u1ed9t ph\u00e1 quan tr\u1ecdng, t\u1eeb khi n\u00f3 \u0111\u01b0\u1ee3c Excel d\u00f9ng trong l\u01b0u tr\u1eef k\u1ebft qu\u1ea3 trung gian trong b\u1ed9 nh\u1edb, thay v\u00ec ph\u1ea3i t\u1ea1o th\u00eam c\u1ed9t b\u1ed5 sung. V\u00ec v\u1eady, m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u01a1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n 2 b\u01b0\u1edbc nhanh ch\u00f3ng nho nh\u1ecf nh\u01b0 sau \u0111\u1ec3 gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n tr\u00ean:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng v\u00e0 nh\u1eadp v\u00e0o c\u00f4ng th\u1ee9c sau:<\/li>\n<\/ol>\n<p style=\"text-align: justify\">= SUM (B2: B6 * C2: C6)<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Nh\u1ea5n ph\u00edm t\u1eaft CTRL + SHIFT + ENTER \u0111\u1ec3 ho\u00e0n t\u1ea5t c\u00f4ng th\u1ee9c m\u1ea3ng.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Khi nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm tr\u00ean, Microsoft Excel \u0111\u1eb7t c\u00f4ng th\u1ee9c tr\u00ean trong {d\u1ea5u ngo\u1eb7c nh\u1ecdn}, hay \u0111\u01b0\u1ee3c g\u1ecdi m\u1ed9t d\u1ea5u hi\u1ec7u d\u1ec5 nh\u00ecn th\u1ea5y cho bi\u1ebft \u0111\u00f3 l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c s\u1ebd nh\u00e2n gi\u00e1 tr\u1ecb trong m\u1ed7i h\u00e0ng ri\u00eang c\u1ee7a m\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh (c\u00e1c \u00f4 t\u1eeb B2 \u0111\u1ebfn C6), c\u00f3 th\u00eam c\u00e1c t\u1ed5ng (ph\u1ee5), v\u00e0 k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng l\u00e0 t\u1ed5ng doanh thu.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-array-formula-1.png\" alt=\"An array formula\" title=\"excel-array-formula-1\"><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n tr\u00ean cho th\u1ea5y s\u1ee9c m\u1ea1nh c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel. Khi l\u00e0m vi\u1ec7c v\u1edbi h\u00e0ng tr\u0103m ho\u1eb7c h\u00e0ng ng\u00e0n h\u00e0ng ch\u1ee9a d\u1eef li\u1ec7u, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 c\u00e2n nh\u1eafc khi n\u00f3 s\u1ebd ti\u1ebft ki\u1ec7m bao nhi\u00eau th\u1eddi gian v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng trong m\u1ed7i \u00f4.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tai_sao_phai_su_dung_cong_thuc_mang_trong_Excel\"><\/span>T\u1ea1i sao ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c m\u1ea3ng Excel l\u00e0 c\u00f4ng c\u1ee5 ti\u1ec7n d\u1ee5ng nh\u1ea5t \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh tinh vi v\u00e0 c\u00e1c t\u00e1c v\u1ee5 ph\u1ee9c t\u1ea1p. M\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u01a1n c\u00f3 th\u1ec3 thay th\u1ebf h\u00e0ng tr\u0103m c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng. C\u00f4ng th\u1ee9c m\u1ea3ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho c\u00e1c c\u00f4ng vi\u1ec7c nh\u01b0:<\/p>\n<ul style=\"text-align: justify\">\n<li>T\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 th\u1ecfa c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 cho, v\u00ed d\u1ee5 t\u00ednh t\u1ed5ng N gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ho\u1eb7c nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u1ea3i.<\/li>\n<li>T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb c\u00e1c h\u00e0ng, ho\u1eb7c trong h\u00e0ng\/c\u1ed9t th\u1ee9 N.<\/li>\n<li>\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a t\u1ea5t c\u1ea3 ho\u1eb7c \u0111\u1ebfm nh\u1eefng k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t d\u1ea3i x\u00e1c \u0111\u1ecbnh.<\/li>\n<\/ul>\n<blockquote>\n<p>Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">c\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng trong Excel<\/a><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_nhap_cong_thuc_mang_trong_Excel_Ctrl_Shift_Enter\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel (Ctrl + Shift + Enter)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm CTRL + SHIFT + ENTER l\u00e0 m\u1ed9t ph\u01b0\u01a1ng th\u1ee9c k\u1ef3 di\u1ec7u \u0111\u1ec3 bi\u1ebfn m\u1ed9t c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng th\u00e0nh m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">Khi nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel, c\u00f3 4 \u0111i\u1ec1u quan tr\u1ecdng m\u00e0 b\u1ea1n c\u1ea7n ghi nh\u1edb:<\/p>\n<ol style=\"text-align: justify\">\n<li>M\u1ed9t khi b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh g\u00f5 c\u00f4ng th\u1ee9c v\u00e0 \u0111\u1ed3ng th\u1eddi nh\u1ea5n c\u00e1c ph\u00edm CTRL + SHIFT+ ENTER, th\u00ec Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u1eb7t c\u00f4ng th\u1ee9c \u0111\u00f3 trong {d\u1ea5u ngo\u1eb7c nh\u1ecdn}. Khi b\u1ea1n ch\u1ecdn m\u1ed9t\/c\u00e1c \u00f4 nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y c\u00e1c d\u1ea5u ngo\u1eb7c nh\u1ecdn trong thanh c\u00f4ng th\u1ee9c, \u0111i\u1ec1u n\u00e0y cho b\u1ea1n bi\u1ebft r\u1eb1ng c\u00f3 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng trong \u0111\u00f3.<\/li>\n<li>Vi\u1ec7c nh\u1eadp c\u00e1c d\u1ea5u ngo\u1eb7c nh\u1ecdn bao quanh c\u00f4ng th\u1ee9c b\u1eb1ng tay s\u1ebd kh\u00f4ng chuy\u1ec3n c\u00f4ng th\u1ee9c tr\u00ean sang \u0111\u1ecbnh d\u1ea1ng m\u1ea3ng. B\u1ea1n ph\u1ea3i nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c m\u1ea3ng.<\/li>\n<li>M\u1ed7i l\u1ea7n b\u1ea1n ch\u1ec9nh s\u1eeda m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, c\u00e1c d\u1ea5u ngo\u1eb7c nh\u1ecdn s\u1ebd bi\u1ebfn m\u1ea5t v\u00e0 b\u1ea1n ph\u1ea3i nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 l\u01b0u c\u00e1c thay \u0111\u1ed5i trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n.<\/li>\n<li>N\u1ebfu b\u1ea1n qu\u00ean nh\u1ea5n Ctrl + Shift + Enter, th\u00ec c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd ho\u1ea1t \u0111\u1ed9ng nh\u01b0 m\u1ed9t c\u00f4ng th\u1ee9c Excel th\u00f4ng th\u01b0\u1eddng v\u00e0 ch\u1ec9 x\u1eed l\u00fd c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean trong m\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">B\u1edfi v\u00ec t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel \u0111\u1ec1u \u0111\u00f2i h\u1ecfi ph\u1ea3i nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter, \u0111\u00f4i khi \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 c\u00f4ng th\u1ee9c CSE.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_phim_F9_de_danh_gia_cac_phan_trong_mot_cong_thuc_mang\"><\/span>S\u1eed d\u1ee5ng ph\u00edm F9 \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 c\u00e1c ph\u1ea7n trong m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel, b\u1ea1n c\u00f3 th\u1ec3 quan s\u00e1t c\u00e1ch ch\u00fang t\u00ednh to\u00e1n v\u00e0 l\u01b0u tr\u1eef c\u00e1c m\u1ee5c c\u1ee7a m\u1ea3ng (m\u1ea3ng n\u1ed9i b\u1ed9) \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng trong m\u1ed9t \u00f4. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111\u1ed1i s\u1ed1 b\u00ean trong ngo\u1eb7c \u0111\u01a1n c\u1ee7a m\u1ed9t h\u00e0m, r\u1ed3i sau \u0111\u00f3 nh\u1ea5n ph\u00edm F9. \u0110\u1ec3 t\u1eaft ch\u1ebf \u0111\u1ed9 \u0111\u00e1nh gi\u00e1 c\u00f4ng th\u1ee9c, h\u00e3y nh\u1ea5n ph\u00edm Esc.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 tr\u00ean, \u0111\u1ec3 xem c\u00e1c t\u1ed5ng ph\u1ee5 (sub-total) c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m, b\u1ea1n c\u1ea7n ch\u1ecdn B2: B6 * C2: C6, r\u1ed3i nh\u1ea5n F9 v\u00e0 thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/view-internal-arrays.png\" alt=\"Use the F9 key to see how they calculate and store internal arrays.\" title=\"view-internal-arrays\"><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd: H\u00e3y l\u01b0u \u00fd r\u1eb1ng b\u1ea1n ph\u1ea3i ch\u1ecdn m\u1ed9t s\u1ed1 ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c tr\u01b0\u1edbc khi nh\u1ea5n ph\u00edm F9, n\u1ebfu kh\u00f4ng khi nh\u1ea5n F9 th\u00ec n\u00f3 s\u1ebd ch\u1ec9 \u0111\u01a1n gi\u1ea3n thay th\u1ebf c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a b\u1ea1n b\u1eb1ng (c\u00e1c) gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n m\u00e0 th\u00f4i.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_mang_voi_mot_o_va_nhieu_o_trong_Excel\"><\/span>C\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi m\u1ed9t \u00f4 v\u00e0 nhi\u1ec1u \u00f4 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c m\u1ea3ng c\u00f3 th\u1ec3 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 trong m\u1ed9t \u00f4 ho\u1eb7c trong nhi\u1ec1u \u00f4. M\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o trong m\u1ed9t d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 c\u00f4ng th\u1ee9c \u0111a \u00f4. C\u00f4ng th\u1ee9c m\u1ea3ng n\u1eb1m trong m\u1ed9t \u00f4 duy nh\u1ea5t \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 c\u00f4ng th\u1ee9c \u00f4 \u0111\u01a1n.<\/p>\n<p style=\"text-align: justify\">C\u00f3 m\u1ed9t v\u00e0i h\u00e0m m\u1ea3ng \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 tr\u1ea3 v\u1ec1 c\u00e1c m\u1ea3ng \u0111a \u00f4, v\u00ed d\u1ee5 nh\u01b0 TRANSPOSE, TREND, FREQUENCY, LINEST, v.v.<\/p>\n<p style=\"text-align: justify\">C\u00e1c h\u00e0m kh\u00e1c, ch\u1eb3ng h\u1ea1n nh\u01b0 SUM, AVERAGE, AGGREGATE, MAX, MIN, c\u00f3 th\u1ec3 t\u00ednh to\u00e1n bi\u1ec3u th\u1ee9c m\u1ea3ng khi nh\u1eadp v\u00e0o m\u1ed9t \u00f4 duy nh\u1ea5t b\u1eb1ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter.<\/p>\n<p style=\"text-align: justify\">C\u00e1c v\u00ed d\u1ee5 sau minh ho\u1ea1 c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng m\u1ed9t \u00f4 v\u00e0 nhi\u1ec1u \u00f4 trong Excel.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Mot_cong_thuc_mang_voi_o_don\"><\/span>V\u00ed d\u1ee5 1. M\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi \u00f4 \u0111\u01a1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 hai c\u1ed9t li\u1ec7t k\u00ea s\u1ed1 l\u01b0\u1ee3ng m\u1eb7t h\u00e0ng \u0111\u01b0\u1ee3c b\u00e1n trong 2 th\u00e1ng kh\u00e1c nhau, v\u00ed d\u1ee5 c\u1ed9t B v\u00e0 c\u1ed9t C, v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm s\u1ed1 doanh thu t\u0103ng l\u1edbn nh\u1ea5t c\u00f3 th\u1ec3.<\/p>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n s\u1ebd th\u00eam m\u1ed9t c\u1ed9t b\u1ed5 sung, v\u00ed d\u1ee5 c\u1ed9t D, t\u00ednh doanh thu thay \u0111\u1ed5i cho m\u1ed7i s\u1ea3n ph\u1ea9m, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 = C2-B2, v\u00e0 sau \u0111\u00f3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong c\u1ed9t b\u1ed5 sung \u0111\u00f3 = MAX (D: D).<\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng Excel kh\u00f4ng c\u1ea7n m\u1ed9t c\u1ed9t b\u1ed5 sung v\u00ec n\u00f3 l\u01b0u tr\u1eef ho\u00e0n h\u1ea3o t\u1ea5t c\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 trung gian trong b\u1ed9 nh\u1edb. V\u00ec v\u1eady, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0 nh\u1ea5n Ctrl + Shift + Enter m\u00e0 th\u00f4i:<\/p>\n<p style=\"text-align: justify\">= MAX (C2: C6-B2: B6)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/single-cell-array-formula.png\" alt=\"A single-cell MAX array formula\" title=\"single-cell-array-formula\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Cong_thuc_mang_da_o_trong_Excel\"><\/span>V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c m\u1ea3ng \u0111a \u00f4 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 tr\u01b0\u1edbc c\u1ee7a h\u00e0m SUM, gi\u1ea3 s\u1eed b\u1ea1n ph\u1ea3i tr\u1ea3 10% thu\u1ebf cho m\u1ed7i l\u1ea7n b\u00e1n v\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh s\u1ed1 ti\u1ec1n tr\u1ea3 thu\u1ebf cho m\u1ed7i s\u1ea3n ph\u1ea9m ch\u1ec9 v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n c\u1ea7n ch\u1ecdn d\u1ea3i \u00f4 trong m\u1ed9t c\u1ed9t tr\u1ed1ng, v\u00ed nh\u01b0 D2: D6, v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o thanh c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\">= B2: B6 * C2: C6 * 0,1<\/p>\n<p style=\"text-align: justify\">M\u1ed9t khi b\u1ea1n nh\u1ea5n Ctrl + Shift + Enter, th\u00ec Excel s\u1ebd \u0111\u1eb7t c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a b\u1ea1n trong m\u1ed7i \u00f4 trong d\u1ea3i \u0111\u00e3 ch\u1ecdn, v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/multi-cell-array-formula.png\" alt=\"A multi-cell array formula in Excel\" title=\"multi-cell-array-formula\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_Su_dung_mot_ham_mang_Excel_de_tra_ve_mang_nhieu_o\"><\/span>V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng m\u1ed9t h\u00e0m m\u1ea3ng Excel \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ea3ng nhi\u1ec1u \u00f4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, th\u00ec Microsoft Excel cung c\u1ea5p m\u1ed9t v\u00e0i c\u00e1i g\u1ecdi l\u00e0 \u201cc\u00e1c h\u00e0m m\u1ea3ng\u201d \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c m\u1ea3ng \u0111a \u00f4. H\u00e0m TRANSPOSE l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m nh\u01b0 v\u1eady v\u00e0 ch\u00fang t\u00f4i s\u1ebd s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i v\u1ecb tr\u00ed trong b\u1ea3ng \u1edf tr\u00ean, t\u1ee9c l\u00e0 chuy\u1ec3n h\u00e0ng sang c\u1ed9t v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn m\u1ed9t d\u1ea3i c\u00e1c \u00f4 tr\u1ed1ng m\u00e0 b\u1ea1n mu\u1ed1n xu\u1ea5t ra b\u1ea3ng sau khi chuy\u1ec3n \u0111\u1ed5i. V\u00ec ch\u00fang ta \u0111ang chuy\u1ec3n \u0111\u1ed5i c\u00e1c h\u00e0ng th\u00e0nh c\u00e1c c\u1ed9t, n\u00ean h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n ch\u1ecdn c\u00f9ng m\u1ed9t s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t nh\u01b0 s\u1ed1 c\u00e1c c\u1ed9t v\u00e0 c\u00e1c h\u00e0ng t\u01b0\u01a1ng \u1ee9ng trong b\u1ea3ng ngu\u1ed3n (b\u1ea3ng g\u1ed1c) b\u1ea1n c\u00f3. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang t\u00f4i \u0111ang l\u1ef1a ch\u1ecdn 6 c\u1ed9t v\u00e0 4 h\u00e0ng.<\/li>\n<li>Nh\u1ea5n F2 \u0111\u1ec3 v\u00e0o ch\u1ebf \u0111\u1ed9 ch\u1ec9nh s\u1eeda.<\/li>\n<li>Nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng: = TRANSPOSE (array) v\u00e0 nh\u1ea5n Ctrl + Shift + Enter. Trong v\u00ed d\u1ee5 tr\u00ean, c\u00f4ng th\u1ee9c l\u00e0 = TRANSPOSE ($A$1: $D$6).<\/li>\n<\/ol>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 s\u1ebd t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-array-function.png\" alt=\"Using an array function in Excel\" title=\"excel-array-function\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_lam_viec_voi_cac_cong_thuc_mang_nhieu_o\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng nhi\u1ec1u \u00f4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng \u0111a \u00f4 trong Excel, h\u00e3y \u0111\u1ea3m b\u1ea3o tu\u00e2n theo c\u00e1c quy t\u1eafc d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn d\u1ea3i \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n xu\u1ea5t ra k\u1ebft qu\u1ea3 tr\u01b0\u1edbc khi nh\u1eadp c\u00f4ng th\u1ee9c.<\/li>\n<li>\u0110\u1ec3 x\u00f3a m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng \u0111a \u00f4, ho\u1eb7c l\u00e0 b\u1ea1n s\u1ebd ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a n\u00f3 v\u00e0 nh\u1ea5n DELETE, ho\u1eb7c b\u1ea1n ph\u1ea3i ch\u1ecdn to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c trong thanh c\u00f4ng th\u1ee9c, nh\u1ea5n DELETE, v\u00e0 sau \u0111\u00f3 nh\u1ea5n Ctrl + Shift + Enter.<\/li>\n<li>B\u1ea1n kh\u00f4ng th\u1ec3 ch\u1ec9nh s\u1eeda ho\u1eb7c di chuy\u1ec3n n\u1ed9i dung c\u1ee7a m\u1ed9t \u00f4 ri\u00eang l\u1ebb trong m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a Excel, v\u00e0 b\u1ea1n c\u0169ng kh\u00f4ng th\u1ec3 ch\u00e8n c\u00e1c \u00f4 m\u1edbi v\u00e0o ho\u1eb7c x\u00f3a c\u00e1c \u00f4 hi\u1ec7n t\u1ea1i t\u1eeb m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng \u0111a \u00f4. B\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n th\u1eed l\u00e0m \u0111i\u1ec1u n\u00e0y, th\u00ec Microsoft Excel s\u1ebd \u0111\u1ec1u \u0111\u01b0a ra c\u1ea3nh b\u00e1o <strong><em>You cannot change part of an array <\/em><\/strong>(\u201cB\u1ea1n kh\u00f4ng th\u1ec3 thay \u0111\u1ed5i m\u1ed9t ph\u1ea7n c\u1ee7a m\u1ea3ng\u201d).<\/li>\n<li>\u0110\u1ec3 thu nh\u1ecf c\u00f4ng th\u1ee9c m\u1ea3ng, t\u1ee9c l\u00e0 \u00e1p d\u1ee5ng n\u00f3 cho \u00edt \u00f4 h\u01a1n, b\u1ea1n c\u1ea7n ph\u1ea3i xo\u00e1 c\u00f4ng th\u1ee9c hi\u1ec7n t\u1ea1i tr\u01b0\u1edbc r\u1ed3i m\u1edbi nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c m\u1edbi v\u00e0o.<\/li>\n<li>\u0110\u1ec3 m\u1edf r\u1ed9ng c\u00f4ng th\u1ee9c m\u1ea3ng, v\u00ed d\u1ee5 \u00e1p d\u1ee5ng n\u00f3 cho nhi\u1ec1u \u00f4 h\u01a1n, b\u1ea1n c\u1ea7n ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c hi\u1ec7n t\u1ea1i c\u1ed9ng v\u1edbi c\u00e1c \u00f4 r\u1ed7ng m\u00e0 b\u1ea1n mu\u1ed1n c\u00f3 c\u00f4ng th\u1ee9c trong \u0111\u00f3, r\u1ed3i nh\u1ea5n F2 \u0111\u1ec3 chuy\u1ec3n sang ch\u1ebf \u0111\u1ed9 ch\u1ec9nh s\u1eeda, \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh c\u00e1c tham chi\u1ebfu trong c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 c\u1eadp nh\u1eadt n\u00f3.<\/li>\n<li>B\u1ea1n kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng \u0111a \u00f4 trong \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng Excel.<\/li>\n<li>B\u1ea1n n\u00ean nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng \u0111a \u00f4 trong m\u1ed9t d\u1ea3i \u00f4 c\u00f3 c\u00f9ng k\u00edch c\u1ee1 v\u1edbi m\u1ea3ng c\u00f3 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. N\u1ebfu c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel c\u1ee7a b\u1ea1n ch\u1ee9a m\u1ed9t m\u1ea3ng m\u00e0 l\u1edbn h\u01a1n d\u1ea3i b\u1ea1n \u0111\u00e3 ch\u1ecdn, th\u00ec nh\u1eefng gi\u00e1 tr\u1ecb v\u01b0\u1ee3t qu\u00e1 s\u1ebd kh\u00f4ng xu\u1ea5t hi\u1ec7n tr\u00ean b\u1ea3ng t\u00ednh. N\u1ebfu m\u1ed9t m\u1ea3ng tr\u1ea3 v\u1ec1 b\u1edfi c\u00f4ng th\u1ee9c nh\u1ecf m\u00e0 h\u01a1n d\u1ea3i \u0111\u00e3 ch\u1ecdn, l\u1ed7i <strong><em># N \/ A<\/em><\/strong> s\u1ebd xu\u1ea5t hi\u1ec7n trong c\u00e1c \u00f4 b\u1ed5 sung.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng v\u1edbi m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng c\u00e1c ph\u1ea7n t\u1eed c\u00f3 th\u1ec3 thay \u0111\u1ed5i, th\u00ec h\u00e3y nh\u1eadp n\u00f3 v\u00e0o m\u1ed9t d\u1ea3i b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n m\u1ea3ng l\u1edbn nh\u1ea5t m\u00e0 \u0111\u01b0\u1ee3c b\u1edfi c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 v\u00e0 h\u00e3y l\u1ed3ng c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n trong h\u00e0m IFERROR.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Hang_so_mang_cua_Excel\"><\/span>H\u1eb1ng s\u1ed1 m\u1ea3ng c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong Microsoft Excel, m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 m\u1ed9t t\u1eadp c\u00e1c gi\u00e1 tr\u1ecb c\u1ed1 \u0111\u1ecbnh. C\u00e1c gi\u00e1 tr\u1ecb n\u00e0y kh\u00f4ng bao gi\u1edd thay \u0111\u1ed5i khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n \u0111\u00e3 l\u00e0m m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 m\u1ea3ng \u0111\u01b0\u1ee3c t\u1ea1o t\u1eeb m\u1ed9t danh s\u00e1ch h\u00e0ng h\u00f3a c\u1ea7n mua trong ph\u1ea7n \u0111\u1ea7u c\u1ee7a b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y. B\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y c\u00f9ng xem c\u00e1c lo\u1ea1i m\u1ea3ng kh\u00e1c nh\u01b0 th\u1ebf n\u00e0o v\u00e0 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 l\u1eadp ra ch\u00fang.<\/p>\n<p style=\"text-align: justify\">T\u1ed3n t\u1ea1i 3 lo\u1ea1i c\u1ee7a h\u1eb1ng s\u1ed1 m\u1ea3ng trong Excel:<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Hang_so_cua_mang_ngang\"><\/span>1. H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng ngang<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng ngang \u0111\u01b0\u1ee3c \u0111\u1eb7t ch\u1ec9 trong m\u1ed9t h\u00e0ng. \u0110\u1ec3 t\u1ea1o m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng h\u00e0ng, h\u00e3y nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c c\u00e1ch nhau b\u1edfi d\u1ea5u ph\u1ea9y, v\u00e0 \u0111\u1eb7t ch\u00fang trong d\u1ea5u ngo\u1eb7c nh\u1ecdn, v\u00ed d\u1ee5: {1,2,3,4}<\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd. Khi t\u1ea1o m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng, b\u1ea1n ph\u1ea3i nh\u1eadp b\u1eb1ng tay c\u00e1c d\u1ea5u \u0111\u00f3ng v\u00e0 m\u1edf ngo\u1eb7c. \u0110\u1ec3 nh\u1eadp m\u1ed9t m\u1ea3ng theo chi\u1ec1u ngang trong m\u1ed9t b\u1ea3ng t\u00ednh, h\u00e3y ch\u1ecdn s\u1ed1 t\u01b0\u01a1ng \u1ee9ng c\u1ee7a c\u00e1c \u00f4 tr\u1ed1ng trong m\u1ed9t h\u00e0ng, v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c = {1,2,3,4} trong thanh c\u00f4ng th\u1ee9c, r\u1ed3i k\u1ebf ti\u1ebfp nh\u1ea5n Ctrl + Shift + Enter. K\u1ebft qu\u1ea3 s\u1ebd gi\u1ed1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vertical-array-constant.png\" alt=\"Horizontal array constant\" title=\"vertical-array-constant\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh, th\u00ec Microsoft Excel \u0111\u1eb7t h\u1eb1ng s\u1ed1 m\u1ea3ng trong m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c d\u1ea5u ngo\u1eb7c nh\u1ecdn kh\u00e1c, gi\u1ed1ng nh\u01b0 khi b\u1ea1n \u0111ang nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_Hang_so_cua_mang_doc\"><\/span>2. H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng d\u1ecdc:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng d\u1ecdc \u0111\u01b0\u1ee3c \u0111\u1eb7t trong m\u1ed9t c\u1ed9t. B\u1ea1n t\u1ea1o ra n\u00f3 b\u1eb1ng c\u00e1ch t\u01b0\u01a1ng t\u1ef1 nh\u01b0 m\u1ed9t m\u1ea3ng ngang, v\u1edbi s\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t l\u00e0 b\u1ea1n ng\u0103n c\u00e1ch c\u00e1c m\u1ee5c b\u1eb1ng d\u1ea5u ch\u1ea5m ph\u1ea9y, v\u00ed d\u1ee5: = {11; 22; 33; 44}<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/horisontal-array-constant.png\" alt=\"Vertical array constant\" title=\"horisontal-array-constant\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_Hang_so_cua_mang_hai_chieu\"><\/span>3. H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng hai chi\u1ec1u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o m\u1ed9t m\u1ea3ng hai chi\u1ec1u trong Excel, b\u1ea1n t\u00e1ch c\u00e1c m\u1ee5c trong m\u1ed7i h\u00e0ng ra b\u1eb1ng d\u1ea5u ph\u1ea9y, v\u00e0 ng\u0103n c\u00e1ch m\u1ed7i c\u1ed9t b\u1eb1ng d\u1ea5u ch\u1ea5m ph\u1ea9y = {\u201ca\u201d, \u201cb\u201d, \u201cc\u201d; 1, 2, 3}<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/two-dimensional-array.png\" alt=\"Two-dimensional array constant\" title=\"two-dimensional-array\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_viec_voi_hang_so_mang_cua_Excel\"><\/span>L\u00e0m vi\u1ec7c v\u1edbi h\u1eb1ng s\u1ed1 m\u1ea3ng c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u1eb1ng s\u1ed1 m\u1ea3ng l\u00e0 m\u1ed9t trong nh\u1eefng n\u1ec1n t\u1ea3ng c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel. C\u00e1c th\u00f4ng tin v\u00e0 m\u1eb9o nh\u1ecf d\u01b0\u1edbi \u0111\u00e2y c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng ch\u00fang m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Cac_thanh_phan_cua_mot_hang_so_mang\"><\/span>1. C\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng c\u00f3 th\u1ec3 ch\u1ee9a c\u00e1c con s\u1ed1, gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, gi\u00e1 tr\u1ecb Booleans (TRUE v\u00e0 FALSE) v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb l\u1ed7i, ch\u00fang \u0111\u01b0\u1ee3c ng\u0103n t\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y ho\u1eb7c d\u1ea5u ch\u1ea5m ph\u1ea9y.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 d\u01b0\u1edbi d\u1ea1ng s\u1ed1 nguy\u00ean, th\u1eadp ph\u00e2n, ho\u1eb7c k\u00fd hi\u1ec7u khoa h\u1ecdc. N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p (\u201c\u201d) nh\u01b0 trong b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c Excel n\u00e0o.<\/p>\n<p style=\"text-align: justify\">H\u1eb1ng s\u1ed1 m\u1ea3ng kh\u00f4ng th\u1ec3 bao g\u1ed3m c\u00e1c m\u1ea3ng, tham chi\u1ebfu \u00f4, d\u1ea3i, ng\u00e0y th\u00e1ng, t\u00ean x\u00e1c \u0111\u1ecbnh, c\u00f4ng th\u1ee9c, ho\u1eb7c c\u00e1c h\u00e0m trong Excel kh\u00e1c.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_Hang_so_mang_duoc_dat_ten\"><\/span>2. H\u1eb1ng s\u1ed1 m\u1ea3ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m cho m\u1ea3ng tr\u1edf n\u00ean d\u1ec5 s\u1eed d\u1ee5ng h\u01a1n, h\u00e3y \u0111\u1eb7t cho n\u00f3 m\u1ed9t c\u00e1i t\u00ean:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110i \u0111\u1ebfn <strong><em>tab Formulas<\/em><\/strong> &gt; nh\u00f3m <strong><em>Defined Names<\/em><\/strong> v\u00e0 nh\u1ea5n <strong><em>Define Name<\/em><\/strong>. Ho\u1eb7c l\u00e0 nh\u1ea5n Ctrl + F3 v\u00e0 nh\u1ea5p v\u00e0o<\/li>\n<li>Nh\u1eadp t\u00ean b\u1ea1n mu\u1ed1n \u0111\u1eb7t v\u00e0o <strong><em>\u00f4 Name<\/em><\/strong><\/li>\n<li>Trong h\u1ed9p <strong><em>Refers to<\/em><\/strong>, nh\u1eadp c\u00e1c m\u1ee5c c\u1ee7a m\u1ea3ng, m\u00e0 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c nh\u1ecdn, v\u1edbi d\u1ea5u b\u1eb1ng \u1edf tr\u01b0\u1edbc (=). V\u00ed d\u1ee5:<\/li>\n<\/ul>\n<p style=\"text-align: justify\">= {\u201cSu\u201d, \u201cMo\u201d, \u201cTu\u201d, \u201cWe\u201d, \u201cTh\u201d, \u201cFr\u201d, \u201cSa\u201d}<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-named-array.png\" alt=\"Creating a named array in Excel\" title=\"create-named-array\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5n OK \u0111\u1ec3 l\u01b0u m\u1ea3ng \u0111\u00e3 \u0111\u1eb7t t\u00ean v\u00e0 \u0111\u00f3ng c\u1eeda s\u1ed5.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u1ec3 nh\u1eadp h\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean trong m\u1ed9t trang t\u00ednh, h\u00e3y ch\u1ecdn nhi\u1ec1u \u00f4 trong m\u1ed9t h\u00e0ng ho\u1eb7c c\u1ed9t l\u00e0 c\u00e1c m\u1ee5c trong m\u1ea3ng c\u1ee7a b\u1ea1n, r\u1ed3i nh\u1eadp t\u00ean c\u1ee7a m\u1ea3ng v\u00e0o thanh c\u00f4ng th\u1ee9c v\u1edbi d\u1ea5u = \u0111\u1eb1ng tr\u01b0\u1edbc v\u00e0 nh\u1ea5n Ctrl + Shift + Enter.<\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 \u0111\u01b0a ra nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-named-array.png\" alt=\"Entering the named array constant in a sheet\" title=\"excel-named-array\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_Ngan_chan_loi\"><\/span>3. Ng\u0103n ch\u1eb7n l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu m\u1ea3ng c\u1ee7a b\u1ea1n kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c, h\u00e3y ki\u1ec3m tra c\u00e1c v\u1ea5n \u0111\u1ec1 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ng\u0103n c\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a h\u1eb1ng s\u1ed1 m\u1ea3ng v\u1edbi c\u00e1c k\u00fd t\u1ef1 th\u00edch h\u1ee3p \u2013 d\u1ea5u ph\u1ea9y v\u1edbi h\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng ngang v\u00e0 d\u1ea5u ch\u1ea5m ph\u1ea9y v\u1edbi c\u00e1c m\u1ea3ng d\u1ecdc.<\/li>\n<li>Ch\u1ecdn m\u1ed9t d\u1ea3i c\u00f3 c\u00e1c \u00f4 \u0111\u00fang v\u1edbi s\u1ed1 l\u01b0\u1ee3ng c\u00e1c m\u1ee5c trong h\u1eb1ng s\u1ed1 m\u1ea3ng c\u1ee7a b\u1ea1n. N\u1ebfu b\u1ea1n ch\u1ecdn nhi\u1ec1u \u00f4 h\u01a1n, th\u00ec m\u1ed7i \u00f4 ph\u1ee5 s\u1ebd c\u00f3 l\u1ed7i # N \/ A. N\u1ebfu \u00edt h\u01a1n, th\u00ec ch\u1ec9 m\u1ed9t ph\u1ea7n c\u1ee7a m\u1ea3ng s\u1ebd \u0111\u01b0\u1ee3c xu\u1ea5t ra.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_hang_so_mang_trong_cong_thuc_cua_Excel\"><\/span>S\u1eed d\u1ee5ng h\u1eb1ng s\u1ed1 m\u1ea3ng trong c\u00f4ng th\u1ee9c c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 quen thu\u1ed9c v\u1edbi kh\u00e1i ni\u1ec7m c\u00e1c h\u1eb1ng s\u1ed1 c\u1ee7a m\u1ea3ng, n\u00ean ch\u00fang ta h\u00e3y c\u00f9ng xem c\u00e1ch m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c m\u1ea3ng trong c\u00e1c c\u00f4ng th\u1ee9c c\u1ee7a Excel \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Cong_N_cac_so_lon_nhat_nho_nhat_trong_mot_dai\"><\/span>V\u00ed d\u1ee5 1. C\u1ed9ng N c\u00e1c s\u1ed1 l\u1edbn nh\u1ea5t \/ nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u1ea3i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch t\u1ea1o m\u1ed9t m\u1ea3ng d\u1ecdc c\u00f3 ch\u1ee9a nh\u1eefng s\u1ed1 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed9ng 3 s\u1ed1 nh\u1ecf nh\u1ea5t ho\u1eb7c l\u1edbn nh\u1ea5t trong m\u1ed9t d\u1ea3i, th\u00ec h\u1eb1ng s\u1ed1 m\u1ea3ng s\u1ebd l\u00e0 {1,2,3}.<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t trong hai h\u00e0m c\u00f4ng th\u1ee9c sau LARGE ho\u1eb7c SMALL, x\u00e1c \u0111\u1ecbnh to\u00e0n b\u1ed9 d\u1ea3i c\u1ee7a \u00f4 trong tham s\u1ed1 \u0111\u1ea7u ti\u00ean v\u00e0 \u0111\u1eb7t h\u1eb1ng s\u1ed1 m\u1ea3ng trong tham s\u1ed1 th\u1ee9 hai. Cu\u1ed1i c\u00f9ng, l\u1ed3ng n\u00f3 v\u00e0o h\u00e0m SUM, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">T\u00ednh t\u1ed5ng 3 s\u1ed1 l\u1edbn nh\u1ea5t: = SUM (LARGE (range, {1,2,3}))<\/p>\n<p style=\"text-align: justify\">T\u00ednh t\u1ed5ng nh\u1ecf nh\u1ea5t 3 s\u1ed1: = SUM (SMALL (range, {1,2,3}))<\/p>\n<p style=\"text-align: justify\">\u0110\u1eebng qu\u00ean nh\u1ea5n Ctrl + Shift + Enter khi b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng, v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/named-array-formula.png\" alt=\"Excel array formula to sum N largest \/ smallest numbers in the range\" title=\"named-array-formula\"><\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a N gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t ho\u1eb7c l\u1edbn nh\u1ea5t trong m\u1ed9t d\u1ea3i:<\/p>\n<p style=\"text-align: justify\">Trung b\u00ecnh c\u1ee7a 3 s\u1ed1 l\u1edbn nh\u1ea5t: = AVERAGE (LARGE (range, {1,2,3}))<\/p>\n<p style=\"text-align: justify\">Trung b\u00ecnh c\u1ee7a 3 s\u1ed1 nh\u1ecf nh\u1ea5t: = AVERAGE (SMALL (range, {1,2,3}))<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Tham kh\u1ea3o th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel v\u0103n ph\u00f2ng<\/a> v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Cong_thuc_mang_de_tinh_cac_o_thoa_nhieu_dieu_kien\"><\/span>V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ednh c\u00e1c \u00f4 th\u1ecfa nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch \u0111\u01a1n \u0111\u1eb7t h\u00e0ng v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft ng\u01b0\u1eddi b\u00e1n h\u00e0ng \u0111\u00e3 b\u00e1n \u0111\u01b0\u1ee3c bao nhi\u00eau l\u1ea7n s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t s\u1ebd s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c COUNTIFS v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u01b0a nhi\u1ec1u s\u1ea3n ph\u1ea9m v\u00e0o, th\u00ec c\u00f4ng th\u1ee9c COUNTIFS c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd qu\u00e1 d\u00e0i. \u0110\u1ec3 l\u00e0m cho n\u00f3 nh\u1ecf g\u1ecdn h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng COUNTIFS c\u00f9ng v\u1edbi SUM v\u00e0 bao g\u1ed3m m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng trong m\u1ed9t ho\u1eb7c m\u1ed9t v\u00e0i \u0111\u1ed1i s\u1ed1, v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUM (COUNTIFS (range1, \u201ccriteria1\u201d, range2, {\u201ccriteria1\u201d, \u201ccriteria2\u201d})))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c th\u1ef1c c\u00f3 th\u1ec3 tr\u00f4ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= SUM (COUNTIFS (B2: B9, \u201csally\u201d, C2: C9, {\u201cApples\u201d, \u201clemons\u201d}))<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/array-constant-formula.png\" alt=\"An array formula to count cells with multiple conditions\" title=\"array-constant-formula\"><\/p>\n<p style=\"text-align: justify\">Trong m\u1ea3ng v\u00ed d\u1ee5 c\u1ee7a ch\u00fang t\u00f4i c\u00f3 bao g\u1ed3m ch\u1ec9 c\u00f3 hai y\u1ebfu t\u1ed1 v\u1edbi m\u1ee5c ti\u00eau l\u00e0 \u0111\u1ec3 \u0111\u01b0a cho b\u1ea1n ph\u01b0\u01a1ng ph\u00e1p ti\u1ebfp c\u1eadn. Th\u1ef1c t\u1ebf, c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a b\u1ea1n, c\u00f3 th\u1ec3 bao g\u1ed3m nhi\u1ec1u y\u1ebfu t\u1ed1 nh\u01b0 ph\u00e9p r\u00e0ng bu\u1ed9c logic, v\u1edbi y\u00eau c\u1ea7u chi\u1ec1u d\u00e0i c\u1ee7a c\u00f4ng th\u1ee9c kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 8,192 k\u00fd t\u1ef1 trong Excel 2013, 2010 v\u00e0 2007 (1,024 k\u00fd t\u1ef1 trong Excel 2003 tr\u1edf v\u1ec1 tr\u01b0\u1edbc) v\u00e0 m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n \u0111\u1ee7 m\u1ea1nh \u0111\u1ec3 x\u1eed l\u00fd m\u1ea3ng l\u1edbn.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_toan_tu_AND_va_OR_trong_cong_thuc_mang_cua_Excel\"><\/span>C\u00e1c to\u00e1n t\u1eed AND v\u00e0 OR trong c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1ed9t to\u00e1n t\u1eed c\u1ee7a m\u1ea3ng cho th\u1ea5y c\u00e1ch b\u1ea1n mu\u1ed1n x\u1eed l\u00fd m\u1ea3ng \u2013 s\u1eed d\u1ee5ng h\u00e0m logic AND v\u00e0 OR.<\/p>\n<ul style=\"text-align: justify\">\n<li>To\u00e1n t\u1eed AND l\u00e0 d\u1ea5u hoa th\u1ecb (*). N\u00f3 h\u01b0\u1edbng d\u1eabn Excel tr\u1ea3 v\u1ec1 TRUE n\u1ebfu T\u1ea4T C\u1ea2 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 l\u00e0 TRUE.<\/li>\n<li>To\u00e1n t\u1eed OR l\u00e0 d\u1ea5u c\u1ed9ng (+). N\u00f3 tr\u1ea3 v\u1ec1 TRUE n\u1ebfu b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o trong m\u1ed9t bi\u1ec3u th\u1ee9c \u0111\u00e3 cho l\u00e0 TRUE.<\/li>\n<\/ul>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_mang_voi_toan_tu_AND\"><\/span>C\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi to\u00e1n t\u1eed AND<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang t\u00f4i cho bi\u1ebft t\u1ed5ng doanh thu t\u01b0\u01a1ng \u1ee9ng m\u00e0 ng\u01b0\u1eddi b\u00e1n h\u00e0ng l\u00e0 Mike v\u00e0 s\u1ea3n ph\u1ea9m l\u00e0 Apples:<\/p>\n<p style=\"text-align: justify\">= SUM ((A2: A9 = \u201cMike\u201d) * (B2: B9 = \u201cApples\u201d) * (C2: C9))<\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c l\u00e0<\/p>\n<p style=\"text-align: justify\">= SUM (IF (((A2: A9 = \u201cMike\u201d) * (B2: B9 = \u201cApples\u201d)), (C2: C9)))<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"i\"><\/span>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-array-formula-and.png\" alt=\"An array formula with the AND operator\" title=\"excel-array-formula-and\"><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_mang_Excel_voi_toan_tu_OR\"><\/span>C\u00f4ng th\u1ee9c m\u1ea3ng Excel v\u1edbi to\u00e1n t\u1eed OR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c m\u1ea3ng sau v\u1edbi to\u00e1n t\u1eed OR (+) cho ph\u00e9p th\u00eam t\u1ea5t c\u1ea3 c\u00e1c b\u00e1n h\u00e0ng \u1ee9ng v\u1edbi ng\u01b0\u1eddi b\u00e1n h\u00e0ng l\u00e0 Mike ho\u1eb7c s\u1ea3n ph\u1ea9m l\u00e0 Apples:<\/p>\n<p style=\"text-align: justify\">= SUM (IF (((A2: A9 = \u201cMike\u201d) + (B2: B9 = \u201cApples\u201d)), (C2: C9)))<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-array-formula-or.png\" alt=\"Excel array formula with the OR operator\" title=\"excel-array-formula-or\"><\/p>\n<p style=\"text-align: justify\">M\u00e1ch nh\u1ecf: Trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Excel 2013, 2010 ho\u1eb7c 2007, vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng trong c\u00e1c t\u00ecnh hu\u1ed1ng nh\u01b0 v\u1eady th\u1ef1c s\u1ef1 kh\u00f4ng c\u1ea7n thi\u1ebft v\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c SUMIFS \u0111\u01a1n gi\u1ea3n c\u00f3 th\u1ec3 cho ra c\u00f9ng m\u1ed9t k\u1ebft qu\u1ea3 nh\u01b0 tr\u00ean. Tuy nhi\u00ean, to\u00e1n t\u1eed AND v\u00e0 OR trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng c\u00f3 th\u1ec3 h\u1eefu \u00edch trong c\u00e1c t\u00ecnh hu\u1ed1ng ph\u1ee9c t\u1ea1p h\u01a1n, \u0111i\u1ec1u n\u00e0y li\u00ean quan \u0111\u1ebfn vi\u1ec7c luy\u1ec7n t\u1eadp c\u00e1c \u00fd t\u01b0\u1edfng cho n\u00e3o c\u1ee7a b\u1ea1n : )<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Toan_tu_don_vi_doi_dieu_hanh_trong_cong_thuc_mang_cua_Excel\"><\/span>To\u00e1n t\u1eed \u0111\u01a1n v\u1ecb \u0111\u00f4i \u0111i\u1ec1u h\u00e0nh trong c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e3 t\u1eebng l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel, r\u1ea5t c\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 l\u01b0\u1edbt qua m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c c\u00f3 ch\u1ee9a hai d\u1ea5u g\u1ea1ch ngang (\u2013) v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e3 t\u1ef1 h\u1ecfi r\u1eb1ng n\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho nh\u1eefng vi\u1ec7c g\u00ec.<\/p>\n<p style=\"text-align: justify\">Hai d\u1ea5u g\u1ea1ch ngang \u0111\u00f4i, g\u1ecdi l\u00e0 to\u00e1n t\u1eed \u0111\u01a1n v\u1ecb \u0111\u00f4i, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n c\u00e1c gi\u00e1 tr\u1ecb Boolean kh\u00f4ng b\u1eb1ng s\u1ed1 (TRUE \/ FALSE) b\u1edfi m\u1ed9t s\u1ed1 bi\u1ec3u th\u1ee9c th\u00e0nh 1 v\u00e0 0 \u2013 th\u1ee9 m\u00e0 m\u1ed9t h\u00e0m m\u1ea3ng c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 sau hy v\u1ecdng l\u00e0m cho m\u1ecdi th\u1ee9 d\u1ec5 hi\u1ec3u h\u01a1n cho b\u1ea1n. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch ng\u00e0y trong c\u1ed9t A v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau ng\u00e0y x\u1ea3y ra v\u00e0o th\u00e1ng Gi\u00eang, b\u1ea5t k\u1ec3 n\u0103m n\u00e0o.<\/p>\n<p style=\"text-align: justify\">C\u00e1c c\u00f4ng th\u1ee9c sau \u0111\u00e2y s\u1ebd gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 tr\u00ean:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUM (\u2013(MONTH (A2: A10) = 1))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ec \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng Excel, h\u00e3y nh\u1edb nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n quan t\u00e2m \u0111\u1ebfn m\u1ed9t th\u00e1ng kh\u00e1c, h\u00e3y thay th\u1ebf 1 b\u1eb1ng m\u1ed9t s\u1ed1 t\u01b0\u01a1ng \u1ee9ng. V\u00ed d\u1ee5, 2 l\u00e0 Th\u00e1ng 2, 3 c\u00f3 ngh\u0129a l\u00e0 Th\u00e1ng 3, v.v. \u0110\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1ed1 c\u1ee7a Th\u00e1ng trong m\u1ed9t s\u1ed1 \u00f4, nh\u01b0 trong h\u00ecnh:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/array-formula-unary-operator.png\" alt=\"Using the double unary operator in Excel array formulas\" title=\"array-formula-unary-operator\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y c\u00f9ng ph\u00e2n t\u00edch xem r\u1eb1ng c\u00f4ng th\u1ee9c m\u1ea3ng Excel l\u00e0m vi\u1ec7c nh\u01b0 th\u1ebf n\u00e0o nh\u00e9. H\u00e0m MONTH tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ed7i ng\u00e0y trong c\u00e1c \u00f4 A2 \u0111\u1ebfn A10 n\u1eb1m trong th\u00e1ng n\u00e0o, ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb b\u1edfi m\u1ed9t s\u1ed1 s\u00ea-ri, t\u1ea1o ra m\u1ea3ng {2; 1; 4; 2; 12; 1; 2; 12; 1}.<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, m\u1ed7i ph\u1ea7n c\u1ee7a m\u1ea3ng s\u1ebd \u0111\u01b0\u1ee3c so s\u00e1nh v\u1edbi gi\u00e1 tr\u1ecb trong \u00f4 D1, l\u00e0 s\u1ed1 1 trong v\u00ed d\u1ee5 n\u00e0y. K\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p so s\u00e1nh n\u00e0y l\u00e0 m\u1ed9t m\u1ea3ng c\u00e1c gi\u00e1 tr\u1ecb Boolean (TRUE v\u00e0 FALSE). Nh\u01b0 b\u1ea1n nh\u1edb, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t ph\u1ea7n nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng v\u00e0 nh\u1ea5n F9 \u0111\u1ec3 xem ph\u1ea7n \u0111\u00f3 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi:<\/p>\n<p style=\"text-align: justify\">Cu\u1ed1i c\u00f9ng, b\u1ea1n ph\u1ea3i chuy\u1ec3n \u0111\u1ed5i c\u00e1c gi\u00e1 tr\u1ecb Boolean n\u00e0y th\u00e0nh 1 v\u00e0 0 \u0111\u1ec3 h\u00e0m SUM c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c. V\u00e0 \u0111\u00e2y l\u00e0 nh\u1eefng g\u00ec c\u00e1c to\u00e1n t\u1eed \u0111\u01a1n v\u1ecb \u0111\u00f4i cho l\u00e0 c\u1ea7n thi\u1ebft. C\u00e1c to\u00e1n t\u1eed \u0111\u01a1n v\u1ecb \u0111\u1ea7u ti\u00ean s\u1ebd l\u00e0m TRUE \/ FALSE th\u00e0nh -1\/0, t\u01b0\u01a1ng \u1ee9ng. C\u00e1i th\u1ee9 hai th\u00ec s\u1ebd ph\u1ee7 \u0111\u1ecbnh gi\u00e1 tr\u1ecb, t\u1ee9c l\u00e0 \u0111\u1ea3o ng\u01b0\u1ee3c d\u1ea5u, bi\u1ebfn ch\u00fang th\u00e0nh +1 v\u00e0 0, \u0111\u1ec3 m\u00e0 h\u1ea7u h\u1ebft c\u00e1c h\u00e0m c\u1ee7a Excel c\u00f3 th\u1ec3 hi\u1ec3u v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi n\u00f3. N\u1ebfu b\u1ea1n lo\u1ea1i b\u1ecf to\u00e1n t\u1eed \u0111\u01a1n v\u1ecb \u0111\u00f4i kh\u1ecfi c\u00f4ng th\u1ee9c tr\u00ean, th\u00ec n\u00f3 s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-116.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3486,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3485","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3485"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3485\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3486"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}