{"id":7949,"date":"2024-12-21T19:00:22","date_gmt":"2024-12-21T19:00:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel\/"},"modified":"2024-12-21T19:00:22","modified_gmt":"2024-12-21T19:00:22","slug":"cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel\/","title":{"rendered":"C\u00e1ch \u0111\u1ebfm t\u1ed5ng s\u1ed1 t\u1eeb trong v\u00f9ng d\u1eef li\u1ec7u b\u1eb1ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft n\u00e0y H\u1ecdc Excel Online h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch \u0111\u1ebfm t\u1eeb trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\" target=\"_blank\">h\u00e0m LEN<\/a> k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c v\u00e0 cung c\u1ea5p c\u00e1c c\u00f4ng th\u1ee9c ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c t\u1eeb, v\u0103n b\u1ea3n c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">\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-67671045ccbe6\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel.html#Lam_the_nao_de_dem_tong_so_tu_trong_mot_o\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 t\u1eeb trong m\u1ed9t \u00f4\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 t\u1eeb trong m\u1ed9t \u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel.html#Cong_thuc_dem_tu_hoat_dong_nhu_the_nao\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ebfm t\u1eeb ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o\">C\u00f4ng th\u1ee9c \u0111\u1ebfm t\u1eeb ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel.html#Cong_thuc_cai_tien_de_xu_ly_dung_cac_o_trong\" title=\"C\u00f4ng th\u1ee9c c\u1ea3i ti\u1ebfn \u0111\u1ec3 x\u1eed l\u00fd \u0111\u00fang c\u00e1c \u00f4 tr\u1ed1ng\">C\u00f4ng th\u1ee9c c\u1ea3i ti\u1ebfn \u0111\u1ec3 x\u1eed l\u00fd \u0111\u00fang c\u00e1c \u00f4 tr\u1ed1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel.html#Cach_dem_cac_tu_cu_the_trong_mot_o\" title=\"C\u00e1ch \u0111\u1ebfm c\u00e1c t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4\">C\u00e1ch \u0111\u1ebfm c\u00e1c t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel.html#Lam_cach_nao_de_cong_thuc_nay_dem_so_lan_xuat_hien_cua_mot_van_ban_cu_the_trong_mot_o\" title=\"L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t v\u0103n b\u1ea3n c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4\">L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t v\u0103n b\u1ea3n c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel.html#Cong_thuc_de_dem_tu_cu_the_trong_mot_o_phan_biet_in_hoa_in_thuong\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ebfm t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4 ph\u00e2n bi\u1ec7t in hoa in th\u01b0\u1eddng:\">C\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ebfm t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4 ph\u00e2n bi\u1ec7t in hoa in th\u01b0\u1eddng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel.html#Cong_thuc_de_dem_tu_cu_the_trong_mot_o_khong_phan_biet_in_hoa_in_thuong\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ebfm t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4 kh\u00f4ng ph\u00e2n bi\u1ec7t in hoa in th\u01b0\u1eddng:\">C\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ebfm t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4 kh\u00f4ng ph\u00e2n bi\u1ec7t in hoa in th\u01b0\u1eddng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel.html#Dem_tong_so_tu_trong_mot_vung_du_lieu\" title=\"\u0110\u1ebfm t\u1ed5ng s\u1ed1 t\u1eeb trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u\">\u0110\u1ebfm t\u1ed5ng s\u1ed1 t\u1eeb trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-tong-so-tu-trong-vung-du-lieu-bang-ket-hop-cac-ham-excel.html#Dem_cac_tu_cu_the_trong_mot_vung_du_lieu\" title=\"\u0110\u1ebfm c\u00e1c t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u\">\u0110\u1ebfm c\u00e1c t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_dem_tong_so_tu_trong_mot_o\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 t\u1eeb trong m\u1ed9t \u00f4<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ebfm c\u00e1c t\u1eeb trong m\u1ed9t \u00f4, s\u1eed d\u1ee5ng s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\" target=\"_blank\">h\u00e0m LEN<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\" target=\"_blank\">SUBSTITUTE<\/a> v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\" target=\"_blank\">TRIM<\/a>:<\/p>\n<p style=\"text-align: justify\"><strong><em>= LEN (TRIM (\u00f4)) \u2013 LEN (SUBSTITUTE (\u00f4, \u201d \u201c, \u201c\u201d)) + 1<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1eddng h\u1ee3p \u0111ang \u1edf t\u1ea1i \u00f4 b\u1ea1n mu\u1ed1n \u0111\u1ebfm t\u1eeb.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u1ebfm c\u00e1c t\u1eeb trong \u00f4 A2, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong><em>= LEN (TRIM (A2)) \u2013 LEN (SUBSTITUTE (A2, \u201d \u201c, \u201c\u201d)) + 1<\/em><\/strong><\/p>\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-714.gif\" title=\"ex101_92019-nho-714\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u00e0 sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ebfm t\u1eeb trong c\u00e1c \u00f4 kh\u00e1c c\u1ee7a c\u1ed9t A:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-24.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4479 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-24.bmp\" width=\"593\" height=\"140\" title=\"new-bitmap-image-2-24\"><\/a><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_dem_tu_hoat_dong_nhu_the_nao\"><\/span><strong>C\u00f4ng th\u1ee9c \u0111\u1ebfm t\u1eeb ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">\u0110\u1ea7u ti\u00ean, b\u1ea1n s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\" target=\"_blank\"><em><strong>h\u00e0m SUBSTITUTE<\/strong><\/em><\/a> \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c kho\u1ea3ng tr\u1eafng trong \u00f4 b\u1eb1ng c\u00e1ch thay th\u1ebf ch\u00fang b\u1eb1ng m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 r\u1ed7ng (\u201c\u201d) \u0111\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\" target=\"_blank\"><em><strong>h\u00e0m LEN<\/strong><\/em><\/a> \u00a0tr\u1ea3 v\u1ec1 chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i m\u00e0 kh\u00f4ng c\u00f3 kho\u1ea3ng tr\u1eafng:<\/p>\n<p style=\"text-align: justify\"><strong><em>LEN (SUBSTITUTE (A2, \u201d \u201c, \u201c\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n tr\u1eeb chi\u1ec1u d\u00e0i chu\u1ed7i kh\u00f4ng c\u00f3 kho\u1ea3ng tr\u1eafng t\u1eeb t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i, v\u00e0 c\u1ed9ng 1 v\u00e0o k\u1ebft qu\u1ea3, v\u00ec s\u1ed1 tr\u1eeb trong m\u1ed9t \u00f4 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi s\u1ed1 kho\u1ea3ng tr\u1eafng c\u1ed9ng v\u1edbi 1.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n s\u1eed d\u1ee5ng <em><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\" target=\"_blank\">h\u00e0m TRIM<\/a><\/strong><\/em> \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng trong \u00f4, n\u1ebfu c\u00f3. \u0110\u00f4i khi b\u1ea3ng t\u00ednh c\u00f3 th\u1ec3 ch\u1ee9a nhi\u1ec1u kho\u1ea3ng tr\u1eafng v\u00f4 h\u00ecnh, v\u00ed d\u1ee5 nh\u01b0 hai hay nhi\u1ec1u kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb, ho\u1eb7c kho\u1ea3ng tr\u1eafng v\u00f4 t\u00ecnh \u0111\u00e1nh v\u00e0o \u0111\u1ea7u ho\u1eb7c cu\u1ed1i c\u1ee7a v\u0103n b\u1ea3n (t\u1ee9c l\u00e0 c\u00e1c kho\u1ea3ng tr\u1ed1ng \u0111\u1ea7u v\u00e0 cu\u1ed1i). T\u1ea5t c\u1ea3 nh\u1eefng kho\u1ea3ng tr\u1ed1ng \u0111\u00f3 c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea1n \u0111\u1ebfm sai. \u0110\u1ec3 kh\u00f4ng \u0111\u1ec3 chuy\u1ec7n n\u00e0y x\u1ea3y ra, tr\u01b0\u1edbc khi t\u00ednh t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i, ta s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\" target=\"_blank\"><strong><em>h\u00e0m TRIM<\/em><\/strong><\/a> \u0111\u1ec3 b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c kho\u1ea3ng tr\u1eafng, ngo\u1ea1i tr\u1eeb kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c t\u1eeb.<\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_cai_tien_de_xu_ly_dung_cac_o_trong\"><\/span><strong>C\u00f4ng th\u1ee9c c\u1ea3i ti\u1ebfn \u0111\u1ec3 x\u1eed l\u00fd \u0111\u00fang c\u00e1c \u00f4 tr\u1ed1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u00ean d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c t\u1eeb trong Excel c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 ho\u00e0n h\u1ea3o n\u1ebfu kh\u00f4ng c\u00f3 nh\u01b0\u1ee3c \u0111i\u1ec3m sau \u2013 n\u00f3 tr\u1ea3 k\u1ebft qu\u1ea3 \u0111\u1ebfm l\u00e0 1 cho c\u00e1c \u00f4 tr\u1ed1ng. \u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam m\u1ed9t l\u1ec7nh IF \u0111\u1ec3 ki\u1ec3m tra c\u00e1c \u00f4 tr\u1ed1ng:<\/p>\n<p style=\"text-align: justify\"><strong><em>= IF (A2 = \u201d \u201c, 0, LEN (TRIM (A2)) \u2013 LEN (SUBSTITUTE (A2, \u201d \u201c, \u201c\u201d)) + 1)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-25.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4481 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-25.bmp\" width=\"593\" height=\"164\" title=\"new-bitmap-image-2-25\"><\/a><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh tr\u00ean, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 kh\u00f4ng cho c\u00e1c \u00f4 tr\u1ed1ng v\u00e0 s\u1ed1 \u0111\u1ebfm t\u1eeb ch\u00ednh x\u00e1c cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dem_cac_tu_cu_the_trong_mot_o\"><\/span><strong>C\u00e1ch \u0111\u1ebfm c\u00e1c t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t t\u1eeb, v\u0103n b\u1ea3n ho\u1eb7c chu\u1ed7i con xu\u1ea5t hi\u1ec7n trong m\u1ed9t \u00f4, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>= (LEN (\u00f4) -LEN (SUBSTITUTE (\u00f4, t\u1eeb, \u201c\u201d))) \/ LEN (t\u1eeb)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: h\u00e3y t\u00ednh s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n \u201cmoon\u201d trong \u00f4 A2:<\/p>\n<p style=\"text-align: justify\"><strong><em>= (LEN (A2) -LEN (SUBSTITUTE (A2, \u201cmoon\u201d, \u201c\u201d))) \/ LEN (\u201cmoon\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-26.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4484 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-26.bmp\" width=\"600\" height=\"143\" title=\"new-bitmap-image-2-26\"><\/a><\/p>\n<p style=\"text-align: justify\">Thay v\u00ec nh\u1eadp t\u1eeb \u0111\u01b0\u1ee3c \u0111\u1ebfm tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 n\u00f3 trong m\u1ed9t \u00f4, v\u00e0 tham chi\u1ebfu \u00f4 \u0111\u00f3 trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n. K\u1ebft qu\u1ea3 l\u00e0, b\u1ea1n s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 t\u1eeb trong Excel.<\/p>\n<p style=\"text-align: justify\"><em><strong>Ch\u00fa \u00fd:<\/strong><\/em> N\u1ebfu b\u1ea1n c\u00f3 k\u1ebf ho\u1ea1ch sao ch\u00e9p c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n v\u00e0o nhi\u1ec1u \u00f4, h\u00e3y ch\u1eafc ch\u1eafn th\u00eam v\u00e0o \u00f4 tham chi\u1ebfu ch\u1ee9a t\u1eeb \u0111\u1ec3 \u0111\u1ebfm d\u1ea5u $. V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong><em>= (LEN (A2) -LEN (SUBSTITUTE (A2, $B$1, \u201c\u201d))) \/ LEN ($B$1)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-27.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4485\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-27.bmp\" width=\"600\" height=\"145\" title=\"new-bitmap-image-2-27\"><\/a><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_cach_nao_de_cong_thuc_nay_dem_so_lan_xuat_hien_cua_mot_van_ban_cu_the_trong_mot_o\"><\/span><strong>L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t v\u0103n b\u1ea3n c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>1. <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\" target=\"_blank\">H\u00e0m SUBSTITUTE<\/a> lo\u1ea1i b\u1ecf t\u1eeb \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh kh\u1ecfi v\u0103n b\u1ea3n ban \u0111\u1ea7u.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta lo\u1ea1i b\u1ecf t\u1eeb nh\u1eadp v\u00e0o \u00f4 B1 t\u1eeb v\u0103n b\u1ea3n g\u1ed1c n\u1eb1m trong A2:<\/p>\n<p style=\"text-align: justify\"><strong><em>SUBSTITUTE (A2, $B$1, \u201c\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">2. Sau \u0111\u00f3, <a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\" target=\"_blank\">h\u00e0m LEN<\/a> t\u00ednh chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n m\u00e0 kh\u00f4ng c\u00f3 t\u1eeb \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, <strong><em>LEN (SUBSTITUTE (A2, $B$1, \u201c\u201d))<\/em><\/strong> tr\u1ea3 v\u1ec1 chi\u1ec1u d\u00e0i c\u1ee7a v\u0103n b\u1ea3n trong \u00f4 A2 sau khi x\u00f3a t\u1ea5t c\u1ea3 t\u1eeb \u201cmoon\u201d.<\/p>\n<p style=\"text-align: justify\">3. Sau \u0111\u00f3, s\u1ed1 tr\u00ean \u0111\u01b0\u1ee3c tr\u1eeb kh\u1ecfi t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n ban \u0111\u1ea7u:<\/p>\n<p style=\"text-align: justify\"><strong><em>(LEN (A2) -LEN (SUBSTITUTE (A2, $B$1, \u201c\u201d))))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 c\u1ee7a \u00a0vi\u1ec7c n\u00e0y l\u00e0 s\u1ed1 k\u00fd t\u1ef1 ch\u1ee9a trong t\u1ea5t c\u1ea3 c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a t\u1eeb \u0111\u01b0\u1ee3c ch\u1ecdn, trong v\u00ed d\u1ee5 l\u00e0 12 (3 l\u1ea7n xu\u1ea5t hi\u1ec7n t\u1eeb \u201cmoon\u201d, 4 k\u00fd t\u1ef1 m\u1ed7i t\u1eeb).<\/p>\n<p style=\"text-align: justify\">4. Cu\u1ed1i c\u00f9ng, \u00a0k\u1ebft qu\u1ea3 tr\u00ean \u0111\u01b0\u1ee3c chia cho chi\u1ec1u d\u00e0i c\u1ee7a t\u1eeb. N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n chia s\u1ed1 k\u00fd t\u1ef1 ch\u1ee9a trong t\u1ea5t c\u1ea3 c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a t\u1eeb m\u1ee5c ti\u00eau cho s\u1ed1 k\u00fd t\u1ef1 ch\u1ee9a trong m\u1ed9t l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a t\u1eeb \u0111\u00f3. Trong v\u00ed d\u1ee5 n\u00e0y, 12 chia cho 4, v\u00e0 ta nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 3.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i vi\u1ec7c \u0111\u1ebfm s\u1ed1 t\u1eeb nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t \u00f4, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec3 \u0111\u1ebfm c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a b\u1ea5t k\u1ef3 v\u0103n b\u1ea3n n\u00e0o (chu\u1ed7i con). V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n ch\u1eef \u201cpick\u201d xu\u1ea5t hi\u1ec7n trong \u00f4 A2:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-28.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4486 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-28.bmp\" width=\"469\" height=\"105\" title=\"new-bitmap-image-2-28\"><\/a><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_de_dem_tu_cu_the_trong_mot_o_phan_biet_in_hoa_in_thuong\"><\/span><strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ebfm t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4 ph\u00e2n bi\u1ec7t in hoa in th\u01b0\u1eddng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 bi\u1ebft, <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\" target=\"_blank\">Excel SUBSTITUTE<\/a> l\u00e0 m\u1ed9t h\u00e0m ph\u00e2n bi\u1ec7t in hoa in th\u01b0\u1eddng, v\u00e0 do \u0111\u00f3 c\u00f4ng th\u1ee9c \u0111\u1ebfm t\u1eeb d\u1ef1a tr\u00ean SUBSTITUTE theo m\u1eb7c \u0111\u1ecbnh l\u00e0 ch\u1eef in hoa v\u00e0 ch\u1eef in th\u01b0\u1eddng:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-29.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4487 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-29.bmp\" width=\"624\" height=\"143\" title=\"new-bitmap-image-2-29\"><\/a><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_de_dem_tu_cu_the_trong_mot_o_khong_phan_biet_in_hoa_in_thuong\"><\/span><strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ebfm t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4 kh\u00f4ng ph\u00e2n bi\u1ec7t in hoa in th\u01b0\u1eddng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n \u0111\u1ebfm c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng c\u1ee7a m\u1ed9t t\u1eeb nh\u1ea5t \u0111\u1ecbnh, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m UPPER ho\u1eb7c LOWER b\u00ean trong SUBSTITUTE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n g\u1ed1c v\u00e0 v\u0103n b\u1ea3n b\u1ea1n mu\u1ed1n \u0111\u1ebfm v\u00e0o c\u00f9ng m\u1ed9t tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<p style=\"text-align: justify\"><strong><em>= (LEN (\u00f4) -LEN (SUBSTITUTE (UPPER (\u00f4), UPPER (v\u0103n b\u1ea3n), \u201c\u201d))) \/ LEN (v\u0103n b\u1ea3n)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c l\u00e0<\/p>\n<p style=\"text-align: justify\"><em><strong>= (LEN (\u00f4) -LEN (SUBSTITUTE (LOWER (\u00f4), LOWER (v\u0103n b\u1ea3n), \u201c\u201d)))) \/ LEN (v\u0103n b\u1ea3n)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a t\u1eeb \u1edf \u00f4 B1 trong \u00f4 A2 trong m\u1ecdi tr\u01b0\u1eddng h\u1ee3p, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><em><strong>= (LEN (A2) -LEN (SUBSTITUTE (LOWER (A2), LOWER ($B$1), \u201c\u201d))) \/ LEN ($B$1)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 h\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 c\u00f9ng m\u1ed9t s\u1ed1 b\u1ea5t k\u1ec3 t\u1eeb \u0111\u01b0\u1ee3c g\u00f5 in hoa (\u00f4 B1), ch\u1eef th\u01b0\u1eddng (\u00f4 D1) ho\u1eb7c tr\u01b0\u1eddng h\u1ee3p ch\u1eef hoa \u1edf \u0111\u1ea7u (\u00f4 C1):<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-30.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4488 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-30.bmp\" width=\"600\" height=\"138\" title=\"new-bitmap-image-2-30\"><\/a><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dem_tong_so_tu_trong_mot_vung_du_lieu\"><\/span><strong>\u0110\u1ebfm t\u1ed5ng s\u1ed1 t\u1eeb trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">\u0110\u1ec3 bi\u1ebft c\u00f3 bao nhi\u00eau t\u1eeb trong m\u1ed9t v\u00f9ng n\u00e0o \u0111\u00f3, h\u00e3y l\u1ea5y c\u00f4ng th\u1ee9c \u0111\u1ebfm t\u1ed5ng s\u1ed1 t\u1eeb trong m\u1ed9t \u00f4 v\u00e0 k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/47-%e2%97%8f-ham-sumproduct-va-su-khac-nhau-voi-sumifs-countifs-trong-excel.html\" target=\"_blank\">h\u00e0m SUMPRODUCT<\/a> <a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct.html\" target=\"_blank\">ho\u1eb7c SUM<\/a>:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUMPRODUCT (LEN (TRIM (ph\u1ea1m vi)) \u2013 LEN (SUBSTITUTE (ph\u1ea1m vi, \u201d \u201c, \u201c\u201d)) + 1)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c l\u00e0<\/p>\n<p style=\"text-align: justify\"><em><strong>= SUM (LEN (TRIM (ph\u1ea1m vi)) \u2013 LEN (SUBSTITUTE (ph\u1ea1m vi, \u201d \u201c, \u201c\u201d)) + 1)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><strong><em>SUMPRODUCT<\/em><\/strong> l\u00e0 m\u1ed9t trong s\u1ed1 \u00edt c\u00e1c h\u00e0m Excel c\u00f3 th\u1ec3 x\u1eed l\u00fd m\u1ea3ng, v\u00e0 b\u1ea1n ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng b\u1eb1ng c\u00e1ch nh\u1ea5n ph\u00edm Enter.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu d\u00f9ng h\u00e0m SUM trong t\u00ednh to\u00e1n c\u00e1c m\u1ea3ng, th\u00ec n\u00f3 n\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 m\u1ed9t m\u1ea3ng, ngh\u0129a l\u00e0 ho\u00e0n th\u00e0nh b\u1eb1ng c\u00e1ch nh\u1ea5n Ctrl + Shift + Enter thay v\u00ec g\u00f5 Enter b\u00ecnh th\u01b0\u1eddng.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c t\u1eeb trong kho\u1ea3ng A2: A4, s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUMPRODUCT (LEN (TRIM (A2: A4)) \u2013 LEN (SUBSTITUTE (A2: A4, \u201d \u201c, \u201c\u201d)) + 1)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><em><strong>= SUM (LEN (TRIM (A2: A4)) \u2013 LEN (SUBSTITUTE (A2: A4, \u201d \u201c, \u201c\u201d)) + 1)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-31.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4489 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-31.bmp\" width=\"600\" height=\"139\" title=\"new-bitmap-image-2-31\"><\/a><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dem_cac_tu_cu_the_trong_mot_vung_du_lieu\"><\/span><strong>\u0110\u1ebfm c\u00e1c t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm m\u1ed9t t\u1eeb ho\u1eb7c v\u0103n b\u1ea3n xu\u1ea5t hi\u1ec7n bao nhi\u00eau l\u1ea7n trong m\u1ed9t \u00f4, h\u00e3y s\u1eed d\u1ee5ng c\u00e1ch t\u01b0\u01a1ng t\u1ef1 \u2013 l\u1ea5y c\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c t\u1eeb c\u1ee5 th\u1ec3 trong m\u1ed9t \u00f4, v\u00e0 k\u1ebft h\u1ee3p n\u00f3 v\u1edbi h\u00e0m SUM ho\u1eb7c SUMPRODUCT:<\/p>\n<p style=\"text-align: justify\"><em><strong>= SUMPRODUCT ((LEN (range) -LEN (SUBSTITUTE (ph\u1ea1m vi, t\u1eeb, \u201c\u201d))) \/ LEN (t\u1eeb))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c l\u00e0<\/p>\n<p style=\"text-align: justify\"><em><strong>= SUM ((LEN (range) -LEN (SUBSTITUTE (ph\u1ea1m vi, t\u1eeb, \u201c\u201d))) \/ LEN (t\u1eeb))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb nh\u1ea5n <em><strong>Ctrl + Shift + Enter<\/strong><\/em> \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c m\u1ea3ng SUM.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a t\u1eeb \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 C1 trong ph\u1ea1m vi A2: A4, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><em><strong>=SUMPRODUCT((LEN(A2:A4)-LEN(SUBSTITUTE(A2:A4, C1,\u201d\u201d)))\/LEN(C1))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-32.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4490 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-32.bmp\" width=\"600\" height=\"139\" title=\"new-bitmap-image-2-32\"><\/a><\/p>\n<p style=\"text-align: justify\">B\u1ea1n n\u00ean nh\u1edb, <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\" target=\"_blank\"><em><strong>SUBSTITUTE<\/strong><\/em><\/a> l\u00e0 m\u1ed9t h\u00e0m ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng v\u00e0 do \u0111\u00f3 c\u00f4ng th\u1ee9c tr\u00ean ph\u00e2n bi\u1ec7t gi\u1eefa ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-34.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4492 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-34.bmp\" width=\"600\" height=\"135\" title=\"new-bitmap-image-2-34\"><\/a><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c kh\u00f4ng ph\u00e2n bi\u1ec7t c\u00e1c tr\u01b0\u1eddng h\u1ee3p in hoa in th\u01b0\u1eddng, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m UPPER ho\u1eb7c LOWER:<\/p>\n<p style=\"text-align: justify\"><em><strong>= SUMPRODUCT (LEN (A2: A4) -LEN (SUBSTITUTE ((UPPER (A2: A4)), UPPER (C1), \u201c\u201d)))) \/ LEN (C1))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c l\u00e0<\/p>\n<p style=\"text-align: justify\"><em><strong>= SUMPRODUCT ((LEN (A2: A4) -LEN (SUBSTITUTE ((LOWER (A2: A4)), LOWER (C1), \u201c\u201d)))) \/ LEN (C1))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-35.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4493 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-35.bmp\" width=\"600\" height=\"135\" title=\"new-bitmap-image-2-35\"><\/a><\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/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\/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-714.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7950,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7949","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\/7949","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=7949"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7949\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7950"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}