{"id":7985,"date":"2024-12-21T19:18:19","date_gmt":"2024-12-21T19:18:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-lap-bang-tong-hop-cac-tai-khoan-ngan-hang-tren-excel\/"},"modified":"2024-12-21T19:18:19","modified_gmt":"2024-12-21T19:18:19","slug":"huong-dan-lap-bang-tong-hop-cac-tai-khoan-ngan-hang-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-lap-bang-tong-hop-cac-tai-khoan-ngan-hang-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/blog.hocexcel.online\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n <strong><a href=\"https:\/\/blog.hocexcel.online\">c<\/a><a href=\"https:\/\/blog.hocexcel.online\">\u00e1<\/a>ch l\u1eadp b\u1ea3ng (s\u1ed5) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng<\/strong> trong k\u1ebf to\u00e1n tr\u00ean Microsoft Excel.<\/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-6767147ae88a7\" 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-bang-tong-hop-tk-ngan-hang-tren-excel.html#Muc_dich_va_vai_tro_cua_so_bang_tong_hop_cac_tai_khoan_ngan_hang\" title=\"M\u1ee5c \u0111\u00edch v\u00e0 vai tr\u00f2 c\u1ee7a s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng\">M\u1ee5c \u0111\u00edch v\u00e0 vai tr\u00f2 c\u1ee7a s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng<\/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-bang-tong-hop-tk-ngan-hang-tren-excel.html#Mau_so_bang_tong_hop_cac_tai_khoan_ngan_hang\" title=\"M\u1eabu s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng\">M\u1eabu s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng<\/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\/huong-dan-lap-bang-tong-hop-tk-ngan-hang-tren-excel.html#Huong_dan_lap_so_bang_tong_hop_cac_tai_khoan_ngan_hang_tren_Excel\" title=\"H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng tr\u00ean Excel\">H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng tr\u00ean Excel<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-bang-tong-hop-tk-ngan-hang-tren-excel.html#Ham_Excel_su_dung\" title=\"H\u00e0m Excel s\u1eed d\u1ee5ng\">H\u00e0m Excel s\u1eed d\u1ee5ng<\/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-bang-tong-hop-tk-ngan-hang-tren-excel.html#Cach_thuc_hien\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n\">C\u00e1ch th\u1ef1c hi\u1ec7n<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-bang-tong-hop-tk-ngan-hang-tren-excel.html#Tinh_tong_so_ton_du_dau_ky\" title=\"T\u00ednh t\u1ed5ng s\u1ed1 t\u1ed3n (d\u01b0) \u0111\u1ea7u k\u1ef3\">T\u00ednh t\u1ed5ng s\u1ed1 t\u1ed3n (d\u01b0) \u0111\u1ea7u k\u1ef3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-bang-tong-hop-tk-ngan-hang-tren-excel.html#Tinh_tong_so_thu_vao_phat_sinh_ben_No\" title=\"T\u00ednh t\u1ed5ng s\u1ed5 thu v\u00e0o\u00a0(ph\u00e1t sinh b\u00ean N\u1ee3).\">T\u00ednh t\u1ed5ng s\u1ed5 thu v\u00e0o\u00a0(ph\u00e1t sinh b\u00ean N\u1ee3).<\/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\/huong-dan-lap-bang-tong-hop-tk-ngan-hang-tren-excel.html#Tinh_tong_so_chi_ra_phat_sinh_ben_Co\" title=\"T\u00ednh t\u1ed5ng s\u1ed1 chi ra (ph\u00e1t sinh b\u00ean C\u00f3)\">T\u00ednh t\u1ed5ng s\u1ed1 chi ra (ph\u00e1t sinh b\u00ean C\u00f3)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-bang-tong-hop-tk-ngan-hang-tren-excel.html#Tinh_tong_ton_du_cuoi_ky\" title=\"T\u00ednh t\u1ed5ng t\u1ed3n (d\u01b0) cu\u1ed1i k\u1ef3\">T\u00ednh t\u1ed5ng t\u1ed3n (d\u01b0) cu\u1ed1i k\u1ef3<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-bang-tong-hop-tk-ngan-hang-tren-excel.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=\"Muc_dich_va_vai_tro_cua_so_bang_tong_hop_cac_tai_khoan_ngan_hang\"><\/span>M\u1ee5c \u0111\u00edch v\u00e0 vai tr\u00f2 c\u1ee7a s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>\u2013 S\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng v\u1edbi m\u1ee5c \u0111\u00edch \u0111\u01b0a ra c\u00e1i nh\u00ecn chung nh\u1ea5t, t\u1ed5ng quan nh\u1ea5t v\u1ec1 t\u00ecnh h\u00ecnh bi\u1ebfn \u0111\u1ed9ng, ph\u00e1t sinh \u0111\u1ed1i v\u1edbi c\u00e1c ng\u00e2n h\u00e0ng m\u00e0 \u0111\u01a1n v\u1ecb c\u00f3 giao d\u1ecbch trong k\u1ef3 (m\u1ed7i ng\u00e2n theo d\u00f5i ri\u00eang tr\u00ean 1 t\u00e0i kho\u1ea3n, 1 \u0111\u1ed1i t\u01b0\u1ee3ng). Hay n\u00f3 ch\u00ednh l\u00e0: \u0110\u01a1n v\u1ecb c\u00f3 bao nhi\u00eau t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng th\u00ec tr\u00ean s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng c\u0169ng c\u1ea7n c\u00f3 t\u1eebng \u0111\u00f3 d\u00f2ng.<\/p>\n<p>\u2013\u00a0C\u0103n c\u1ee9 \u0111\u1ec3 l\u1eadp b\u1ea3ng n\u00e0y l\u00e0 s\u1ed1 li\u1ec7u t\u1eeb c\u00e1c S\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n g\u1eedi ng\u00e2n h\u00e0ng.<\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lam-chi-tiet-tien-gui-ngan-hang-trong-excel.html\">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>\u2013 S\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c l\u1eadp v\u00e0o cu\u1ed1i k\u1ef3 k\u1ebf to\u00e1n (c\u00f3 th\u1ec3 l\u00e0 cu\u1ed1i th\u00e1ng, cu\u1ed1i qu\u00fd ho\u1eb7c cu\u1ed1i n\u0103m).<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Mau_so_bang_tong_hop_cac_tai_khoan_ngan_hang\"><\/span>M\u1eabu s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>V\u1ec1 m\u1eabu s\u1ed5 th\u00ec kh\u00e1 linh ho\u1ea1t. Tuy nhi\u00ean, v\u1eabn ph\u1ea3i \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c vi\u1ec7c ph\u1ea3n \u00e1nh ch\u00ednh x\u00e1c, t\u1ed5ng h\u1ee3p \u0111\u01b0\u1ee3c nh\u1eefng ph\u00e1t sinh t\u0103ng, ph\u00e1t sinh gi\u1ea3m c\u1ee7a c\u00e1c ng\u00e2n h\u00e0ng m\u00e0 \u0111\u01a1n v\u1ecb c\u00f3 giao d\u1ecbch trong k\u1ef3.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y <a href=\"https:\/\/blog.hocexcel.online\">H\u1ecdc Excel Online<\/a> s\u1eed d\u1ee5ng m\u1eabu s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng nh\u01b0 sau, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 \u1edf link cu\u1ed1i b\u00e0i vi\u1ebft:<\/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-718.gif\" title=\"ex101_92019-nho-718\"><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-329.gif\" title=\"vba101_92019-nho-329\"><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-718.gif\" title=\"ex101_92019-nho-718\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/TH2-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29978\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/th2-1-1024x536-1.png\" width=\"1024\" height=\"536\" title=\"th2-1-1024x536-1\"><\/a><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Huong_dan_lap_so_bang_tong_hop_cac_tai_khoan_ngan_hang_tren_Excel\"><\/span>H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng tr\u00ean Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Trong ph\u1ea7n n\u00e0y, <a href=\"https:\/\/blog.hocexcel.online\">H\u1ecdc Excel Online <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng tr\u00ean Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Excel kh\u00e1 \u0111\u01a1n gi\u1ea3n.<\/p>\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=\"https:\/\/blog.hocexcel.online\">H\u1ecdc Excel Online <\/a>c\u0169ng \u0111\u00e3 h\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n g\u1eedi ng\u00e2n h\u00e0ng tr\u00ean Excel. V\u00e0 \u0111\u1ec3 cho c\u00e1c b\u1ea1n thu\u1eadn ti\u1ec7n trong vi\u1ec7c theo d\u00f5i th\u00ec m\u00ecnh xin s\u1eed d\u1ee5ng l\u1ea1i d\u1eef li\u1ec7u trong b\u00e0i \u0111\u00f3, c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p>B\u1ea3ng DATA:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/1-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29966\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-5-1024x484-1.png\" width=\"1024\" height=\"484\" title=\"1-5-1024x484-1\"><\/a><\/p>\n<p>V\u00e0 b\u1ea3ng danh m\u1ee5c ng\u00e2n h\u00e0ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29967\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-4-1024x106-1.png\" width=\"1024\" height=\"106\" title=\"2-4-1024x106-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_Excel_su_dung\"><\/span>H\u00e0m Excel s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m Excel ch\u00ednh m\u00e0 trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc Excel Online s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1eadp s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n\u00a0h\u00e0ng l\u00e0 h\u00e0m SUMIFS:<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><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<p>Ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m SUMIFS \u0111\u1ec3 t\u00ednh ra t\u1ed5ng s\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3, t\u1ed5ng s\u1ed1\u00a0thu v\u00e0o v\u00e0 t\u1ed5ng s\u1ed1 chi ra c\u1ee7a t\u1eebng ng\u00e2n h\u00e0ng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thuc_hien\"><\/span>C\u00e1ch th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c m\u1ee5c \u0111\u00edch, vai tr\u00f2, m\u1eabu s\u1ed5 (b\u1ea3ng) c\u0169ng nh\u01b0 h\u00e0m Excel s\u1eed d\u1ee5ng th\u00ec \u1edf ph\u1ea7n n\u00e0y h\u00e3y c\u00f9ng <a href=\"https:\/\/blog.hocexcel.online\">H\u1ecdc Excel Online<\/a> th\u1ef1c hi\u1ec7n vi\u1ec7c l\u1eadp s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng.<\/p>\n<p>\u0110\u1ec3 cho thu\u1eadn ti\u1ec7n trong vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 theo d\u00f5i th\u00ec m\u00ecnh ngh\u0129 ta n\u00ean Define Name (\u0111\u1eb7t t\u00ean) cho c\u00e1c v\u00f9ng t\u00ednh t\u1ed5ng v\u00e0 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n. Chi ti\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\"><strong>SO_TIEN:<\/strong> L\u00e0 v\u00f9ng $J$2:$J$310 b\u00ean Sheet DATA_NKC (\u0111\u00e2y l\u00e0 v\u00f9ng ta c\u1ea7n t\u00ednh t\u1ed5ng)<\/p>\n<p style=\"padding-left: 30px\"><strong>CT_NO:<\/strong> L\u00e0 v\u00f9ng $H$2:$H$310 b\u00ean Sheet DATA_NKC (\u0111\u00e2y l\u00e0 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n b\u00ean N\u1ee3)<\/p>\n<p style=\"padding-left: 30px\"><strong>CT_CO:<\/strong> L\u00e0 v\u00f9ng $I$2:$I$310 b\u00ean Sheet DATA_NKC\u00a0(\u0111\u00e2y l\u00e0 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n b\u00ean C\u00f3)<\/p>\n<p style=\"padding-left: 30px\"><strong>NGAY:<\/strong> L\u00e0 v\u00f9ng $B$2:$B$310 b\u00ean Sheet DATA_NKC\u00a0(\u0111\u00e2y l\u00e0 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng).<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/TH1-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29976\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/th1-1.png\" width=\"825\" height=\"313\" title=\"th1-1\"><\/a><\/p>\n<p>V\u1ec1 c\u00e1ch \u0111\u1eb7t t\u00ean trong Excel b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o Video sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/32-%E2%97%8F-cach-su-dung-name-range-trong-excel-dat-ten-cho-vung-du-lieu.html\"><em><strong>C\u00e1ch s\u1eed d\u1ee5ng name range trong excel, \u0111\u1eb7t t\u00ean cho v\u00f9ng d\u1eef li\u1ec7u<\/strong><\/em><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_tong_so_ton_du_dau_ky\"><\/span>T\u00ednh t\u1ed5ng s\u1ed1 t\u1ed3n (d\u01b0) \u0111\u1ea7u k\u1ef3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi c\u00e1c v\u00f9ng t\u00ednh t\u1ed5ng c\u0169ng nh\u01b0 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n nh\u01b0 tr\u00ean ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh ra s\u1ed1 t\u1ed3n (d\u01b0) \u0111\u1ea7u k\u1ef3 nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=SUMIFS(SO_TIEN, CT_NO, C11, NGAY, \u201c&lt;\u201d &amp; $G$7) \u2013 SUMIFS(SO_TIEN, CT_CO, C11, NGAY, \u201c&lt;\u201d &amp; $G$7)<\/strong><\/p>\n<\/blockquote>\n<p>S\u1ed1 t\u1ed3n \u0111\u1ea7u k\u1ef3 \u1edf \u0111\u00e2y \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 s\u1ed1 t\u1ed3n t\u00ednh t\u1edbi tr\u01b0\u1edbc th\u1eddi \u0111i\u1ec3m t\u1eeb ng\u00e0y (\u00f4 G7). Hay n\u00f3 ch\u00ednh l\u00e0: T\u1ed5ng s\u1ed1 ph\u00e1t sinh b\u00ean N\u1ee3 tr\u1eeb \u0111i t\u1ed5ng s\u1ed1 ph\u00e1t sinh b\u00ean C\u00f3 <em><strong>t<\/strong><strong>\u00ed<\/strong><strong>nh t\u1edbi tr\u01b0\u1edbc th\u1eddi \u0111i\u1ec3m t\u1eeb ng\u00e0y.<\/strong><\/em><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/TH2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29970\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/th2-1024x362-1.png\" width=\"1024\" height=\"362\" title=\"th2-1024x362-1\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_tong_so_thu_vao_phat_sinh_ben_No\"><\/span>T\u00ednh t\u1ed5ng s\u1ed5 thu v\u00e0o\u00a0(ph\u00e1t sinh b\u00ean N\u1ee3).<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ti\u1ebfp theo, ta s\u1ebd t\u00ednh s\u1ed1 thu v\u00e0o (s\u1ed1 ph\u00e1t sinh b\u00ean N\u1ee3) trong kho\u1ea3ng th\u1eddi gian t\u1eeb ng\u00e0y <strong>(\u00f4 G8)<\/strong> \u0111\u1ebfn ng\u00e0y <strong>(\u00f4 G8).\u00a0<\/strong>C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p>T\u1ea1i \u00f4 G11 b\u1ea1n g\u00f5 v\u00e0o c\u00f4ng th\u1ee9c:<\/p>\n<blockquote>\n<p><strong>=SUMIFS(SO_TIEN, CT_NO, C11, NGAY, \u201c&gt;=\u201d &amp; $G$7, NGAY,\u201d&lt;=\u201d &amp; $G$8)<\/strong><\/p>\n<\/blockquote>\n<p>\u0110\u00e2y l\u00e0 t\u1ed5ng s\u1ed1 ti\u1ec1n ph\u00e1t sinh b\u00ean N\u1ee3 c\u1ee7a t\u1eebng t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng trong kho\u1ea3ng th\u1eddi gian t\u1eeb ng\u00e0y \u0111\u1ebfn ng\u00e0y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_tong_so_chi_ra_phat_sinh_ben_Co\"><\/span>T\u00ednh t\u1ed5ng s\u1ed1 chi ra (ph\u00e1t sinh b\u00ean C\u00f3)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 t\u00ednh t\u1ed5ng s\u1ed1 thu v\u00e0o, th\u00ec v\u1edbi t\u1ed5ng s\u1ed1 chi ra (ph\u00e1t sinh b\u00ean C\u00f3), ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p><strong>=SUMIFS(SO_TIEN, CT_CO, C11, NGAY, \u201c&gt;=\u201d &amp; $G$7, NGAY, \u201c&lt;=\u201d &amp; $G$8)<\/strong><\/p>\n<\/blockquote>\n<p>\u0110\u00e2y l\u00e0 t\u1ed5ng s\u00f3 ti\u1ec1n ph\u00e1t sinh b\u00ean C\u00f3 c\u1ee7a t\u1eebng t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng trong kho\u1ea3ng th\u1eddi gian t\u1eeb ng\u00e0y \u0111\u1ebfn ng\u00e0y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29971\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/th3-1024x282-1.png\" width=\"1024\" height=\"282\" title=\"th3-1024x282-1\"><\/p>\n<p>B\u1ea1n ch\u1ec9 c\u1ea7n thay v\u00f9ng \u0111i\u1ec1u ki\u1ec7n CT_NO c\u1ee7a c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng s\u1ed1 thu v\u00e0o b\u1eb1ng CT_CO l\u00e0 c\u00f3 th\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n chi ra.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_tong_ton_du_cuoi_ky\"><\/span>T\u00ednh t\u1ed5ng t\u1ed3n (d\u01b0) cu\u1ed1i k\u1ef3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta c\u0169ng \u0111\u00e3 bi\u1ebft th\u00ec s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 \u1edf \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1eb1ng: S\u1ed1 d\u01b0 \u0111\u1ea7y k\u1ef3 + S\u1ed1 thu v\u00e0o \u2013 S\u1ed5 chi ra. V\u1edbi nguy\u00ean t\u1eafc \u0111\u00f3 th\u00ec ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 t\u00ednh ra s\u1ed1 t\u1ed3n (d\u01b0) cu\u1ed1i k\u1ef3 nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=F11+G11-H11<\/strong><\/p>\n<\/blockquote>\n<p>Sau khi \u0111\u00e3 t\u00ednh to\u00e1n xong ta th\u1ef1c hi\u1ec7n <strong>FillDown<\/strong> c\u00e1c c\u00f4ng th\u1ee9c \u0111\u00f3 xu\u1ed1ng cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i, r\u1ed3i v\u1edbi h\u00e0m SUM \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 t\u00ednh d\u00f2ng C\u1ed9ng. B\u1ea1n s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/TH4-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30169\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/th4-2-1024x555-1.png\" width=\"1024\" height=\"555\" title=\"th4-2-1024x555-1\"><\/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>Qua b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/blog.hocexcel.online\">H\u1ecdc Excel Online<\/a> hy v\u1ecdng b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch d\u00f9ng h\u00e0m Excel \u0111\u1ec3 l\u1eadp \u0111\u01b0\u1ee3c s\u1ed5 (b\u1ea3ng) t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, hi\u1ec7u qu\u1ea3 v\u00e0 ho\u00e0n to\u00e0n linh ho\u1ea1t khi thay \u0111\u1ed5i kho\u1ea3ng th\u1eddi gian mu\u1ed1n xem t\u1ed5ng h\u1ee3p.<\/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\/1vjlVfJrB4Y9ssAWDWYGCb7vKIog7tYdv\/view\"><em><strong>H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng tr\u00ean Excel<\/strong><\/em><\/a><\/p>\n<hr>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-ghi-bang-tong-hop-cac-tai-khoan-ngan-hang-tren-excel.html\">C\u00e1ch ghi b\u1ea3ng t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lam-chi-tiet-tien-gui-ngan-hang-trong-excel.html\">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=\"text-align: justify;padding-left: 30px\"><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=\"text-align: justify;padding-left: 30px\"><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=\"text-align: justify;padding-left: 30px\"><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<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lam-phieu-xuat-kho-tren-excel.html\">h\u01b0\u1edbng d\u1eabn l\u00e0m phi\u1ebfu xu\u1ea5t kho tr\u00ean excel<\/a>.<\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 Nh\u1eadt k\u00fd chung b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-cai-bang-ham-heosql.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 C\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/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-718.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7986,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7985","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7985","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=7985"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7985\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7986"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}