{"id":7588,"date":"2024-12-21T18:03:12","date_gmt":"2024-12-21T18:03:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-su-dung-ham-vlookup-ket-hop-voi-ham-sum-hoac-sumif-trong-excel\/"},"modified":"2024-12-21T18:03:12","modified_gmt":"2024-12-21T18:03:12","slug":"cach-su-dung-ham-vlookup-ket-hop-voi-ham-sum-hoac-sumif-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-su-dung-ham-vlookup-ket-hop-voi-ham-sum-hoac-sumif-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUM ho\u1eb7c SUMIF trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t v\u00e0i v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c n\u00e2ng cao di\u1ec5n gi\u1ea3i c\u00e1ch k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>h\u00e0m VLOOKUP<\/strong><\/a> v\u1edbi <strong>h\u00e0m SUM<\/strong> ho\u1eb7c <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF<\/strong><\/a> trong Excel \u0111\u1ec3 t\u00ecm v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1ed9t hay v\u00e0i ti\u00eau ch\u00ed.<\/em><\/p>\n<p style=\"text-align: justify\">C\u00f3 ph\u1ea3i b\u1ea1n \u0111ang c\u1ed1 t\u1ea1o ra m\u1ed9t t\u1eadp tin t\u00f3m t\u1eaft trong Excel \u2013 t\u1eadp tin m\u00e0 s\u1ebd x\u00e1c \u0111\u1ecbnh t\u1ea5t c\u1ea3 tr\u01b0\u1eddng h\u1ee3p c\u1ee7a m\u1ed9t g\u00e1i tr\u1ecb c\u1ee5 th\u1ec3 r\u1ed3i t\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb li\u00ean quan \u0111\u1ebfn c\u00e1c tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3? Hay, c\u00f3 ph\u1ea3i b\u1ea1n c\u1ea7n t\u00ecm t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb trong m\u1ed9t m\u1ea3ng \u0111\u00e1p \u1ee9ng nh\u01b0 c\u1ea7u c\u1ee7a b\u1ea1n r\u1ed3i t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb li\u00ean quan \u1edf m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c? Hay c\u00f3 th\u1ec3 b\u1ea1n \u0111ang g\u1eb7p ph\u1ea3i m\u1ed9t th\u1eed th\u00e1ch c\u1ee5 th\u1ec3 h\u01a1n th\u1ebf, ch\u1eb3ng h\u1ea1n nh\u01b0 xem qua b\u1ea3ng h\u00f3a \u0111\u01a1n c\u1ee7a c\u00f4ng ty, x\u00e1c \u0111\u1ecbnh t\u1ea5t c\u1ea3 h\u00f3a \u0111\u01a1n c\u1ee7a m\u1ed9t \u0111\u1ea1i l\u00fd c\u1ee5 th\u1ec3, r\u1ed3i t\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb h\u00f3a \u0111\u01a1n \u0111\u00f3?<\/p>\n<p style=\"text-align: justify\">Nhi\u1ec7m v\u1ee5 c\u00f3 th\u1ec3 kh\u00e1c nhau, nh\u01b0ng c\u00f3 c\u00f9ng b\u1ea3n ch\u1ea5t \u2013 b\u1ea1n mu\u1ed1n t\u00ecm v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1ed9t hay nhi\u1ec1u ti\u00eau ch\u00ed trong Excel. \u0110\u00f3 l\u00e0 lo\u1ea1i gi\u00e1 tr\u1ecb g\u00ec? B\u1ea5t c\u1ee9 gi\u00e1 tr\u1ecb s\u1ed1 n\u00e0o. V\u1eady ti\u00eau ch\u00ed l\u00e0 g\u00ec? B\u1ea5t k\u1ef3 ti\u00eau ch\u00ed n\u00e0o \ud83d\ude42 B\u1eaft \u0111\u1ea7u t\u1eeb m\u1ed9t ch\u1eef s\u00f4 hay m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c, r\u1ed3i k\u1ebft th\u00fac b\u1eb1ng to\u00e1n t\u1eed logic v\u00e0 c\u00f4ng th\u1ee9c trong Excel tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/p>\n<p style=\"text-align: justify\">V\u1eady, Microsoft Excel c\u00f3 b\u1ea5t c\u1ee9 t\u00ednh n\u0103ng n\u00e0o c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c nhi\u1ec7m v\u1ee5 tr\u00ean hay kh\u00f4ng? T\u1ea5t nhi\u00ean l\u00e0 c\u00f3 r\u1ed3i! B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ra gi\u1ea3i ph\u00e1p b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi h\u00e0m SUM hay h\u00e0m SUMIF trong Excel. C\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u c\u00e1ch c\u00e1c h\u00e0m n\u00e0y ho\u1ea1t \u0111\u1ed9ng v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang cho d\u1eef li\u1ec7u th\u1ef1c t\u1ebf.<\/p>\n<p style=\"text-align: justify\">H\u00e3y l\u01b0u \u00fd r\u1eb1ng, \u0111\u00e2y l\u00e0 c\u00e1c v\u00ed d\u1ee5 n\u00e2ng cao \u2013 \u0111i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n \u0111\u00e3 quen thu\u1ed9c v\u1edbi c\u00e1c quy t\u1eafc v\u00e0 c\u00fa ph\u00e1p c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m VLOOKUP. N\u1ebfu kh\u00f4ng, b\u1ea1n ch\u1eafc ch\u1eafn ph\u1ea3i xem qua ph\u1ea7n \u0111\u1ea7u ti\u00ean c\u1ee7a b\u00e0i h\u01b0\u1edbng d\u1eabn v\u1ec1 h\u00e0m VLOOKUP cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u.<\/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-676702df9dd07\" 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\/cach-su-dung-ham-vlookup-ket-hop-voi-ham-sum-hoac-ham-sumif-trong-excel.html#HAM_VLOOKUP_VA_HAM_SUM_TRONG_EXCEL_%E2%80%93_TINH_TONG_CUA_CAC_GIA_TRI_TRUNG_KHOP\" title=\"H\u00c0M VLOOKUP V\u00c0 H\u00c0M SUM TRONG EXCEL \u2013 T\u00cdNH T\u1ed4NG C\u1ee6A C\u00c1C GI\u00c1 TR\u1eca TR\u00d9NG KH\u1edaP\">H\u00c0M VLOOKUP V\u00c0 H\u00c0M SUM TRONG EXCEL \u2013 T\u00cdNH T\u1ed4NG C\u1ee6A C\u00c1C GI\u00c1 TR\u1eca TR\u00d9NG KH\u1edaP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-vlookup-ket-hop-voi-ham-sum-hoac-ham-sumif-trong-excel.html#CACH_THUC_HIEN_CAC_PHEP_TINH_KHAC_VOI_HAM_VLOOKUP_TRONG_EXCEL\" title=\"C\u00c1CH TH\u1ef0C HI\u1ec6N C\u00c1C PH\u00c9P T\u00cdNH KH\u00c1C V\u1edaI H\u00c0M VLOOKUP TRONG EXCEL\">C\u00c1CH TH\u1ef0C HI\u1ec6N C\u00c1C PH\u00c9P T\u00cdNH KH\u00c1C V\u1edaI H\u00c0M VLOOKUP TRONG EXCEL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-vlookup-ket-hop-voi-ham-sum-hoac-ham-sumif-trong-excel.html#HAM_LOOKUP_VA_HAM_SUM_%E2%80%93_TIM_KIEM_TRONG_MANG_VA_TINH_TONG_CAC_GIA_TRI_TRUNG_KHOP\" title=\"H\u00c0M LOOKUP V\u00c0 H\u00c0M SUM \u2013 T\u00ccM KI\u1ebeM TRONG M\u1ea2NG V\u00c0 T\u00cdNH T\u1ed4NG C\u00c1C GI\u00c1 TR\u1eca TR\u00d9NG KH\u1edaP\">H\u00c0M LOOKUP V\u00c0 H\u00c0M SUM \u2013 T\u00ccM KI\u1ebeM TRONG M\u1ea2NG V\u00c0 T\u00cdNH T\u1ed4NG C\u00c1C GI\u00c1 TR\u1eca TR\u00d9NG KH\u1edaP<\/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\/cach-su-dung-ham-vlookup-ket-hop-voi-ham-sum-hoac-ham-sumif-trong-excel.html#HAM_VLOOKUP_VA_HAM_SUMIF_%E2%80%93_TIM_KIEM_VA_TINH_TONG_CAC_GIA_TRI_DAP_UNG_CAC_TIEU_CHUAN_NHAT_DINH\" title=\"H\u00c0M VLOOKUP V\u00c0 H\u00c0M SUMIF \u2013 T\u00ccM KI\u1ebeM V\u00c0 T\u00cdNH T\u1ed4NG C\u00c1C GI\u00c1 TR\u1eca \u0110\u00c1P \u1ee8NG C\u00c1C TI\u00caU CHU\u1ea8N NH\u1ea4T \u0110\u1ecaNH\">H\u00c0M VLOOKUP V\u00c0 H\u00c0M SUMIF \u2013 T\u00ccM KI\u1ebeM V\u00c0 T\u00cdNH T\u1ed4NG C\u00c1C GI\u00c1 TR\u1eca \u0110\u00c1P \u1ee8NG C\u00c1C TI\u00caU CHU\u1ea8N NH\u1ea4T \u0110\u1ecaNH<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_VLOOKUP_VA_HAM_SUM_TRONG_EXCEL_%E2%80%93_TINH_TONG_CUA_CAC_GIA_TRI_TRUNG_KHOP\"><\/span>H\u00c0M VLOOKUP V\u00c0 H\u00c0M SUM TRONG EXCEL \u2013 T\u00cdNH T\u1ed4NG C\u1ee6A C\u00c1C GI\u00c1 TR\u1eca TR\u00d9NG KH\u1edaP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n thao t\u00e1c d\u1eef li\u1ec7u s\u1ed1 tr\u00ean Excel, th\u00ec th\u00f4ng th\u01b0\u1eddng b\u1ea1n kh\u00f4ng ph\u1ea3i ch\u1ec9 xu\u1ea5t c\u00e1c d\u1eef li\u1ec7u li\u00ean quan t\u1eeb m\u1ed9t b\u1ea3ng kh\u00e1c m\u00e0 c\u00f2n t\u00ednh t\u1ed5ng c\u00e1c con s\u1ed1 t\u1eeb m\u1ed9t v\u00e0i c\u1ed9t hay h\u00e0ng. \u0110\u1ec3 th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi h\u00e0m SUM.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 danh s\u00e1ch c\u00e1c s\u1ea3n ph\u1ea9m c\u00f3 \u0111\u00ednh doanh s\u1ed1 trong v\u00e0i th\u00e1ng, m\u1ed9t c\u1ed9t l\u00e0 m\u1ed9t th\u00e1ng.<\/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-680.gif\" title=\"ex101_92019-nho-680\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>D\u1eee LI\u1ec6U NGU\u1ed2N \u2013 DOANH S\u1ed0 H\u00c0NG TH\u00c1NG<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5795 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/51.png\" width=\"600\" height=\"197\" title=\"51\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, b\u1ea1n mu\u1ed1n l\u1eadp b\u1ea3ng t\u00ednh t\u1ed5ng v\u1ec1 t\u1ed5ng doanh s\u1ed1 c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p l\u00e0 s\u1eed d\u1ee5ng m\u1ea3ng trong th\u00f4ng s\u1ed1 th\u1ee9 ba (col_index_num) c\u1ee7a h\u00e0m VLOOKUP trong Excel. \u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c h\u00e0m VLOOKUP m\u1eabu:<\/p>\n<p style=\"text-align: justify\">=SUM(VLOOKUP(lookup_value, lookup_range, {2,3,4}, FALSE))<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, ch\u00fang ta s\u1eed d\u1ee5ng m\u1ea3ng {2,3,4} trong c\u00e2u l\u1ec7nh th\u1ee9 ba \u0111\u1ec3 hi\u1ec3n th\u1ecb v\u00e0i gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm trong c\u00f9ng c\u00f4ng th\u1ee9c VLOOKUP \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u1edf c\u1ed9t 2, 3, v\u00e0 4.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, h\u00e3y \u0111i\u1ec1u ch\u1ec9nh s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m VLOOKUP v\u00e0 h\u00e0m SUM \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta \u0111\u1ec3 t\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 doanh s\u1ed1 t\u1eeb c\u1ed9t B \u0111\u1ebfn c\u1ed9t M trong b\u1ea3ng tr\u00ean:<\/p>\n<p style=\"text-align: justify\">=SUM(VLOOKUP(B2, \u2018Doanh s\u1ed1 h\u00e0ng th\u00e1ng\u2019!$A$2:$M$9, {2,3,4,5,6,7,8,9,10,11,12,13},FALSE))<\/p>\n<p style=\"text-align: justify\"><strong>Quan tr\u1ecdng!<\/strong> V\u00ec b\u1ea1n \u0111ang t\u1ea1o m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, h\u00e3y ch\u1eafc r\u1eb1ng b\u1ea1n nh\u1ea5p Ctrl+Shift+Enter thay v\u00ec ch\u1ec9 nh\u1ea5n m\u1ed7i Enter khi b\u1ea1n g\u00f5 xong. Khi b\u1ea1n th\u1ef1c hi\u1ec7n xong, Microsoft Excel s\u1ebd \u0111\u00f3ng khung c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n trong d\u1ea5u ngo\u1eb7c nh\u1ecdn nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\">{=SUM(VLOOKUP(B2, \u2018Doanh s\u1ed1 h\u00e0ng th\u00e1ng\u2019!$A$2:$M$9, {2,3,4,5,6,7,8,9,10,11,12,13},FALSE))}<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n nh\u1ea5p Enter, th\u00ec ch\u1ec9 c\u00f3 gi\u00e1 t\u1ecb \u0111\u1ea7u ti\u00ean trong m\u1ea3ng \u0111\u01b0\u1ee3c x\u1eed l\u00fd, \u0111i\u1ec1u n\u00e0y s\u1ebd cho k\u1ebft qu\u1ea3 sai.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5796 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/52.png\" width=\"564\" height=\"241\" title=\"52\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.<\/strong> B\u1ea1n c\u00f3 th\u1ec3 t\u00f2 m\u00f2 l\u00e0 t\u1ea1i sao c\u00f4ng th\u1ee9c l\u1ea1i hi\u1ec3n th\u1ecb [@Product] nh\u01b0 l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh tr\u00ean. \u0110\u00f3 l\u00e0 v\u00ec t\u00f4i \u0111\u00e3 \u0111\u1ed5i d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh th\u00e0nh b\u1ea3ng (Insert tab&gt;Table). T\u00f4i c\u1ea3m th\u1ea5y r\u1ea5t thu\u1eadn ti\u1ec7n khi thao t\u00e1c v\u1edbi b\u1ea3ng Excel c\u00f3 \u0111\u1ea7y \u0111\u1ee7 ch\u1ee9c n\u0103ng h\u01a1n l\u00e0 c\u00e1c d\u1ea3i \u00f4. V\u00ed d\u1ee5, khi b\u1ea1n g\u00f5 c\u00f4ng th\u1ee9c v\u00e0o m\u1ed9t \u00f4, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p n\u00f3 cho to\u00e0n b\u1ed9 c\u1ed9t v\u00e0 trong c\u00e1ch n\u00e0y, n\u00f3 s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m v\u00e0i gi\u00e2y qu\u00fd b\u00e1u \ud83d\ude42<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">Th\u1ee7 thu\u1eadt Excel n\u00e2ng cao<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m VLOOKUP c\u00f9ng v\u1edbi h\u00e0m SUM r\u1ea5t d\u1ec5. Tuy nhi\u00ean, \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 gi\u1ea3i ph\u00e1p ho\u00e0n h\u1ea3o, \u0111\u1eb7c bi\u1ec7t khi b\u1ea1n \u0111ang thao t\u00e1c v\u1edbi b\u1ea3ng l\u1edbn. \u0110i\u1ec3m m\u1ea5u ch\u1ed1t \u1edf \u0111\u00e2y l\u00e0 vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng c\u00f3 th\u1ec3 g\u00e2y \u1ea3nh h\u01b0\u1edfng ng\u01b0\u1ee3c l\u1ea1i ho\u1ea1t \u0111\u1ed9ng c\u1ee7a s\u1ed5 l\u00e0m vi\u1ec7c v\u00ec m\u1ed7i gi\u00e1 tr\u1ecb trong m\u1ea3ng c\u1ea7n m\u1ed9t h\u00e0m VLOOKUP ri\u00eang bi\u1ec7t. V\u00ec th\u1ebf, c\u00e0ng c\u00f3 nhi\u1ec1u gi\u00e1 tr\u1ecb trong m\u1ea3ng th\u00ec c\u00e0ng c\u00f3 nhi\u1ec1u c\u00f4ng th\u1ee9c m\u1ea3ng trong s\u1ed5 l\u00e0m vi\u1ec7c, Excel s\u1ebd ch\u1ea1y c\u00e0ng ch\u1eadm.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf v\u1ea5n \u0111\u1ec1 n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX v\u00e0 h\u00e0m MATCH thay v\u00ec h\u00e0m VLOOKUP v\u00e0 h\u00e0m SUM, v\u00e0 t\u00f4i s\u1ebd cung c\u1ea5p cho b\u1ea1n v\u00e0i v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c trong b\u00e0i vi\u1ebft ti\u1ebfp theo.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_THUC_HIEN_CAC_PHEP_TINH_KHAC_VOI_HAM_VLOOKUP_TRONG_EXCEL\"><\/span>C\u00c1CH TH\u1ef0C HI\u1ec6N C\u00c1C PH\u00c9P T\u00cdNH KH\u00c1C V\u1edaI H\u00c0M VLOOKUP TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u00e0i ph\u00fat tr\u01b0\u1edbc, ch\u00fang ta th\u1ea3o lu\u1eadn v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t v\u00e0i c\u1ed9t trong b\u1ea3ng c\u1ea7n t\u00ecm v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3. T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c c\u00f3 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi h\u00e0m VLOOKUP. \u0110\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c:<\/p>\n<table style=\"height: 104px\" width=\"803\">\n<tbody>\n<tr>\n<td style=\"width: 260px\"><strong>Thao t\u00e1c<\/strong><\/td>\n<td style=\"width: 260px\"><strong>V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c<\/strong><\/td>\n<td style=\"width: 261px\"><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 260px\">T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh<\/td>\n<td style=\"width: 260px\">{=AVERAGE(VLOOKUP(A2, \u2018B\u1ea3ng c\u1ea7n t\u00ecm\u2019!$A$2:$D$10,{2,3,4},FALSE))}<\/td>\n<td style=\"width: 261px\">C\u00f4ng th\u1ee9c t\u00ecm gi\u00e1 tr\u1ecb t\u1eeb \u00f4 A2 trong \u201cB\u1ea3ng c\u1ea7n t\u00ecm\u2019 v\u00e0 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh \u1edf c\u00e1c c\u1ed9t B,C,D tr\u00ean c\u00f9ng m\u1ed9t h\u00e0ng.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 260px\">T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<\/td>\n<td style=\"width: 260px\">{=MAX(VLOOKUP(A2,\u2019B\u1ea3ng c\u1ea7n t\u00ecm\u2019$A$2:$D$10,{2,3,4},FALSE))}<\/td>\n<td style=\"width: 261px\">C\u00f4ng th\u1ee9c t\u00ecm gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t A2 trong \u2018B\u1ea3ng c\u1ea7n t\u00ecm\u2019 r\u1ed3i t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \u1edf c\u00e1c c\u1ed9t B, C, D tr\u00ean c\u00f9ng m\u1ed9t h\u00e0ng.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 260px\">T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t<\/td>\n<td style=\"width: 260px\">{=MIN(VLOOKUP(A2,\u2019B\u1ea3ng c\u1ea7n t\u00ecm\u2019$A$2:$D$10,{2,3,4},FALSE))}<\/td>\n<td style=\"width: 261px\">C\u00f4ng th\u1ee9c t\u00ecm gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t A2 trong \u2018B\u1ea3ng c\u1ea7n t\u00ecm\u2019 r\u1ed3i t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t \u1edf c\u00e1c c\u1ed9t B, C, D tr\u00ean c\u00f9ng m\u1ed9t h\u00e0ng.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 260px\">T\u00ednh ph\u1ea7n tr\u0103m tr\u00ean t\u1ed5ng s\u1ed1<\/td>\n<td style=\"width: 260px\">{=0.3*SUM(VLOOKUP(A2,\u2019B\u1ea3ng c\u1ea7n t\u00ecm\u2019$A$2:$D$10,{2,3,4},FALSE))}<\/td>\n<td style=\"width: 261px\">C\u00f4ng th\u1ee9c t\u00ecm gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t A2 trong \u2018B\u1ea3ng c\u1ea7n t\u00ecm\u2019, t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb \u1edf c\u00e1c c\u1ed9t B, C, D tr\u00ean c\u00f9ng m\u1ed9t h\u00e0ng, r\u1ed3i t\u00ednh 30% tr\u00ean t\u1ed5ng s\u1ed1.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> V\u00ec c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ec1u l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng, n\u00ean h\u00e3y nh\u1edb nh\u1ea5n Ctrl+Shift+Enter \u0111\u1ec3 nh\u1eadp ch\u00fang v\u00e0o \u00f4 \u0111\u01b0\u1ee3c ch\u00ednh x\u00e1c.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu ta th\u00eam c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean v\u00e0o b\u1ea3ng \u201cT\u1ed5ng doanh s\u1ed1\u201d c\u1ee7a v\u00ed d\u1ee5 tr\u01b0\u1edbc, th\u00ec k\u1ebft qu\u1ea3 s\u1ebd t\u01b0\u01a1ng t\u1ef1 nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5797 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/53.png\" width=\"600\" height=\"233\" title=\"53\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_LOOKUP_VA_HAM_SUM_%E2%80%93_TIM_KIEM_TRONG_MANG_VA_TINH_TONG_CAC_GIA_TRI_TRUNG_KHOP\"><\/span>H\u00c0M LOOKUP V\u00c0 H\u00c0M SUM \u2013 T\u00ccM KI\u1ebeM TRONG M\u1ea2NG V\u00c0 T\u00cdNH T\u1ed4NG C\u00c1C GI\u00c1 TR\u1eca TR\u00d9NG KH\u1edaP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p th\u00f4ng s\u1ed1 c\u1ea7n t\u00ecm l\u00e0 m\u1ed9t m\u1ea3ng thay v\u00ec m\u1ed9t gi\u00e1 tr\u1ecb ri\u00eang l\u1ebb, th\u00ec h\u00e0m VLOOKUP \u00a0s\u1ebd kh\u00f4ng c\u00f3 t\u00e1c d\u1ee5ng b\u1edfi v\u00ec n\u00f3 kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm trong c\u00e1c m\u1ea3ng d\u1eef li\u1ec7u. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LOOKUP \u2013 h\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi h\u00e0m VLOOKUP nh\u01b0ng c\u00f3 thao t\u00e1c v\u1edbi m\u1ea3ng v\u00e0 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang l\u1ebb.<\/p>\n<p style=\"text-align: justify\">H\u00e3y xem x\u00e9t c\u00e1c v\u00ed d\u1ee5 sau, \u0111\u1ec3 b\u1ea1n hi\u1ec3u h\u01a1n \u0111i\u1ec1u m\u00e0 t\u00f4i n\u00f3i. Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng li\u1ec7t k\u00ea t\u00ean kh\u00e1ch h\u00e0ng, s\u1ea3n ph\u1ea9m mua, v\u00e0 s\u1ed1 l\u01b0\u1ee3ng (B\u1ea3ng ch\u00ednh). B\u1ea1n c\u0169ng c\u00f3 b\u1ea3ng th\u1ee9 hai li\u1ec7t k\u00ea gi\u00e1 s\u1ea3n ph\u1ea9m (B\u1ea3ng c\u1ea7n t\u00ecm). Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 l\u1eadp c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng c\u00e1c \u0111\u01a1n h\u00e0ng \u0111\u1eb7t b\u1edfi c\u00e1c kh\u00e1ch h\u00e0ng x\u00e1c \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5798 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/54.png\" width=\"600\" height=\"242\" title=\"54\"><\/p>\n<p style=\"text-align: justify\">C\u00f3 th\u1ec3 b\u1ea1n v\u1eabn nh\u1edb, b\u1ea1n kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel b\u1edfi v\u00ec gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm (m\u1ea3ng d\u1eef li\u1ec7u) xu\u1ea5t hi\u1ec7n r\u1ea5t nhi\u1ec1u l\u1ea7n. Thay v\u00e0o \u0111\u00f3, b\u1ea1n k\u1ebft h\u1ee3p h\u00e0m LOOKUP v\u1edbi h\u00e0m SUM nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\">=SUM(LOOKUP($C$2:$C$10,\u2019B\u1ea3ng c\u1ea7n t\u00ecm\u2019!$A$2:$A$16,\u2019B\u1ea3ng c\u1ea7n t\u00ecm\u2019!$B$2:$B$16)*$D$2:$D$10*($B$2:$B$10=$G$1))<\/p>\n<p style=\"text-align: justify\">B\u1edfi v\u00ec \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng, h\u00e3y nh\u1edb nh\u1ea5n Ctrl+Shift+Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5799 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/55.png\" width=\"544\" height=\"284\" title=\"55\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, h\u00e3y ph\u00e2n t\u00edch c\u00e1c ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u1ec3 b\u1ea1n hi\u1ec3u m\u1ed7i h\u00e0m ho\u1ea1t \u0111\u1ed9ng ra sao v\u00e0 c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda n\u00f3 cho d\u1eef li\u1ec7u c\u1ee7a ri\u00eang b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">Ch\u00fang ta s\u1ebd \u0111\u1eb7t h\u00e0m SUM qua m\u1ed9t b\u00ean, b\u1edfi v\u00ec c\u00f4ng d\u1ee5ng c\u1ee7a n\u00f3 qu\u00e1 r\u00f5 r\u00e0ng, v\u00e0 ch\u1ec9 t\u1eadp trung v\u00e0o 3 th\u00e0nh ph\u1ea7n \u0111\u01b0\u1ee3c \u0111\u01b0\u1ee3c nh\u00e2n v\u1edbi nhau:<\/p>\n<ul style=\"text-align: justify\">\n<li>LOOKUP($C$2:$C$10,\u2019B\u1ea3ng c\u1ea7n t\u00ecm\u2019!$A$2:$A$16,\u2019B\u1ea3ng c\u1ea7n t\u00ecm\u2019!$B$2:$B$16)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00e0m LOOKUP n\u00e0y t\u00ecm ki\u1ebfm h\u00e0ng h\u00f3a \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong c\u1ed9t C trong b\u1ea3ng ch\u00ednh, v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 ti\u1ec1n t\u01b0\u01a1ng \u1ee9ng t\u1eeb c\u1ed9t B trong b\u1ea3ng c\u1ea7n t\u00ecm.<\/p>\n<ul style=\"text-align: justify\">\n<li>$D$2:$D$10<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Th\u00f4ng s\u1ed1 n\u00e0y tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng m\u1ed7i s\u1ea3n ph\u1ea9m mua b\u1edfi kh\u00e1ch h\u00e0ng, s\u1ed1 l\u01b0\u1ee3ng \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea \u1edf c\u1ed9t D trong b\u1ea3ng ch\u00ednh. Khi \u0111\u01b0\u1ee3c nh\u00e2n v\u1edbi gi\u00e1 ti\u1ec1n, \u0111i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi h\u00e0m VLOOKUP \u1edf tr\u00ean, h\u00e0m n\u00e0y s\u1ebd cung c\u1ea5p cho b\u1ea1n gi\u00e1 ti\u1ec1n c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m \u0111\u00e3 mua.<\/p>\n<ul style=\"text-align: justify\">\n<li>$B$2:$B$10=$G$1<\/li>\n<\/ul>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y so s\u00e1nh t\u00ean kh\u00e1ch h\u00e0ng \u1edf c\u1ed9t B v\u1edbi t\u00ean kh\u00e1ch h\u00e0ng \u1edf \u00f4 G1. N\u1ebfu tr\u00f9ng kh\u1edbp, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 \u201c1\u201d, n\u1ebfu kh\u00f4ng th\u00ec n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 \u201c0\u201d. B\u1ea1n s\u1eed d\u1ee5ng n\u00f3 ch\u1ec9 \u0111\u1ec3 x\u00f3a t\u00ean kh\u00e1ch h\u00e0ng kh\u00f4ng xu\u1ea5t hi\u1ec7n \u1edf \u00f4 G1, b\u1edfi v\u00ec t\u1ea5t c\u1ea3 ch\u00fang ta \u0111\u1ec1u bi\u1ebft b\u1ea5t c\u1ee9 s\u1ed1 n\u00e0o nh\u00e2n v\u1edbi 0 \u0111\u1ec1u b\u1eb1ng 0.<\/p>\n<p style=\"text-align: justify\">B\u1edfi v\u00ec c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng n\u00ean n\u00f3 l\u1eb7p l\u1ea1i qu\u00e1 tr\u00ecnh tr\u00ean cho m\u1ed7i gi\u00e1 tr\u1ecb trong m\u1ea3ng c\u1ea7n t\u00ecm. V\u00e0 cu\u1ed1i c\u00f9ng, h\u00e0m SUM t\u00ednh t\u1ed5ng c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p nh\u00e2n. Ch\u1eb3ng c\u00f3 g\u00ec kh\u00f3 kh\u0103n c\u1ea3, \u0111\u00fang kh\u00f4ng n\u00e0o?<\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> \u0110\u1ec3 c\u00f4ng th\u1ee9c LOOKUP ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i l\u1ecdc c\u1ed9t c\u1ea7n t\u00ecm trong b\u1ea3ng c\u1ea7n t\u00ecm theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n (t\u1eeb A \u0111\u1ebfn Z). N\u1ebfu vi\u1ec7c l\u1ecdc kh\u00f4ng \u0111\u01b0\u1ee3c ch\u1ea5p nh\u1eadn \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, th\u00ec h\u00e3y th\u1eed qua c\u00f4ng th\u1ee9c SUM\/TRANSPOSE \u0111\u01b0\u1ee3c g\u1ee3i \u00fd b\u1edfi Leo.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_VLOOKUP_VA_HAM_SUMIF_%E2%80%93_TIM_KIEM_VA_TINH_TONG_CAC_GIA_TRI_DAP_UNG_CAC_TIEU_CHUAN_NHAT_DINH\"><\/span>H\u00c0M VLOOKUP V\u00c0 H\u00c0M SUMIF \u2013 T\u00ccM KI\u1ebeM V\u00c0 T\u00cdNH T\u1ed4NG C\u00c1C GI\u00c1 TR\u1eca \u0110\u00c1P \u1ee8NG C\u00c1C TI\u00caU CHU\u1ea8N NH\u1ea4T \u0110\u1ecaNH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m SUMIF trong Excel th\u00ec t\u01b0\u01a1ng t\u1ef1 v\u1edbi h\u00e0m SUM v\u1ec1 m\u1eb7t t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb. \u0110i\u1ec3m kh\u00e1c bi\u1ec7t ch\u00ednh l\u00e0 h\u00e0m SUMIF t\u00ednh t\u1ed5ng ch\u1ec9 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00e1p \u1ee9ng ti\u00eau chu\u1ea9n m\u00e0 b\u1ea1n \u0111\u00e3 \u0111\u1ecbnh r\u00f5. V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c SUMIF \u0111\u01a1n gi\u1ea3n nh\u1ea5t =SUMIF(A2:A10,\u201d&gt;10\u2033) t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb \u00f4 A2 \u0111\u1ebfn \u00f4 A10, c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 10.<\/p>\n<p style=\"text-align: justify\">R\u1ea5t d\u1ec5, \u0111\u00fang kh\u00f4ng? V\u00e0 b\u00e2y gi\u1edd, h\u00e3y c\u00e2n nh\u1eafc m\u1ed9t tr\u01b0\u1eddng h\u1ee3p ph\u1ee9c t\u1ea1p h\u01a1n nhi\u1ec1u. Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng li\u1ec7t k\u00ea t\u00ean ng\u01b0\u1eddi b\u00e1n v\u00e0 s\u1ed1 ch\u1ee9ng minh nh\u00e2n d\u00e2n (b\u1ea3ng c\u1ea7n t\u00ecm). B\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng kh\u00e1c c\u00f3 c\u00f9ng s\u1ed1 ch\u1ee9ng minh nh\u00e2n d\u00e2n v\u00e0 c\u00e1c con s\u1ed1 li\u00ean quan \u0111\u1ebfn doanh s\u1ed1 (b\u1ea3ng ch\u00ednh). Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 t\u00ecm t\u1ed5ng doanh s\u1ed1 c\u1ee7a m\u1ed9t ng\u01b0\u1eddi x\u00e1c \u0111\u1ecbnh b\u1eb1ng s\u1ed1 ch\u1ee9ng minh nh\u00e2n d\u00e2n c\u1ee7a h\u1ecd. V\u00e0, c\u00f3 hai nh\u00e2n t\u1ed1 ph\u1ee9c t\u1ea1p:<\/p>\n<p style=\"text-align: justify\">B\u1ea3ng ch\u00ednh ch\u1ee9a nhi\u1ec1u m\u1ee5c c\u00f3 c\u00f9ng s\u1ed1 ch\u1ee9ng minh nh\u00e2n d\u00e2n theo th\u1ee9 t\u1ef1 ng\u1eabu nhi\u00ean.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n kh\u00f4ng th\u1ec3 th\u00eam c\u1ed9t \u201cT\u00ean ng\u01b0\u1eddi b\u00e1n\u201d v\u00e0o b\u1ea3ng ch\u00ednh.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5800 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/56.png\" width=\"592\" height=\"288\" title=\"56\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, h\u00e3y l\u1eadp c\u00f4ng th\u1ee9c m\u00e0, \u0111\u1ea7u ti\u00ean, t\u00ecm ki\u1ebfm t\u1ea5t c\u1ea3 doanh s\u1ed1 c\u1ee7a m\u1ed9t ng\u01b0\u1eddi x\u00e1c \u0111\u1ecbnh, v\u00e0 th\u1ee9 hai, t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb.<\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc khi l\u1eadp c\u00f4ng th\u1ee9c, h\u00e3y \u0111\u1ec3 t\u00f4i nh\u1eafc b\u1ea1n c\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIF:<\/p>\n<p style=\"text-align: justify\">SUMIF(range, criteria, [sum_range])<\/p>\n<p style=\"text-align: justify\">range \u2013 th\u00f4ng s\u1ed1 n\u00e0y \u0111\u00e3 t\u1ef1 gi\u1ea3i th\u00edch cho ch\u00ednh n\u00f3 r\u1ed3i, ch\u1ec9 l\u00e0 m\u1ed9t d\u1ea3i \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh gi\u00e1 th\u00f4ng qua c\u00e1c ti\u00eau chu\u1ea9n nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">criteria \u2013 \u0111i\u1ec1u ki\u1ec7n n\u00f3i cho c\u00f4ng th\u1ee9c bi\u1ebft c\u1ea7n t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb n\u00e0o. N\u00f3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c d\u00f9ng d\u01b0\u1edbi d\u1ea1ng s\u1ed1, tham chi\u1ebfu \u00f4, bi\u1ec3u th\u1ee9c, hay h\u00e0m Excel kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">sum_range \u2013 th\u00f4ng s\u1ed1 n\u00e0y l\u00e0 t\u00f9y ch\u1ecdn, nh\u01b0ng r\u1ea5t quan tr\u1ecdng \u0111\u1ed1i v\u1edbi ch\u00fang ta. N\u00f3 x\u00e1c \u0111\u1ecbnh d\u1ea3i \u00f4 n\u01a1i m\u00e0 c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 t\u01b0\u01a1ng \u1ee9ng s\u1ebd \u0111\u01b0\u1ee3c c\u1ed9ng. N\u1ebfu lo\u1ea1i b\u1ecf, Excel s\u1ebd t\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh \u1edf c\u00e2u l\u1ec7nh th\u1ee9 nh\u1ea5t (th\u00f4ng s\u1ed1 \u0111\u1ea7u ti\u00ean).<\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb nh\u1eefng \u0111i\u1ec1u tr\u00ean, gi\u1edd ch\u00fang ta h\u00e3y x\u00e1c \u0111\u1ecbnh ba th\u00f4ng s\u1ed1 cho h\u00e0m SUMIF c\u1ee7a m\u00ecnh. C\u00f3 th\u1ec3 b\u1ea1n v\u1eabn c\u00f2n nh\u1edb, ch\u00fang ta mu\u1ed1n t\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 doanh s\u1ed1 c\u1ee7a m\u1ed9t ng\u01b0\u1eddi x\u00e1c \u0111\u1ecbnh. T\u00ean c\u1ee7a ng\u01b0\u1eddi \u0111\u00f3 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 F2 trong b\u1ea3ng ch\u00ednh (h\u00e3y xem l\u1ea1i h\u00ecnh \u1ea3nh \u1edf tr\u00ean).<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Range<\/strong> \u2013 \u00a0b\u1edfi v\u00ec ch\u00fang ta \u0111ang t\u00ecm ki\u1ebfm th\u00f4ng qua s\u1ed1 ch\u1ee9ng minh nh\u00e2n d\u00e2n c\u1ee7a ng\u01b0\u1eddi b\u00e1n, n\u00ean th\u00f4ng s\u1ed1 range cho h\u00e0m SUMIF c\u1ee7a ch\u00fang ta ch\u00ednh l\u00e0 c\u1ed9t B \u1edf b\u1ea3ng ch\u00ednh. B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp d\u1ea3i \u00f4 B:B, hay n\u1ebfu b\u1ea1n \u0111\u1ed5i d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh th\u00e0nh b\u1ea3ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ean c\u1ed9t \u0111\u1ec3 thay th\u1ebf: Main_table[ID]<\/li>\n<li><strong>Criteria<\/strong> \u2013 b\u1edfi v\u00ec ch\u00fang ta c\u00f3 t\u00ean ng\u01b0\u1eddi b\u00e1n h\u00e0ng \u1edf b\u1ea3ng kh\u00e1c (b\u1ea3ng kh\u00e1c), n\u00ean ch\u00fang ta ph\u1ea3i c\u00f4ng th\u1ee9c VLOOKUP \u0111\u1ec3 t\u00ecm s\u1ed1 ch\u1ee9ng minh nh\u00e2n d\u00e2n t\u01b0\u01a1ng \u1ee9ng c\u1ee7a ng\u01b0\u1eddi \u0111\u00f3. T\u00ean c\u1ee7a ng\u01b0\u1eddi \u0111\u00f3 \u0111\u01b0\u1ee3c nh\u1eadp \u1edf \u00f4 F2 trong b\u1ea3ng ch\u00ednh, v\u00ec th\u1ebf ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec3 t\u00ecm ki\u1ebfm n\u00f3:<\/li>\n<\/ul>\n<p style=\"text-align: justify\">VLOOKUP($F$2,Lookup_table,2,FALSE)<\/p>\n<p style=\"text-align: justify\">T\u1ea5t nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp t\u00ean trong ti\u00eau chu\u1ea9n c\u1ea7n t\u00ecm c\u1ee7a h\u00e0m VLOOUP, nh\u01b0ng s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i th\u00ec t\u1ed1t h\u01a1n b\u1edfi v\u00ec n\u00f3 t\u1ea1o ra c\u00f4ng th\u1ee9c chung c\u00f3 hi\u1ec7u qu\u1ea3 cho b\u1ea5t c\u1ee9 t\u00ean n\u00e0o \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 x\u00e1c \u0111\u1ecbnh.<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Sum range<\/strong> \u2013 \u0111\u00e2y l\u00e0 ph\u1ea7n d\u1ec5 nh\u1ea5t. B\u1edfi v\u00ec c\u00e1c con s\u1ed1 th\u1ec3 hi\u1ec7n doanh thu c\u1ee7a ch\u00fang ta n\u1eb1m \u1edf c\u1ed9t C c\u00f3 t\u00ean \u201cDoanh s\u1ed1\u201d, ch\u00fang ta ch\u1ec9 c\u1ea7n \u0111\u1eb7t Main_table[Sales].<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, t\u1ea5t c\u1ea3 nh\u1eefng g\u00ec b\u1ea1n c\u1ea7n l\u00e0 t\u1eadp h\u1ee3p t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c l\u1ea1i v\u00e0 c\u00f4ng th\u1ee9c SUMIF + VLOOKUP c\u1ee7a b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng:<\/p>\n<p style=\"text-align: justify\">=SUMIF(Main_table[ID], VLOOKUP($F$2, Lookup_table, 2, FALSE), Main_table[Sales])<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5801 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/57.png\" width=\"563\" height=\"302\" title=\"57\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc<\/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-680.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7589,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7588","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\/7588","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=7588"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7588\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7589"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}