{"id":6833,"date":"2024-12-21T16:17:23","date_gmt":"2024-12-21T16:17:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinh-bang-tinh-khac\/"},"modified":"2024-12-21T16:17:23","modified_gmt":"2024-12-21T16:17:23","slug":"tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinh-bang-tinh-khac","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinh-bang-tinh-khac\/","title":{"rendered":"T\u1ea0O THAM CHI\u1ebeU NGO\u1ea0I TRONG EXCEL \u0110\u1ec2 D\u1eaaN T\u1edaI TRANG T\u00cdNH\/B\u1ea2NG T\u00cdNH KH\u00c1C"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\/\" target=\"_blank\">H\u1ecdc Excel Online<\/a> s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i th\u00edch tham chi\u1ebfu ngo\u1ea1i trong Excel m\u1ed9t c\u00e1ch c\u01a1 b\u1ea3n v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp tham chi\u1ebfu cho m\u1ed9t trang t\u00ednh ho\u1eb7c b\u1ea3ng t\u00ednh trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">Khi t\u00ednh to\u00e1n d\u1eef li\u1ec7u trong Excel, \u0111\u00f4i khi b\u1ea1n s\u1ebd g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang t\u00ednh ho\u1eb7c th\u1eadm ch\u00ed m\u1ed9t file Excel kh\u00e1c. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n t\u1ea1o li\u00ean k\u1ebft gi\u1eefa hai trang t\u00ednh (c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh ho\u1eb7c kh\u00e1c b\u1ea3ng t\u00ednh) b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng \u00f4 tham chi\u1ebfu ngo\u1ea1i ho\u1eb7c \u0111\u01b0\u1eddng link.<\/p>\n<p style=\"text-align: justify\">\u00d4 tham chi\u1ebfu ngo\u1ea1i trong Excel l\u00e0 s\u1ef1 tham chi\u1ebfu d\u1eabn t\u1edbi m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t m\u1ea3ng c\u00e1c \u00f4 (range) kh\u00f4ng n\u1eb1m trong trang t\u00ednh hi\u1ec7n t\u1ea1i. L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c d\u00f9ng tham chi\u1ebfu ngo\u1ea1i l\u00e0 b\u1ea5t c\u1ee9 khi n\u00e0o \u00f4 tham chi\u1ebfu thay \u0111\u1ed5i, gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 b\u1edfi \u00f4 tham chi\u1ebfu ngo\u1ea1i s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt.<\/p>\n<p style=\"text-align: justify\">Gi\u1eefa tham chi\u1ebfu ngo\u1ea1i trong Excel v\u00e0 \u00f4 tham chi\u1ebfu v\u1eabn c\u00f3 nh\u1eefng \u0111i\u1ec3m kh\u00e1c bi\u1ec7t m\u1eb7c d\u00f9 ch\u00fang t\u01b0\u01a1ng t\u1ef1 nhau. Trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, ch\u00fang ta c\u00f9ng b\u1eaft \u0111\u1ea7u v\u1edbi nh\u1eefng b\u01b0\u1edbc c\u01a1 b\u1ea3n v\u00e0 t\u1ea1o m\u1ed9t v\u00e0i lo\u1ea1i tham chi\u1ebfu ngo\u1ea1i qua c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/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-6766ea12d3d46\" 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\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tao_tham_chieu_tu_mot_trang_tinh_khac\" title=\"T\u1ea1o tham chi\u1ebfu t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c\u00a0\">T\u1ea1o tham chi\u1ebfu t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c\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-2\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Cong_thuc_co_dang_nhu_sau\" title=\"C\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 sau\">C\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 sau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tao_tham_chieu_toi_mot_trang_tinh_khac_trong_Excel\" title=\"T\u1ea1o tham chi\u1ebfu t\u1edbi m\u1ed9t trang t\u00ednh kh\u00e1c trong Excel\">T\u1ea1o tham chi\u1ebfu t\u1edbi m\u1ed9t trang t\u00ednh kh\u00e1c 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-4\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tham_chieu_tu_bang_tinh_khac\" title=\"Tham chi\u1ebfu t\u1eeb b\u1ea3ng t\u00ednh kh\u00e1c\">Tham chi\u1ebfu t\u1eeb b\u1ea3ng t\u00ednh kh\u00e1c<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tham_chieu_ngoai_tu_bang_tinh_mo\" title=\"Tham chi\u1ebfu ngo\u1ea1i t\u1eeb b\u1ea3ng t\u00ednh m\u1edf\">Tham chi\u1ebfu ngo\u1ea1i t\u1eeb b\u1ea3ng t\u00ednh m\u1edf<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tham_chieu_ngoai_tu_bang_tinh_dong\" title=\"Tham chi\u1ebfu ngo\u1ea1i t\u1eeb b\u1ea3ng t\u00ednh \u0111\u00f3ng\">Tham chi\u1ebfu ngo\u1ea1i t\u1eeb b\u1ea3ng t\u00ednh \u0111\u00f3ng<\/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\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tao_tham_chieu_toi_mot_bang_tinh_khac_trong_Excel\" title=\"T\u1ea1o tham chi\u1ebfu t\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c trong Excel\">T\u1ea1o tham chi\u1ebfu t\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c 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-8\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tham_chieu_toi_ten_trong_cung_hoac_khac_bang_tinh\" title=\"Tham chi\u1ebfu t\u1edbi t\u00ean trong c\u00f9ng ho\u1eb7c kh\u00e1c b\u1ea3ng t\u00ednh\">Tham chi\u1ebfu t\u1edbi t\u00ean trong c\u00f9ng ho\u1eb7c kh\u00e1c b\u1ea3ng t\u00ednh<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tao_ten_trong_Excel\" title=\"T\u1ea1o t\u00ean trong Excel\">T\u1ea1o t\u00ean trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tham_chieu_ten_trong_trang_tinh_khac_nam_cung_mot_bang_tinh\" title=\"Tham chi\u1ebfu t\u00ean trong trang t\u00ednh kh\u00e1c n\u1eb1m c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh\">Tham chi\u1ebfu t\u00ean trong trang t\u00ednh kh\u00e1c n\u1eb1m c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Tham_chieu_ten_trong_bang_tinh_khac\" title=\"Tham chi\u1ebfu t\u00ean trong b\u1ea3ng t\u00ednh kh\u00e1c\">Tham chi\u1ebfu t\u00ean trong b\u1ea3ng t\u00ednh kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html#Cach_tao_tham_chieu_ten\" title=\"C\u00e1ch t\u1ea1o tham chi\u1ebfu t\u00ean\">C\u00e1ch t\u1ea1o tham chi\u1ebfu t\u00ean<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_tham_chieu_tu_mot_trang_tinh_khac\"><\/span><span style=\"font-size: 18pt\">T\u1ea1o tham chi\u1ebfu t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 tham chi\u1ebfu m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t m\u1ea3ng c\u00e1c \u00f4 t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c c\u00f9ng n\u1eb1m trong m\u1ed9t b\u1ea3ng t\u00ednh, \u0111\u01b0a t\u00ean trang t\u00ednh \u0111\u1eb1ng sau d\u1ea5u (!) n\u1eb1m tr\u01b0\u1edbc \u0111\u1ea1i ch\u1ec9 \u00f4.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_co_dang_nhu_sau\"><\/span><strong>C\u00f4ng th\u1ee9c<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 sau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li><strong>Tham chi\u1ebfu t\u1edbi m\u1ed9t \u00f4 ri\u00eang l\u1ebb<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>T\u00ean_trang_t\u00ednh!\u0110\u1ecba_ch\u1ec9_\u00f4<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 tham chi\u1ebfu t\u1edbi \u00f4 A1 n\u1eb1m trong Sheet2, \u0111\u00e1nh <strong>Sheet2!A1.<\/strong><\/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-271.gif\" title=\"vba101_92019-nho-271\"><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-613.gif\" title=\"ex101_92019-nho-613\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li><strong>Tham chi\u1ebfu t\u1edbi m\u1ed9t m\u1ea3ng<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>T\u00ean_trang_t\u00ednh!\u00d4_\u0111\u1ea7u:\u00d4_cu\u1ed1i<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 tham chi\u1ebfu t\u1edbi c\u00e1c \u00f4 A1:A10 trong Sheet2, \u0111\u00e1nh Sheet2!A1:A10<\/p>\n<ul style=\"list-style-type: square;text-align: justify\">\n<li><strong>L\u01b0u \u00fd: <\/strong>N\u1ebfu t\u00ean trang t\u00ednh ch\u1ee9a d\u1ea5u c\u00e1ch ho\u1eb7c k\u00ed t\u1ef1 kh\u00f4ng ph\u1ea3i ch\u1eef c\u00e1i, b\u1ea1n ph\u1ea3i \u0111\u1eb7t t\u00ean trang t\u00ednh trong d\u1ea5u nh\u00e1y. V\u00ed d\u1ee5 m\u1ed9t tham chi\u1ebfu ngo\u1ea1i t\u1edbi \u00f4 A1 trong trang t\u00ednh c\u00f3 t\u00ean l\u00e0\u00a0<em>Th\u1ed1ng k\u00ea,\u00a0<\/em>c\u00f4ng th\u1ee9c nh\u01b0 sau: \u2018Th\u1ed1ng k\u00ea\u2019!A1.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong th\u1ef1c t\u1ebf khi nh\u00e2n gi\u00e1 tr\u1ecb \u00f4 A1 trong trang t\u00ednh\u00a0<em>Th\u1ed1ng k\u00ea\u00a0<\/em>v\u1edbi 10, c\u00f4ng th\u1ee9c tham chi\u1ebfu ngo\u1ea1i nh\u01b0 sau<\/p>\n<p style=\"text-align: justify\"><strong>=\u2019Th\u1ed1ng k\u00ea\u2019!A1*10<\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_tham_chieu_toi_mot_trang_tinh_khac_trong_Excel\"><\/span><strong><span style=\"font-size: 14pt\">T\u1ea1o tham chi\u1ebfu t\u1edbi m\u1ed9t trang t\u00ednh kh\u00e1c trong Excel<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-size: 12pt\">Khi vi\u1ebft c\u00f4ng th\u1ee9c tham chi\u1ebfu t\u1edbi \u00f4 n\u1eb1m trong trang t\u00ednh kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh t\u00ean trang t\u00ednh kh\u00e1c \u0111\u1eb1ng sau d\u1ea5u (!) v\u00e0 tham chi\u1ebfu m\u1ed9t \u00f4 m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng v\u00e0 d\u1ec5 m\u1eafc l\u1ed7i.\u00a0<\/span><\/p>\n<p style=\"text-align: justify\">C\u00e1ch t\u1ed1t h\u01a1n l\u00e0 ch\u1ec9 t\u1edbi \u00f4 n\u1eb1m trong trang t\u00ednh kh\u00e1c m\u00e0 b\u1ea1n mu\u1ed1n c\u00f4ng th\u1ee9c tham chi\u1ebfu t\u1edbi v\u00e0 \u0111\u1ec3 Excel t\u1ef1 s\u1eeda c\u00fa ph\u00e1p. \u0110\u1ec3 Excel ch\u00e8n tham chi\u1ebfu t\u1edbi m\u1ed9t trang t\u00ednh kh\u00e1c, l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau<\/p>\n<ol style=\"text-align: justify\">\n<li>\u0110\u00e1nh c\u00f4ng th\u1ee9c v\u00e0o v\u1ecb tr\u00ed \u00f4 ho\u1eb7c v\u00e0o thanh c\u00f4ng th\u1ee9c<\/li>\n<li>Khi mu\u1ed1n ch\u00e8n tham chi\u1ebfu t\u1edbi trang t\u00ednh kh\u00e1c, chuy\u1ec3n t\u1edbi trang t\u00ednh v\u00e0 ch\u1ecdn m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t m\u1ea3ng \u00f4 b\u1ea1n mu\u1ed1n tham chi\u1ebfu t\u1edbi<\/li>\n<li>K\u1ebft th\u00fac \u0111\u00e1nh c\u00f4ng th\u1ee9c v\u00e0 \u1ea5n Enter \u0111\u1ec3 ho\u00e0n t\u1ea5t<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch Doanh s\u1ed1 b\u00e1n h\u00e0ng v\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh thu\u1ebf gi\u00e1 tr\u1ecb gia t\u0103ng (19%) cho m\u1ed7i s\u1ea3n ph\u1ea9m trong m\u1ed9t trang t\u00ednh kh\u00e1c t\u00ean\u00a0<em>VAT,<\/em> th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau<\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li>\u0110\u00e1nh c\u00f4ng th\u1ee9c\u00a0<strong>=19%*\u00a0<\/strong>v\u00e0o \u00f4 B2 n\u1eb1m trong trang\u00a0<em>VAT\u00a0<\/em><\/li>\n<li>Sang trang Doanh s\u1ed1, v\u00e0 click v\u00e0o \u00f4 B2. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u00e8n tham chi\u1ebfu ngo\u1ea1i t\u1edbi \u00f4 \u0111\u00f3 nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6559 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-06-05-at-09-32-01.png\" width=\"596\" height=\"386\" title=\"screen-shot-2017-06-05-at-09-32-01\"><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li>\u1ea4n Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<ul style=\"list-style-type: square;text-align: justify\">\n<li><strong>L\u01b0u \u00fd\u00a0<\/strong>Khi ch\u00e8n tham chi\u1ebfu Excel t\u1edbi m\u1ed9t trang t\u00ednh kh\u00e1c s\u1eed d\u1ee5ng ph\u01b0\u01a1ng th\u1ee9c tr\u00ean, m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel Microsoft l\u00e0 th\u00eam tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 k\u00ed t\u1ef1 $). V\u1eady trong v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 copy c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t B n\u1eb1m trong trang t\u00ednh\u00a0<em>VAT,\u00a0<\/em>\u00f4 tham chi\u1ebfu c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh cho m\u1ed7i h\u00e0ng, v\u00e0 b\u1ea1n s\u1ebd c\u00f3 VAT cho m\u1ed7i m\u1eabu \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 tham chi\u1ebfu m\u1ed9t m\u1ea3ng c\u00e1c \u00f4 trong trang t\u00ednh kh\u00e1c. \u0110i\u1ec3m kh\u00e1c bi\u1ec7t duy nh\u1ea5t l\u00e0 ch\u1ecdn nhi\u1ec1u \u00f4 t\u1eeb trang t\u00ednh. V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ecm t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng trong c\u00e1c \u00f4 B2:B5 trong trang t\u00ednh\u00a0<em>Doanh s\u1ed1\u00a0<\/em>, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau<\/p>\n<p style=\"text-align: justify\"><strong>=SUM (\u2018Doanh s\u1ed1\u2019!B2:B5)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6562\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-06-05-at-10-38-25.png\" width=\"600\" height=\"340\" title=\"screen-shot-2017-06-05-at-10-38-25\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tham_chieu_tu_bang_tinh_khac\"><\/span><span style=\"font-size: 18pt\">Tham chi\u1ebfu t\u1eeb b\u1ea3ng t\u00ednh kh\u00e1c<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-size: 12pt\">Trong c\u00f4ng th\u1ee9c Microsoft Excel, tham chi\u1ebfu ngo\u1ea1i t\u1eeb b\u1ea3ng t\u00ednh kh\u00e1ch \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y theo hai c\u00e1ch d\u1ef1a tr\u00ean v\u1ecb tr\u00ed ngu\u1ed3n c\u1ee7a b\u1ea3ng t\u00ednh m\u1edf hay \u0111\u00f3ng<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Tham_chieu_ngoai_tu_bang_tinh_mo\"><\/span><strong>Tham chi\u1ebfu ngo\u1ea1i t\u1eeb b\u1ea3ng t\u00ednh m\u1edf<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Khi ngu\u1ed3n b\u1ea3ng t\u00ednh m\u1edf, tham chi\u1ebfu ngo\u1ea1i ch\u1ee9a t\u00ean b\u1ea3ng t\u00ednh \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c vu\u00f4ng (bao g\u1ed3m ph\u1ea7n m\u1edf r\u1ed9ng t\u1ec7p) \u0111\u1ee9ng tr\u01b0\u1edbc t\u00ean trang t\u00ednh, d\u1ea5u (!), v\u00e0 \u00f4 tham chi\u1ebfu ho\u1eb7c m\u1ea3ng tham chi\u1ebfu. C\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>[T\u00ean_b\u1ea3ng_t\u00ednh]T\u00ean_trang_t\u00ednh!\u0110\u1ecba_ch\u1ec9_\u00f4_tham_chi\u1ebfu<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 tham chi\u1ebfu ngo\u1ea1i t\u1edbi B2:B5 trong trang t\u00ednh Th\u00e1ng 1 n\u1eb1m trong b\u1ea3ng t\u00ednh Doanh s\u1ed1.xlsx:<\/p>\n<p style=\"text-align: justify\"><strong>[T\u1ed5ng.xlsx]\u2019T1\u2019B2:B5<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c \u00f4, c\u00f4ng th\u1ee9c tham chi\u1ebfu b\u1ea3ng t\u00ednh nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM ([T\u1ed5ng. xlsx]T1!B2:B5)<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Tham_chieu_ngoai_tu_bang_tinh_dong\"><\/span><strong>Tham chi\u1ebfu ngo\u1ea1i t\u1eeb b\u1ea3ng t\u00ednh \u0111\u00f3ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Khi tham chi\u1ebfu t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c, b\u1ea3ng t\u00ednh n\u00e0y kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i m\u1edf. N\u1ebfu ngu\u1ed3n c\u1ee7a b\u1ea3ng t\u00ednh l\u00e0 \u0111\u00f3ng, b\u1ea1n ph\u1ea3i ch\u00e8n \u0111\u01b0\u1eddng d\u1eabn t\u1edbi tham chi\u1ebfu ngo\u1ea1i<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 ch\u00e8n \u00f4 B2:B5 v\u00e0o trang t\u00ednh\u00a0<em>Th\u00e1ng 1\u00a0<\/em>t\u1eeb b\u1ea3ng t\u00ednh\u00a0<em>Doanh s\u1ed1. xlsx\u00a0<\/em>n\u1eb1m trong folder\u00a0<em>B\u00e1o c\u00e1o\u00a0<\/em>trong \u1ed5 D, c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM (D:BC[T\u1ed5ng. xlsx]\u2019T1\u2032!B2:B5)<\/strong><\/p>\n<p style=\"text-align: justify\">v\u1edbi<\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li>\u0110\u01b0\u1eddng d\u1eabn file: ch\u1ec9 ra \u1ed5 v\u00e0 \u0111\u01b0\u1eddng d\u1eabn t\u1edbi n\u01a1i l\u01b0u tr\u1eef file Excel (<em>D:BC <\/em>nh\u01b0 trong v\u00ed d\u1ee5 n\u00e0y)<\/li>\n<li>T\u00ean b\u1ea3ng t\u00ednh: g\u1ed3m t\u1ec7p m\u1edf r\u00f4ng (.xlsx, .xls, ho\u1eb7c xslm) v\u00e0 lu\u00f4n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong ngo\u1eb7c vu\u00f4ng nh\u01b0\u00a0<em>[T\u1ed5ng.xlsx]\u00a0<\/em>trong c\u00f4ng th\u1ee9c tr\u00ean<\/li>\n<li>T\u00ean trang t\u00ednh: n\u01a1i ch\u1ee9a \u00f4 tham chi\u1ebfu. Ph\u1ea7n n\u00e0y bao g\u1ed3m t\u00ean trang t\u00ednh v\u00e0 d\u1ea5u ch\u1ea5m than theo sau (nh\u01b0 trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 <em>\u2018T1\u2019!<\/em>)<\/li>\n<li>\u00d4 tham chi\u1ebfu: ch\u1ec9 \u00f4 ho\u1eb7c m\u1ea3ng \u00f4 tham chi\u1ebfu trong c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e3 t\u1ea1o tham chi\u1ebfu t\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh m\u1edf v\u00e0 sau \u0111\u00f3 \u0111\u00f3ng ngu\u1ed3n c\u1ee7a b\u1ea3ng t\u00ednh, tham chi\u1ebfu ngo\u1ea1i s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt bao g\u1ed3m c\u1ea3 \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7.<\/p>\n<ul style=\"list-style-type: square;text-align: justify\">\n<li><strong>L\u01b0u \u00fd:\u00a0<\/strong>N\u1ebfu t\u00ean trang t\u00ednh ho\u1eb7c t\u00ean b\u1ea3ng t\u00ednh ho\u1eb7c c\u1ea3 hai ch\u1ee9a k\u00ed t\u1ef1 tr\u1ed1ng ho\u1eb7c k\u00ed t\u1ef1 kh\u00f4ng ph\u1ea3i ch\u1eef c\u00e1i, b\u1ea1n ph\u1ea3i \u0111\u1eb7t t\u00ean ho\u1eb7c \u0111\u01b0\u1eddng d\u1eabn trong d\u1ea5u nh\u00e1y. V\u00ed d\u1ee5:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>=SUM(\u2018[Doanh s\u1ed1.xlsx]T1\u2019!B2:B5)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>=SUM (\u2018[T\u1ed5ng.xlsx] Th\u00e1ng 1\u2019!B2:B5)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>=SUM (\u2018D:B\u00e1o c\u00e1o[Doanh s\u1ed1.xlsx] Th\u00e1ng 1\u2019!B2:B5)<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Tao_tham_chieu_toi_mot_bang_tinh_khac_trong_Excel\"><\/span><strong>T\u1ea1o tham chi\u1ebfu t\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Gi\u1ed1ng nh\u01b0 tr\u01b0\u1eddng h\u1ee3p t\u1ea1o c\u00f4ng th\u1ee9c Excel tham chi\u1ebfu t\u1edbi trang t\u00ednh kh\u00e1c, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111\u00e1nh tham chi\u1ebfu t\u1edbi b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng. Ch\u1ec9 c\u1ea7n chuy\u1ec3n sang b\u1ea3ng t\u00ednh kh\u00e1c khi \u0111ang nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 ch\u1ecdn \u00f4 ho\u1eb7c m\u1ea3ng b\u1ea1n mu\u1ed1n tham chi\u1ebfu t\u1edbi. Microsoft Excel s\u1ebd l\u00e0m ph\u1ea7n vi\u1ec7c c\u00f2n l\u1ea1i<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6674 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-06-09-at-02-16-09.png\" width=\"564\" height=\"352\" title=\"screen-shot-2017-06-09-at-02-16-09\"><\/p>\n<ul style=\"list-style-type: square;text-align: justify\">\n<li><strong>L\u01b0u \u00fd:\u00a0<\/strong>Khi t\u1ea1o tham chi\u1ebfu t\u1edbi trang t\u00ednh kh\u00e1c b\u1eb1ng c\u00e1ch ch\u1ecdn \u00f4, Excel lu\u00f4n ch\u00e8n tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i. Do \u0111\u00f3, n\u1ebfu b\u1ea1n \u0111\u1ecbnh copy c\u00f4ng th\u1ee9c m\u1edbi l\u1eadp sang c\u00e1c \u00f4 kh\u00e1c, h\u00e3y ch\u1eafc r\u1eb1ng k\u00ed hi\u1ec7u dollar ($) \u0111\u01b0\u1ee3c b\u1ecf kh\u1ecfi \u00f4 tham chi\u1ebfu \u0111\u1ec3 \u0111\u01b0a tham chi\u1ebfu v\u1ec1 d\u1ea1ng t\u01b0\u01a1ng \u0111\u1ed1i ho\u1eb7c h\u1ed7n h\u1ee3p d\u1ef1a v\u00e0o m\u1ee5c \u0111\u00edch c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tham_chieu_toi_ten_trong_cung_hoac_khac_bang_tinh\"><\/span><span style=\"font-size: 18pt\">Tham chi\u1ebfu t\u1edbi t\u00ean trong c\u00f9ng ho\u1eb7c kh\u00e1c b\u1ea3ng t\u00ednh<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o tham chi\u1ebfu ngo\u1ea1i g\u1ecdn h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o t\u00ean trong ngu\u1ed3n trang t\u00ednh sau \u0111\u00f3 tham chi\u1ebfu t\u1edbi t\u00ean \u0111\u00f3 t\u1eeb trang t\u00ednh kh\u00e1c n\u1eb1m trong c\u00f9ng ho\u1eb7c kh\u00e1c b\u1ea3ng t\u00ednh.<\/p>\n<ul style=\"text-align: justify\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Tao_ten_trong_Excel\"><\/span><strong>T\u1ea1o t\u00ean trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o t\u00ean trong Excel, ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n tham chi\u1ebfu. Sau \u0111\u00f3 t\u1edbi tab\u00a0<em>Formulas&gt;Defined names\u00a0<\/em>v\u00e0 click v\u00e0o n\u00fat\u00a0<em>Define name\u00a0<\/em>ho\u1eb7c \u1ea5n Ctrl+F3 v\u00e0 click\u00a0<em>New<\/em><\/p>\n<p style=\"text-align: justify\">Trong h\u1ed9p tho\u1ea1i\u00a0<em>New Name,\u00a0<\/em>\u0111\u00e1nh t\u00ean b\u1ea1n mu\u1ed1n (nh\u1edb r\u1eb1ng k\u00ed t\u1ef1 tr\u1ed1ng kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho t\u00ean Excel), v\u00e0 ki\u1ec3m tra m\u1ea3ng tham chi\u1ebfu \u0111\u01b0\u1ee3c ghi trong \u00f4\u00a0<em>Refers to.<\/em><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 \u0111\u00e2y l\u00e0 c\u00e1ch t\u1ea1o t\u00ean (<em>Doanh_s\u1ed1_T1<\/em>) cho \u00f4 B2:B5 trong trang t\u00ednh Th\u00e1ng 1<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6675\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-06-09-at-10-56-19.png\" width=\"600\" height=\"331\" title=\"screen-shot-2017-06-09-at-10-56-19\"><\/p>\n<ul style=\"list-style-type: square;text-align: justify\">\n<li><strong>L\u01b0u \u00fd:\u00a0<\/strong>H\u00ecnh \u1ea3nh tr\u00ean s\u1eed d\u1ee5ng Excel 2016 n\u00ean giao di\u1ec7n Define Name s\u1ebd kh\u00e1c so v\u1edbi Excel 2013 tr\u1edf v\u1ec1 tr\u01b0\u1edbc v\u1edbi\u00a0<em>Refers to\u00a0<\/em>t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi\u00a0<em>Select the range of cells, Name\u00a0<\/em>t\u01b0\u01a1ng \u0111\u01b0\u01a1ng\u00a0<em>Enter a name for the data range.<\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Sau khi t\u00ean \u0111\u01b0\u1ee3c t\u1ea1o l\u1eadp, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tham chi\u1ebfu ngo\u1ea1i n\u00e0y trong Excel. \u0110\u1ecbnh d\u1ea1ng c\u1ee7a tham chi\u1ebfu n\u00e0y \u0111\u01a1n gian h\u01a1n nhi\u1ec1u so v\u1edbi tham chi\u1ebfu trang t\u00ednh v\u00e0 b\u1ea3ng t\u00ednh v\u1eeba \u0111\u1ec1 c\u1eadp tr\u00ean \u0111\u00e2y.<\/p>\n<ul style=\"list-style-type: square;text-align: justify\">\n<li><strong>L\u01b0u \u00fd:\u00a0<\/strong>T\u00ean \u0111\u01b0\u1ee3c t\u1ea1o m\u1eb7c \u0111\u1ecbnh v\u1edbi level b\u1ea3ng t\u00ednh (ghi trong m\u1ee5c <em>Scope\u00a0<\/em>t\u01b0\u01a1ng \u0111\u01b0\u01a1ng\u00a0<em>Name in workbook<\/em>). B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 l\u1eadp t\u00ean \u1edf level trang t\u00ednh b\u1eb1ng c\u00e1ch ch\u1ecdn trang t\u00ednh t\u01b0\u01a1ng \u1ee9ng t\u1eeb danh s\u00e1ch trong\u00a0<em>Scope (Names in workbook)<\/em>. \u0110\u1ed1i v\u1edbi tham chi\u1ebfu Excel, gi\u1edbi h\u1ea1n t\u00ean v\u00f4 c\u00f9ng quan tr\u1ecdng b\u1edfi n\u00f3 x\u00e1c \u0111\u1ecbnh gi\u1edbi h\u1ea1n m\u00e0 t\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi tham chi\u1ebfu.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">C\u00e1c b\u1ea1n n\u00ean t\u1ea1o t\u00ean \u1edf level b\u1ea3ng t\u00ednh (tr\u1eeb khi b\u1ea1n c\u00f3 l\u00fd do \u0111\u1ec3 kh\u00f4ng s\u1eed d\u1ee5ng n\u00f3) b\u1edfi ch\u00fang \u0111\u01a1n gi\u1ea3n ho\u00e1 vi\u1ec7c t\u1ea1o l\u1eadp tham chi\u1ebfu ngo\u1ea1i h\u01a1n nhi\u1ec1u so v\u1edbi t\u00ean trang t\u00ednh.<\/p>\n<ul style=\"text-align: justify\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Tham_chieu_ten_trong_trang_tinh_khac_nam_cung_mot_bang_tinh\"><\/span><strong>Tham chi\u1ebfu t\u00ean trong trang t\u00ednh kh\u00e1c n\u1eb1m c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u1ec3 tham chi\u1ebfu t\u00ean level b\u1ea3ng t\u00ednh trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh, b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u00e1nh t\u00ean v\u00e0o tham s\u1ed1 c\u1ee7a h\u00e0m<\/p>\n<p style=\"text-align: justify\"><strong>=Function (t\u00ean)<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 \u0111\u1ec3 t\u00ecm t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 n\u1eb1m trong t\u00ean Doanh_s\u1ed1_T1 m\u00e0 b\u1ea1n v\u1eeba l\u1eadp xong, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau<br \/>\n<strong>=SUM(Doanh_s\u1ed1_T1)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tham chi\u1ebfu t\u00ean level trang t\u00ednh t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c n\u1eb1m trong c\u00f9ng b\u1ea3ng t\u00ednh, b\u1ea1n ph\u1ea3i \u0111\u1eb7t t\u00ean tr\u01b0\u1edbc t\u00ean trang t\u00ednh v\u00e0 d\u1ea5u ch\u1ea5m than \u0111\u1eb1ng sau:<\/p>\n<p style=\"text-align: justify\"><strong>=Function (T\u00ean_trang_t\u00ednh!t\u00ean)<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5<\/p>\n<p style=\"text-align: justify\"><strong>=SUM (T1!Doanh_s\u1ed1_T1)<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu t\u00ean trang t\u00ednh ch\u1ee9a d\u1ea5u c\u00e1ch ho\u1eb7c k\u00ed t\u1ef1 kh\u00f4ng ph\u1ea3i ch\u1eef c\u00e1i, h\u00e3y nh\u1edb \u0111\u1eb7t ch\u00fang b\u00ean trong d\u1ea5u nh\u00e1y nh\u01b0 sau<\/p>\n<p style=\"text-align: justify\"><strong>=SUM(\u2018B\u00e1o c\u00e1o T1\u2019!Doanh_s\u1ed1_T1)<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Tham_chieu_ten_trong_bang_tinh_khac\"><\/span><strong>Tham chi\u1ebfu t\u00ean trong b\u1ea3ng t\u00ednh kh\u00e1c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Tham chi\u1ebfu t\u1edbi t\u00ean level b\u1ea3ng t\u00ednh \u1edf kh\u00e1c b\u1ea3ng t\u00ednh bao g\u1ed3m t\u00ean b\u1ea3ng t\u00ednh (g\u1ed3m t\u1ec7p m\u1edf r\u1ed9ng), d\u1ea5u ch\u1ea5m than v\u00e0 t\u00ean (t\u00ean c\u1ee7a m\u1ea3ng)<\/p>\n<p style=\"text-align: justify\"><strong>=Function (T\u00ean_b\u1ea3ng_t\u00ednh!t\u00ean)<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5<\/p>\n<p style=\"text-align: justify\"><strong>=SUM (T\u1ed5ng.xlsx!Doanh_s\u1ed1_T1)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tham chi\u1ebfu t\u00ean level trang t\u00ednh trong b\u1ea3ng t\u00ednh kh\u00e1c, t\u00ean trang t\u00ednh v\u00e0 d\u1ea5u ch\u1ea5m than theo sau c\u0169ng ph\u1ea3i n\u1eb1m trong c\u00f4ng th\u1ee9c, v\u00e0 t\u00ean b\u1ea3ng t\u00ednh ph\u1ea3i \u0111\u1eb7t trong ngo\u1eb7c vu\u00f4ng. V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM (\u2018CDocumentsT\u1ed5ng.xlsx\u2019!Doanh_s\u1ed1_T1)<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tao_tham_chieu_ten\"><\/span><strong>C\u00e1ch t\u1ea1o tham chi\u1ebfu t\u00ean<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e3 t\u1ea1o nhi\u1ec1u t\u00ean kh\u00e1c nhau trong trang t\u00ednh Excel, b\u1ea1n kh\u00f4ng c\u1ea7n thi\u1ebft ph\u1ea3i nh\u1edb t\u1ea5t c\u1ea3 t\u00ean c\u1ee7a ch\u00fang. \u0110\u1ec3 ch\u00e8n tham chi\u1ebfu t\u00ean v\u00e0o c\u00f4ng th\u1ee9c, th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau<\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li>Ch\u1ecdn v\u1ecb tr\u00ed \u00f4, nh\u00e2p d\u1ea5u (=) v\u00e0 \u0111\u00e1nh c\u00f4ng th\u1ee9c ho\u1eb7c ph\u00e9p to\u00e1n<\/li>\n<li>Khi mu\u1ed1n ch\u00e8n tham chi\u1ebfu t\u00ean, b\u1ea1n l\u00e0m nh\u01b0 sau<\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u1ebfu tham chi\u1ebfu t\u00ean \u1edf level b\u1ea3ng t\u00ednh n\u1eb1m trong b\u1ea3ng t\u00ednh kh\u00e1c, chuy\u1ec3n t\u1edbi b\u1ea3ng t\u00ednh \u0111\u00f3. N\u1ebfu t\u00ean n\u1eb1m trong trang t\u00ednh m\u00e0 c\u00f9ng b\u1ea3ng t\u00ednh, b\u1ecf qua b\u01b0\u1edbc n\u00e0y<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111ang l\u1eadp tham chi\u1ebfu t\u1edbi t\u00ean \u1edf level trang t\u00ednh, di chuy\u1ec3n t\u1edbi trang t\u00ednh \u0111\u00f3 (n\u1eb1m trong c\u00f9ng ho\u1eb7c kh\u00e1c b\u1ea3ng t\u00ednh)<\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li>\u1ea4n F3 \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i\u00a0<em>Paste Name,<\/em>\u00a0ch\u1ecdn t\u00ean b\u1ea1n mu\u1ed1n tham chi\u1ebfu v\u00e0 click OK<em>\u00a0<\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6720\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-06-09-at-18-18-17.png\" width=\"600\" height=\"586\" title=\"screen-shot-2017-06-09-at-18-18-17\"><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li>Nh\u1eadp xong c\u00f4ng th\u1ee9c ho\u1eb7c ph\u00e9p t\u00ednh v\u00e0 \u1ea5n Enter<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch t\u1ea1o tham chi\u1ebfu ngo\u1ea1i trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u00fang \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u cho c\u00e1c ph\u00e9p t\u00ednh d\u1ec5 d\u00e0ng h\u01a1n.<\/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-271.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6834,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6833","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\/6833","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=6833"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6833\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6834"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}