{"id":4250,"date":"2024-12-04T17:24:54","date_gmt":"2024-12-04T17:24:54","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-lap-so-cai-bang-ham-heosql\/"},"modified":"2024-12-04T17:24:54","modified_gmt":"2024-12-04T17:24:54","slug":"huong-dan-lap-so-cai-bang-ham-heosql","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-lap-so-cai-bang-ham-heosql\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 c\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> s\u1ebd <strong>h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n l\u1eadp S\u1ed5 c\u00e1i c\u00e1c t\u00e0i kho\u1ea3n trong k\u1ebf to\u00e1n v\u1edbi h\u00e0m \u201cHeoSQL\u201d<\/strong> \u2013 H\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">trong b\u1ed9 Add \u2013 Ins HocExcelOnline.<\/a> S\u1ed5 s\u1ebd ho\u00e0n to\u00e0n t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u khi b\u1ea1n thay \u0111\u1ed5i T\u00e0i kho\u1ea3n c\u0169ng nh\u01b0 l\u00e0 kho\u1ea3ng th\u1eddi gian m\u00e0 b\u1ea1n mu\u1ed1n xem.<\/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-6750906540a3b\" 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\/huong-dan-lap-cai-bang-ham-heosql.html#Noi_dung_muc_dich_va_vai_tro_cua_So_cai\" title=\"N\u1ed9i dung, m\u1ee5c \u0111\u00edch v\u00e0 vai tr\u00f2 c\u1ee7a S\u1ed5 c\u00e1i\">N\u1ed9i dung, m\u1ee5c \u0111\u00edch v\u00e0 vai tr\u00f2 c\u1ee7a S\u1ed5 c\u00e1i<\/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\/huong-dan-lap-cai-bang-ham-heosql.html#Huong_dan_lap_So_cai_bang_ham_%E2%80%9CHeoSQL%E2%80%9D\" title=\"H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 c\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d\">H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 c\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-cai-bang-ham-heosql.html#Mau_So_cai_theo_hinh_thuc_Nhat_ky_chung\" title=\"M\u1eabu S\u1ed5 c\u00e1i theo h\u00ecnh th\u1ee9c Nh\u1eadt k\u00fd chung\">M\u1eabu S\u1ed5 c\u00e1i theo h\u00ecnh th\u1ee9c Nh\u1eadt k\u00fd chung<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-cai-bang-ham-heosql.html#Huong_dan_lap_So_cai_bang_ham_%E2%80%9CHeoSQL%E2%80%9D-2\" title=\"H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 c\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d\">H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 c\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-cai-bang-ham-heosql.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Noi_dung_muc_dich_va_vai_tro_cua_So_cai\"><\/span>N\u1ed9i dung, m\u1ee5c \u0111\u00edch v\u00e0 vai tr\u00f2 c\u1ee7a S\u1ed5 c\u00e1i<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>\u2013 S\u1ed5 C\u00e1i l\u00e0 s\u1ed5 k\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p d\u00f9ng \u0111\u1ec3 ghi c\u00e1c nghi\u1ec7p v\u1ee5 kinh t\u1ebf ph\u00e1t sinh trong k\u1ef3 theo t\u1eebng t\u00e0i kho\u1ea3n k\u1ebf to\u00e1n \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh trong ch\u1ebf \u0111\u1ed9 k\u1ebf to\u00e1n m\u00e0 \u0111\u01a1n v\u1ecb \u0111ang \u00e1p d\u1ee5ng.<\/p>\n<p>\u2013 S\u1ed1 li\u1ec7u ghi tr\u00ean S\u1ed5 C\u00e1i d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra, \u0111\u1ed1i chi\u1ebfu v\u1edbi s\u1ed1 li\u1ec7u ghi tr\u00ean B\u1ea3ng t\u1ed5ng h\u1ee3p chi ti\u1ebft ho\u1eb7c c\u00e1c S\u1ed5 (th\u1ebb) k\u1ebf to\u00e1n chi ti\u1ebft v\u00e0 d\u00f9ng l\u00e0m c\u0103n c\u1ee9 \u0111\u1ec3 l\u1eadp B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh v\u00e0 B\u00e1o c\u00e1o T\u00e0i ch\u00ednh.<\/p>\n<p>\u2013 M\u1ed7i t\u00e0i kho\u1ea3n \u0111\u01b0\u1ee3c m\u1edf m\u1ed9t ho\u1eb7c m\u1ed9t s\u1ed1 trang li\u00ean ti\u1ebfp tr\u00ean S\u1ed5 C\u00e1i \u0111\u1ee7 \u0111\u1ec3 ghi ch\u00e9p trong m\u1ed9t ni\u00ean \u0111\u1ed9 k\u1ebf to\u00e1n.<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Huong_dan_lap_So_cai_bang_ham_%E2%80%9CHeoSQL%E2%80%9D\"><\/span>H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 c\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>H\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">HeoSQL<\/a> l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m thu\u1ed9c <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">Add \u2013 Ins HocExcelOnline.<\/a> B\u1ea1n tham kh\u1ea3o link d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 xem Video h\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c h\u00e0m n\u00e0y trong Excel nh\u00e9:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\"><em><strong>H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t add ins hocexcelonline<\/strong><\/em><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mau_So_cai_theo_hinh_thuc_Nhat_ky_chung\"><\/span>M\u1eabu S\u1ed5 c\u00e1i theo h\u00ecnh th\u1ee9c Nh\u1eadt k\u00fd chung<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi nh\u1eefng b\u1ea1n l\u00e0m k\u1ebf to\u00e1n th\u00ec ch\u1eafc h\u1eb3n kh\u00f4ng c\u00f2n xa l\u1ea1 g\u00ec v\u1edbi m\u1eabu c\u1ee7a s\u1ed5 c\u00e1i ph\u1ea3i kh\u00f4ng n\u00e0o. Trong b\u00e0i vi\u1ebft n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a>s\u1eed d\u1ee5ng S\u1ed5 c\u00e1i v\u1edbi m\u1eabu nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-341.gif\" title=\"ex101_92019-nho-341\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-148.gif\" title=\"vba101_92019-nho-148\"><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-341.gif\" title=\"ex101_92019-nho-341\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/4-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29947\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-4-1024x686-1.png\" width=\"1024\" height=\"686\" title=\"4-4-1024x686-1\"><\/a><\/p>\n<p>\u1ede cu\u1ed1i b\u00e0i vi\u1ebft b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i Download file \u0111\u00ednh k\u00e8m b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1eabu n\u00e0y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_lap_So_cai_bang_ham_%E2%80%9CHeoSQL%E2%80%9D-2\"><\/span>H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 c\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu nh\u01b0 b\u1ea1n theo d\u00f5i th\u00ec trong m\u1ed9t b\u00e0i vi\u1ebft g\u1ea7n \u0111\u00e2y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> c\u0169ng \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft gi\u1edbi thi\u1ec7u c\u00e1ch l\u1eadp S\u1ed5 Nh\u1eadt k\u00fd chung v\u1edbi h\u00e0m \u201cHeoSQL\u201d. \u0110\u1ec3 cho c\u00e1c b\u1ea1n d\u1ec5 so s\u00e1nh, \u0111\u1ed1i chi\u1ebfu th\u00ec trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh c\u0169ng s\u1eed d\u1ee5ng b\u1ea3ng DATA trong b\u00e0i vi\u1ebft \u0111\u00f3 \u0111\u1ec3 l\u00e0m c\u0103n c\u1ee9 l\u00ean S\u1ed5 c\u00e1i c\u00e1c t\u00e0i kho\u1ea3n, c\u1ee5 th\u1ec3 DATA \u0111\u00f3 nh\u01b0 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/1-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29946\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-4-1024x519-1.png\" width=\"1024\" height=\"519\" title=\"1-4-1024x519-1\"><\/a><\/p>\n<p>V\u1ec1 b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 Nh\u1eadt k\u00fd chung v\u1edbi h\u00e0m \u201cHeoSQL\u201d th\u00ec b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o \u1edf link ngay d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"padding-left: 30px\"><em><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html\"><strong>H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 nh\u1eadt k\u00fd chung b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/strong><\/a><\/em><\/p>\n<p>Quay tr\u1edf l\u1ea1i v\u1edbi l\u1eadp S\u1ed5 c\u00e1i, th\u00ec ta s\u1ebd s\u1eed d\u1ee5ng c\u00e2u truy v\u1ea5n SQL nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=\u201dSELECT NGAY, SO_PHIEU, NGAY, DIEN_GIAI, IIF(LEFT(TK_NO,3) =\u00a0 \u201d &amp; Heorange(E8,4) &amp; \u201d , TK_CO, IIF(LEFT(TK_CO,3) = \u201d &amp; Heorange(E8,4) &amp; \u201c, TK_NO)), IIF(LEFT(TK_NO,3) = \u201d &amp; Heorange(E8,4) &amp; \u201c, SO_TIEN,0), IIF(LEFT(TK_CO,3) = \u201d &amp; Heorange(E8,4) &amp; \u201c, SO_TIEN,0) FROM DATA WHERE NGAY &gt;= \u201d &amp; Heorange(E9,2) &amp; \u201d AND NGAY &lt;= \u201d &amp; Heorange($E$10,2) &amp; \u201d AND (LEFT(TK_NO,3) = \u201d &amp; Heorange(E8,4) &amp; \u201d OR LEFT(TK_CO,3) = \u201d &amp; Heorange(E8,4) &amp; \u201c)\u201d<\/strong><\/p>\n<\/blockquote>\n<p>V\u1edbi ph\u1ea7n tu\u1ef3 ch\u1ecdn (\u0111\u1ed1i s\u1ed1 th\u1ee9 2 c\u1ee7a h\u00e0m \u201cHeoSQL\u201d) b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3 nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>STT = Y, TIEUDE = N, CHEN = Y<\/strong><\/p>\n<\/blockquote>\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n<ul>\n<li><strong>STT = Y:<\/strong>\u00a0T\u1ee9c l\u00e0 cho ph\u00e9p \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1.<\/li>\n<li><strong>TIEUDE = N:<\/strong>\u00a0C\u00e2u truy v\u1ea5n tr\u1ea3 v\u1ec1 KH\u00d4NG bao g\u1ed3m ti\u00eau \u0111\u1ec1 (M\u1eb7c \u0111\u1ecbnh).<\/li>\n<li><strong>CHEN = Y:<\/strong>\u00a0Cho ph\u00e9p t\u1ef1 \u0111\u1ed9ng co d\u00e3n, ch\u00e8n d\u00f2ng khi d\u1eef li\u1ec7u thay \u0111\u1ed5i.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m HeoSQL v\u1edbi c\u00e2u truy v\u1ea5n tr\u00ean nh\u01b0 sau <em>(File PDF, vui l\u00f2ng ch\u1ecdn v\u00e0o h\u00ecnh \u0111\u1ec3 xem r\u00f5 h\u01a1n)<\/em><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/So_Cai.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29951\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so_cai-1024x589-1.gif\" width=\"1024\" height=\"589\" title=\"so_cai-1024x589-1\"><\/a><\/p>\n<p>V\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t nh\u01b0 tr\u00ean l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 l\u1eadp \u0111\u01b0\u1ee3c s\u1ed5 c\u00e1i, l\u1ea5y l\u00ean \u0111\u01b0\u1ee3c t\u00ecnh h\u00ecnh ph\u00e1t sinh li\u00ean quan t\u1edbi t\u00e0i kho\u1ea3n S\u1ed5 c\u00e1i trong kho\u1ea3ng th\u1eddi gian r\u1ed3i. \u0110\u1eb7c bi\u1ec7t l\u00e0 v\u1edbi nh\u1eefng ai \u0111\u00e3 c\u00f3 ki\u1ebfn th\u1ee9c v\u1ec1 SQL th\u00ec ch\u1eafc s\u1ebd kh\u00f4ng th\u1ea5y qu\u00e1 kh\u00f3 kh\u0103n g\u00ec.<\/p>\n<p>N\u1ebfu nh\u01b0 b\u1ea1n ch\u01b0a ti\u1ebfp x\u00fac nhi\u1ec1u v\u1edbi SQL th\u00ec b\u1ea1n c\u00f3 th\u1ec3 Download file \u0111\u00ednh k\u00e8m d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y v\u1ec1 \u0111\u1ec3 tham kh\u1ea3o v\u00e0 hi\u1ec3u r\u00f5 h\u01a1n.<\/p>\n<p>V\u1edbi c\u00e1c th\u00f4ng tin c\u00f2n l\u1ea1i tr\u00ean S\u1ed5 c\u00e1i:<\/p>\n<ul>\n<li>T\u00ean t\u00e0i kho\u1ea3n: B\u1ea1n c\u00f3 th\u1ec3 c\u0103n c\u1ee9 v\u00e0o danh m\u1ee5c t\u00e0i kho\u1ea3n v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\">VLOOKUP<\/a> sang, ho\u1eb7c<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html\"> INDEX + MATCH,\u2026.<\/a><\/li>\n<\/ul>\n<p style=\"padding-left: 60px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><em><strong>H\u00e0m vlookup trong excel, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft v\u00e0 c\u00f3 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/strong><\/em><\/a><\/p>\n<ul>\n<li>S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3: B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html\">SUMIFS<\/a>, MIN, MAX \u0111\u1ec3 t\u00ednh ra.<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html\"><em><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs v\u00e0 sumif v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u2013 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c<\/strong><\/em><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a>hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 l\u1eadp \u0111\u01b0\u1ee3c S\u1ed5 c\u00e1i c\u00e1c t\u00e0i kho\u1ea3n theo h\u00ecnh th\u1ee9c Nh\u1eadt k\u00fd chung m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u1edbi 1 c\u00e2u truy v\u1ea5n SQL nh\u01b0 tr\u00ean. N\u1ebfu trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n b\u1ea1n c\u00f3 v\u01b0\u1edbng m\u1eafc hay g\u00f3p \u00fd g\u00ec th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i Comment \u0111\u1ec3 H\u1ecdc Excel Online h\u1ed7 tr\u1ee3 th\u00eam \ud83d\ude02. File \u0111\u00ednh k\u00e8m b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 \u1edf link d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p>Download file \u0111\u00ednh k\u00e8m b\u00e0i vi\u1ebft \u1edf \u0111\u00e2y:\u00a0<a href=\"https:\/\/drive.google.com\/file\/d\/13y1x0Z3fRvshfKpeZnH0ahDXsB2l2Ipa\/view\"><em><strong>H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 c\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/strong><\/em><\/a><\/p>\n<hr>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lan-so-ke-toan-chi-tiet-cong-no-phai-thu.html\"><em><strong>H\u01b0\u1edbng d\u1eabn l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft thanh to\u00e1n v\u1edbi kh\u00e1ch h\u00e0ng trong excel<\/strong><\/em><\/a><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lam-ke-toan-chi-tiet-vat-tu-san-pham-hang-hoa-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft v\u1eadt t\u01b0, s\u1ea3n ph\u1ea9m, h\u00e0ng ho\u00e1 tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/?p=29254&amp;preview=true\">H\u01b0\u1edbng d\u1eabn l\u00e0m s\u1ed5 qu\u1ef9 ti\u1ec1n m\u1eb7t, s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n m\u1eb7t tr\u00ean Excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/?p=29359&amp;preview=true\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n g\u1eedi ng\u00e2n h\u00e0ng tr\u00ean Excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tao-phieu-thu-chi-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o phi\u1ebfu thu, phi\u1ebfu chi tr\u00ean excel<\/a>.<\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/?p=29211&amp;preview=true\">H\u01b0\u1edbng d\u1eabn l\u00e0m phi\u1ebfu nh\u1eadp kho tr\u00ean Excel<\/a>.<\/strong><\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-341.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4251,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4250","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\/4250","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=4250"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4250\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4251"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}