{"id":2868,"date":"2024-12-02T09:19:42","date_gmt":"2024-12-02T09:19:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif\/"},"modified":"2024-12-02T09:19:42","modified_gmt":"2024-12-02T09:19:42","slug":"excel-nang-cao-ket-hop-vlookup-sum-va-sumif","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif\/","title":{"rendered":"Excel n\u00e2ng cao: k\u1ebft h\u1ee3p VLOOKUP, SUM v\u00e0 SUMIF"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m VLOOKUP, SUM v\u00e0 SUMIF \u0111\u1ec3 d\u00f2 t\u00ecm v\u00e0 t\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean 1 s\u1ed1 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p><strong>M\u1ee5c l\u1ee5c<\/strong><\/p>\n<ol>\n<li>K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 SUMIF<\/li>\n<li>T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u kh\u00f4ng th\u00eam c\u1ed9t ph\u1ee5, k\u1ebft h\u1ee3p h\u00e0m LOOKUP v\u00e0 SUM<\/li>\n<li>K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 SUMIF tra c\u1ee9u v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>T\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u1edf c\u00f9ng 1 c\u1ed9t<\/li>\n<\/ol>\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-674d7bacc71fe\" 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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Ket_hop_ham_VLOOKUP_va_SUMIF\" title=\"K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 SUMIF\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 SUMIF<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Tong_hop_du_lieu_khong_them_cot_phu_ket_hop_ham_LOOKUP_va_SUM\" title=\"T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u kh\u00f4ng th\u00eam c\u1ed9t ph\u1ee5, k\u1ebft h\u1ee3p h\u00e0m LOOKUP v\u00e0 SUM:\">T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u kh\u00f4ng th\u00eam c\u1ed9t ph\u1ee5, k\u1ebft h\u1ee3p h\u00e0m LOOKUP v\u00e0 SUM:<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Ket_hop_ham_VLOOKUP_va_SUMIF_tra_cuu_va_tong_hop_du_lieu_theo_dieu_kien\" title=\"K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 SUMIF tra c\u1ee9u v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 SUMIF tra c\u1ee9u v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Tinh_tong_nhieu_dieu_kien_o_cung_1_cot\" title=\"T\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u1edf c\u00f9ng 1 c\u1ed9t:\">T\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u1edf c\u00f9ng 1 c\u1ed9t:<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Cac_vi_du_Excel_nang_cao_ket_hop_VLOOKUP_SUM_va_SUMIF\" title=\"C\u00e1c v\u00ed d\u1ee5 Excel n\u00e2ng cao: k\u1ebft h\u1ee3p VLOOKUP, SUM v\u00e0 SUMIF\">C\u00e1c v\u00ed d\u1ee5 Excel n\u00e2ng cao: k\u1ebft h\u1ee3p VLOOKUP, SUM v\u00e0 SUMIF<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Cach_su_dung_ham_Sumif_ket_hop_ham_vlookup\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif k\u1ebft h\u1ee3p h\u00e0m vlookup\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif k\u1ebft h\u1ee3p h\u00e0m vlookup<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Viet_ham_SUMIF\" title=\"Vi\u1ebft h\u00e0m SUMIF\">Vi\u1ebft h\u00e0m SUMIF<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Viet_ham_VLOOKUP\" title=\"Vi\u1ebft h\u00e0m VLOOKUP\">Vi\u1ebft h\u00e0m VLOOKUP<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Huong_dan_cach_su_dung_ham_Sumifs_ket_hop_ham_vlookup_trong_Excel\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumifs k\u1ebft h\u1ee3p h\u00e0m vlookup trong Excel\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumifs k\u1ebft h\u1ee3p h\u00e0m vlookup 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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Cach_viet_ham_SUMIFS\" title=\"C\u00e1ch vi\u1ebft h\u00e0m SUMIFS\">C\u00e1ch vi\u1ebft h\u00e0m SUMIFS<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html#Cach_viet_ham_VLOOKUP\" title=\"C\u00e1ch vi\u1ebft h\u00e0m VLOOKUP\">C\u00e1ch vi\u1ebft h\u00e0m VLOOKUP<\/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\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.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<h2><span class=\"ez-toc-section\" id=\"Ket_hop_ham_VLOOKUP_va_SUMIF\"><\/span><a id=\"doan-1\" href=\"\"><\/a>K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 SUMIF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u v\u00e0o b\u00e0i n\u00e0y, ch\u1eafc h\u1eb3n c\u00e1c b\u1ea1n \u0111\u00e3 th\u00e0nh th\u1ea1o v\u1edbi\u00a0 <strong><a href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m VLOOKUP<\/a> <\/strong>v\u00e0<a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"> <strong>h\u00e0m SUMIF <\/strong><\/a>r\u1ed3i. V\u1eady n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u v\u00e0o ngay v\u00ed d\u1ee5 \u0111\u1ea7u ti\u00ean.<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-15-at-13.32.18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1025\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-15-at-13-32-18-1024x255-1.png\" alt=\"screen-shot-2016-12-15-at-13-32-18\" width=\"1024\" height=\"255\" title=\"screen-shot-2016-12-15-at-13-32-18-1024x255-1\"><\/a><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd \u0111i t\u00ednh t\u1ed5ng s\u1ea3n l\u01b0\u1ee3ng c\u1ee7a Cam trong th\u00e1ng 1, th\u00e1ng 2, th\u00e1ng 3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y:<\/p>\n<blockquote>\n<p><strong><code class=\"excel-formula-block\">=SUM(VLOOKUP( A2 , A1:I8 , {2,3,4} , FALSE ))<\/code><\/strong><\/p>\n<\/blockquote>\n<p>Sau khi nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y, c\u00e1c b\u1ea1n l\u01b0u \u00fd v\u00ec \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng, v\u1eady n\u00ean sau khi nh\u1eadp c\u00f4ng th\u1ee9c, b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm <strong><code class=\"excel-formula-block\">CTRL + SHIFT + ENTER\u00a0<\/code><\/strong>\u0111\u1ec3 c\u00f3 th\u1ec3 nh\u1eadp \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c v\u00e0 c\u00f3 k\u1ebft qu\u1ea3 \u0111\u00fang.<\/p>\n<p>\u0110\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u h\u01a1n, ch\u00fang ta s\u1ebd ph\u00e2n t\u00edch c\u00f4ng th\u1ee9c m\u1ea3ng n\u00e0y b\u1eb1ng c\u00e1ch \u0111\u01b0a ra 3 c\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u0111\u01b0\u01a1ng sau \u0111\u00e2y:<\/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-219.gif\" title=\"ex101_92019-nho-219\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong><code class=\"excel-formula-block\"><br \/>\n=VLOOKUP( A2 , A1:I8 , 2 , FALSE ) + VLOOKUP( A2 , A1:I8 , 3 , FALSE ) + VLOOKUP( A2 , A1:I8 , 4 , FALSE )<\/code><\/strong><\/p>\n<p>Ph\u1ea7n <strong>{2,3,4} <\/strong>\u1edf trong c\u00f4ng th\u1ee9c m\u1ea3ng ph\u00eda tr\u00ean ngh\u0129a l\u00e0 c\u1ed9t 2,3,4 trong m\u1ea3ng d\u1eef li\u1ec7u <strong>A1:I8<\/strong>. \u0110\u1ecdc \u0111\u1ebfn \u0111\u00e2y, c\u00f3 th\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd c\u00f3 c\u00e2u h\u1ecfi, t\u1ea1i sao ch\u00fang ta kh\u00f4ng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 t\u00ednh t\u1ed5ng<\/p>\n<blockquote>\n<p><strong><code class=\"excel-formula-block\">=SUM(B2:D2)<\/code><\/strong><\/p>\n<\/blockquote>\n<p>M\u1ee5c \u0111\u00edch \u0111\u01b0a ra nh\u1eefng c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p n\u00e0y, ch\u00fang ta s\u1ebd ph\u1ee5c v\u1ee5 cho vi\u1ec7c <a href=\"http:\/\/bit.ly\/heoEDM05a\" target=\"_blank\" rel=\"noopener noreferrer\">t\u1ea1o b\u00e1o c\u00e1o ho\u1eb7c dashboard<\/a>. N\u1ebfu ch\u00fang ta s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng \u0111\u01a1n thu\u1ea7n b\u1eb1ng h\u00e0m SUM, khi ch\u00fang ta c\u00f3 1 \u00f4 ch\u1ee9a c\u00e1c lo\u1ea1i h\u00e0ng ho\u00e1, mu\u1ed1n thay \u0111\u1ed5i \u00f4 n\u00e0y \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ea3n l\u01b0\u1ee3ng c\u1ee7a 1 s\u1ea3n ph\u1ea9m, ch\u00fang ta ph\u1ea3i thay \u0111\u1ed5i c\u00f4ng th\u1ee9c SUM theo.<\/p>\n<p>V\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng k\u1ebft h\u1ee3p h\u00e0m SUM v\u00e0 VLOOKUP nh\u01b0 \u1edf tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o ra 1 b\u00e1o c\u00e1o v\u1ec1 s\u1ea3n l\u01b0\u1ee3ng c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m 1 c\u00e1ch nhanh ch\u00f3ng nh\u01b0 sau:<\/p>\n<p>\u00a0<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-15-at-13.47.46.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1026\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-15-at-13-47-46-1024x433-1.png\" alt=\"excel n\u00e2ng cao k\u1ebft h\u1ee3p sum v\u00e0 vlookup\" width=\"1024\" height=\"433\" title=\"screen-shot-2016-12-15-at-13-47-46-1024x433-1\"><\/a><\/p>\n<p>T\u1eeb v\u00ed d\u1ee5 ph\u00eda tr\u00ean, t\u1ea5t nhi\u00ean, ta c\u00f3 th\u1ec3 thay h\u00e0m SUM b\u1eb1ng 1 s\u1ed1 h\u00e0m kh\u00e1c \u0111\u1ec3 ph\u1ee5c v\u1ee5 m\u1ee5c \u0111\u00edch c\u1ee7a ch\u00fang ta nh\u01b0 h\u00e0m AVERAGE, h\u00e0m MIN, h\u00e0m MAX ho\u1eb7c th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n kh\u00e1c \u2026 V\u00e0 l\u01b0u \u00fd v\u00ec c\u00e1c c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec1u l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng, n\u00ean b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft <strong>CTRL + SHIFT + ENTER<\/strong> khi nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y trong Excel.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tong_hop_du_lieu_khong_them_cot_phu_ket_hop_ham_LOOKUP_va_SUM\"><\/span><a id=\"doan-2\" href=\"\"><\/a>T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u kh\u00f4ng th\u00eam c\u1ed9t ph\u1ee5, k\u1ebft h\u1ee3p h\u00e0m LOOKUP v\u00e0 SUM:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta c\u00f3 v\u00ed d\u1ee5 sau, trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 2 b\u1ea3ng d\u1eef li\u1ec7u, 1 b\u1ea3ng g\u1ed3m c\u00f3 s\u1ea3n ph\u1ea9m v\u00e0 \u0111\u01a1n gi\u00e1; b\u1ea3ng th\u1ee9 2 bao g\u1ed3m kh\u00e1ch h\u00e0ng, s\u1ea3n ph\u1ea9m v\u00e0 s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m kh\u00e1ch h\u00e0ng \u0111\u00e3 mua. Ch\u00fang ta s\u1ebd mu\u1ed1n \u0111i t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a 1 kh\u00e1ch h\u00e0ng<\/p>\n<figure id=\"attachment_1028\" aria-describedby=\"caption-attachment-1028\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-15-at-14.22.50.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1028\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-15-at-14-22-50-1024x260-1.png\" alt=\"Excel n\u00e2ng cao, k\u1ebft h\u1ee3p h\u00e0m SUM v\u00e0 LOOKUP\" width=\"1024\" height=\"260\" title=\"screen-shot-2016-12-15-at-14-22-50-1024x260-1\"><\/a><figcaption id=\"caption-attachment-1028\" class=\"wp-caption-text\">Excel n\u00e2ng cao, k\u1ebft h\u1ee3p h\u00e0m SUM v\u00e0 LOOKUP<\/figcaption><\/figure>\n<p>B\u00ecnh th\u01b0\u1eddng, ch\u00fang ta s\u1ebd c\u1ea7n d\u00f9ng c\u1ed9t ph\u1ee5 nh\u01b0 sau:<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-15-at-14.29.59.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1029\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-15-at-14-29-59-1024x208-1.png\" alt=\"Excel n\u00e2ng cao, sum k\u1ebft h\u1ee3p lookup\" width=\"1024\" height=\"208\" title=\"screen-shot-2016-12-15-at-14-29-59-1024x208-1\"><\/a><\/p>\n<p>C\u00e1c c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong><code class=\"excel-formula-block\">G2=VLOOKUP(E2,bang_SP,2,FALSE)<\/code><\/strong><\/p>\n<p><code class=\"excel-formula-block\"><strong>H2=F2*G2<\/strong><\/code><\/p>\n<p><code class=\"excel-formula-block\"><strong>K2=SUMIF(D:D,K1,H:H)<\/strong><\/code><\/p>\n<\/blockquote>\n<p>&lt;\/code.<br \/>\nTrong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng th\u00eam \u0111\u01b0\u1ee3c c\u1ed9t ph\u1ee5, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau t\u1ea1i K2:<\/p>\n<blockquote>\n<p><strong><code class=\"excel-formula-block\">K2=SUM(LOOKUP($E$2:$E$8,$A$2:$A$8,$B$2:$B$8)*$F$2:$F$8*($D$2:$D$8=K1))<\/code><\/strong><\/p>\n<\/blockquote>\n<p>Ch\u00fa \u00fd khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p SUM v\u00e0 LOOKUP n\u00e0y:<\/p>\n<ol>\n<li>C\u1ed9t A ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c t\u1eeb A \u0111\u1ebfn Z, \u0111\u1ec3 h\u00e0m LOOKUP cho ch\u00fang ta gi\u00e1 tr\u1ecb \u0111\u00fang.<\/li>\n<li>C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o b\u1eb1ng t\u1ed5 h\u1ee3p ph\u00edm <strong> <span class=\"xl-shortcut\">CTRL + SHIFT + ENTER <\/span><\/strong>N\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 thay h\u00e0m SUM b\u1eb1ng h\u00e0m SUMPRODUCT<\/li>\n<\/ol>\n<p>C\u00f4ng th\u1ee9c n\u00e0y \u0111\u01b0\u1ee3c hi\u1ec3u nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<ol>\n<li>Ph\u1ea7n\u00a0<strong><code class=\"excel-formula-inline\">LOOKUP($E$2:$E$8,$A$2:$A$8,$B$2:$B$8) <\/code> <\/strong>cho ch\u00fang ta k\u1ebft qu\u1ea3 nh\u01b0 c\u1ed9t \u0111\u01a1n gi\u00e1 trong h\u00ecnh ch\u1ee5p ph\u00eda tr\u00ean<\/li>\n<li>Ph\u1ea7n\u00a0<code class=\"excel-formula-inline\"><strong>$F$2:$F$8\u00a0<\/strong><\/code>l\u00e0 m\u1ea3ng s\u1ed1 l\u01b0\u1ee3ng c\u00e1c s\u1ea3n ph\u1ea9m<\/li>\n<li>Ph\u1ea7n\u00a0<strong><code class=\"excel-formula-inline\">($D$2:$D$8=K1)<\/code>\u00a0<\/strong> t\u1ea1o ra 1 m\u1ea3ng g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00fang v\u00e0 sai, khi l\u1ea5y m\u1ea3ng n\u00e0y nh\u00e2n v\u1edbi 1 s\u1ed1, th\u00ec quy t\u1eafc sau \u0111\u00e2y \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng: (TRUE \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a l\u00e0 1, FALSE \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a l\u00e0 0)<\/li>\n<li>V\u00e0 cu\u1ed1i c\u00f9ng, h\u00e0m SUM s\u1ebd t\u00ednh t\u1ed5ng v\u00e0 cho ta k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng<\/li>\n<\/ol>\n<p>T\u1edbi \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 download file excel \u0111\u1ec3 theo d\u00f5i cho d\u1ec5 <a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/15122016-ket-hop-ham-sum-vlookup.xlsx\">ta\u0323i \u0111\u00e2y<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_hop_ham_VLOOKUP_va_SUMIF_tra_cuu_va_tong_hop_du_lieu_theo_dieu_kien\"><\/span><a id=\"doan-3\" href=\"\"><\/a>K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 SUMIF tra c\u1ee9u v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u0301 du\u0323:<\/p>\n<figure id=\"attachment_1032\" aria-describedby=\"caption-attachment-1032\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-15-at-15.05.01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1032\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-15-at-15-05-01-1024x313-1.png\" alt=\"Excel n\u00e2ng cao, k\u1ebft h\u1ee3p VLOOKUP v\u00e0 SUMIF\" width=\"1024\" height=\"313\" title=\"screen-shot-2016-12-15-at-15-05-01-1024x313-1\"><\/a><figcaption id=\"caption-attachment-1032\" class=\"wp-caption-text\">Excel n\u00e2ng cao, k\u1ebft h\u1ee3p VLOOKUP v\u00e0 SUMIF<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ta c\u00f3 2 b\u1ea3ng, 1 b\u1ea3ng l\u00e0 t\u00ean Telesale v\u00e0 ID c\u1ee7a h\u1ecd, 1 b\u1ea3ng kh\u00e1c ch\u1ec9 c\u00f3 ID v\u00e0 doanh s\u1ed1. Nhi\u1ec7m v\u1ee5 \u1edf v\u00ed d\u1ee5 n\u00e0y: c\u1ea7n \u0111i t\u00ednh t\u1ed5ng doanh s\u1ed1 c\u1ee7a b\u1ea5t k\u00ec Telesale n\u00e0o d\u1ef1a v\u00e0o t\u00ean c\u1ee7a h\u1ecd.<\/p>\n<p>C\u00f4ng th\u1ee9c ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng \u1edf \u0111\u00e2y l\u00e0<\/p>\n<blockquote>\n<p><strong><code class=\"excel-formula-inline\">=SUMIF(D:D,VLOOKUP(H1,A1:B8,2,FALSE),E:E)<\/code><\/strong><\/p>\n<\/blockquote>\n<p>VLOOKUP s\u1ebd c\u00f3 nhi\u1ec7m v\u1ee5 \u0111\u01b0a l\u1ea1i m\u00e3 ID c\u1ee7a Telesale v\u1edbi t\u00ean t\u01b0\u01a1ng \u1ee9ng, d\u1ef1a v\u00e0o ID n\u00e0y ch\u00fang ta \u00e1p d\u1ee5ng SUMIF nh\u01b0 m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n b\u00ecnh th\u01b0\u1eddng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_tong_nhieu_dieu_kien_o_cung_1_cot\"><\/span><a id=\"doan-4\" href=\"\"><\/a>T\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u1edf c\u00f9ng 1 c\u1ed9t:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta c\u00f3 v\u00ed d\u1ee5 t\u00ednh t\u1ed5ng sau \u0111\u00e2y, \u0111i\u1ec1u ki\u1ec7n t\u00ednh t\u1ed5ng \u0111\u1ec1u n\u0103m \u1edf 1 c\u1ed9t: T\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c giao d\u1ecbch v\u1edbi \u0111\u1ea7u m\u00e3 l\u00e0 111 v\u00e0 131<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2017-01-01-at-23.33.24.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2389\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-01-01-at-23-33-24-1024x381-1.png\" width=\"1024\" height=\"381\" title=\"screen-shot-2017-01-01-at-23-33-24-1024x381-1\"><\/a><\/p>\n<p>\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, ch\u00fang ta c\u00f3 3 c\u00e1ch t\u00ednh, v\u1edbi c\u00e1ch m\u00e0 c\u00f4ng th\u1ee9c c\u00f3 d\u1ea5u {}, ngh\u0129a l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng, b\u1ea1n c\u1ea7n nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft CTRL + SHIFT + ENTER sau khi nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3<\/p>\n<table style=\"height: 123px\" width=\"550\">\n<tbody>\n<tr>\n<td style=\"width: 540px\"><strong>=SUMIF(A:A,\u201d111*\u201d,C:C)+SUMIF(A:A,\u201d131*\u201d,C:C)<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 540px\"><strong>{=SUM(SUMIF(A:A,{\u201c111*\u201d,\u201d131*\u201d},C:C))}<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 540px\"><strong>{=SUM(C2:C14*(\u2013(LEFT(A2:A14,3)={\u201c111\u2033,\u201d131\u201d})))}<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>V\u1eady l\u00e0 trong b\u00e0i n\u00e0y, ch\u00fang ta \u0111\u00e3 c\u00f9ng nhau t\u00ecm hi\u1ec3u m\u1ed9t s\u1ed1 c\u00e1ch k\u1ebft h\u1ee3p c\u00f4ng th\u1ee9c, h\u00e0m t\u00ednh t\u1ed5ng v\u1edbi c\u00e1c h\u00e0m d\u00f2 t\u00ecm \u0111\u1ec3 gi\u1ea3i quy\u1ebft nhu c\u1ea7u l\u00e0m b\u00e1o c\u00e1o m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng th\u00eam c\u1ed9t ph\u1ee5. Hi v\u1ecdng b\u00e0i vi\u1ebft c\u00f3 \u00edch cho c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n \u0111\u1eb7c bi\u1ec7t l\u00e0 trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n, l\u1eadp b\u00e1o c\u00e1o trong kho.<\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel:<\/p>\n<p><strong>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/strong><\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p><strong>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/strong><\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cac_vi_du_Excel_nang_cao_ket_hop_VLOOKUP_SUM_va_SUMIF\"><\/span>C\u00e1c v\u00ed d\u1ee5 Excel n\u00e2ng cao: k\u1ebft h\u1ee3p VLOOKUP, SUM v\u00e0 SUMIF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Sumif_ket_hop_ham_vlookup\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Sumif k\u1ebft h\u1ee3p h\u00e0m vlookup<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 gi\u00fap ch\u00fang ta d\u1ec5 h\u00ecnh dung\u00a0\u0111\u01b0\u1ee3c khi n\u00e0o th\u00ec s\u1eed d\u1ee5ng h\u00e0m Sumif k\u1ebft h\u1ee3p h\u00e0m vlookup, h\u00e3y xem v\u00ed d\u1ee5 sau\u00a0\u0111\u00e2y:<\/p>\n<figure id=\"attachment_23376\" aria-describedby=\"caption-attachment-23376\" style=\"width: 832px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23376 size-full\" title=\"c\u00e1ch\u00a0s\u1eed d\u1ee5ng h\u00e0m Sumif k\u1ebft h\u1ee3p h\u00e0m vlookup\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-ket-hop-vlookup-de-bai.png\" alt=\"c\u00e1ch\u00a0s\u1eed d\u1ee5ng h\u00e0m Sumif k\u1ebft h\u1ee3p h\u00e0m vlookup\" width=\"832\" height=\"477\"><figcaption id=\"caption-attachment-23376\" class=\"wp-caption-text\"><em>C\u00e1ch\u00a0s\u1eed d\u1ee5ng h\u00e0m Sumif k\u1ebft h\u1ee3p h\u00e0m vlookup<\/em><\/figcaption><\/figure>\n<p>Ch\u00fang ta c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb A1:C15, g\u1ed3m c\u00e1c c\u1ed9t M\u00e3 h\u00e0ng, Ng\u00e0y b\u00e1n, S\u1ed1 l\u01b0\u1ee3ng b\u00e1n\u00a0\u0111\u01b0\u1ee3c c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng.<\/p>\n<p>Tuy nhi\u00ean y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta l\u00e0 t\u00ednh t\u1ed5ng s\u1ed1\u00a0l\u01b0\u1ee3ng b\u00e1n theo T\u00ean m\u1eb7t h\u00e0ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn trong\u00a0\u00f4 F11.\u00a0Trong b\u1ea3ng d\u1eef li\u1ec7u A1:C15 kh\u00f4ng c\u00f3 c\u1ed9t t\u00ean m\u1eb7t h\u00e0ng. Mu\u1ed1n bi\u1ebft T\u00ean m\u1eb7t h\u00e0ng\u00a0\u0111\u00f3\u00a0\u1ee9ng v\u1edbi M\u00e3 h\u00e0ng n\u00e0o, ch\u00fang ta ph\u1ea3i tham chi\u1ebfu trong b\u1ea3ng E1:F8.<\/p>\n<p>Nh\u01b0 v\u1eady:<\/p>\n<ul>\n<li>Y\u00eau c\u1ea7u t\u00ednh t\u1ed5ng theo\u00a0\u0111i\u1ec1u ki\u1ec7n =&gt; S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF<\/strong><\/a> x\u00e1c\u00a0\u0111\u1ecbnh k\u1ebft qu\u1ea3<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n kh\u00f4ng x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c 1 c\u00e1ch tr\u1ef1c ti\u1ebfp m\u00e0 ph\u1ea3i tham chi\u1ebfu t\u1edbi 1 b\u1ea3ng kh\u00e1c =&gt; S\u1eed d\u1ee5ng<strong> VLOOKUP<\/strong> x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec1u ki\u1ec7n<\/li>\n<\/ul>\n<p>C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Viet_ham_SUMIF\"><\/span>Vi\u1ebft h\u00e0m SUMIF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m SUMIF bao g\u1ed3m: <code class=\"excel-formula-inline\">=SUMIF(Range, Criteria, Sum_range)<\/code><\/p>\n<ul>\n<li>Range: v\u00f9ng ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n.\u00a0\u1ede trong b\u1ea3ng A1:C15 ch\u1ec9 c\u00f3 c\u1ed9t M\u00e3 h\u00e0ng l\u00e0 c\u00f3 li\u00ean quan t\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n =&gt; Ch\u1ecdn v\u00f9ng\u00a0A2:A15 (kh\u00f4ng ch\u1ecdn d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1)<\/li>\n<li>Criteria:\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ee7a \u0111\u1ec1 b\u00e0i\u00a0l\u00e0 T\u00ean h\u00e0ng. Nh\u01b0ng Range l\u1ea1i l\u00e0 M\u00e3 h\u00e0ng. Do\u00a0\u0111\u00f3 ph\u1ea3i tham chi\u1ebfu ra M\u00e3 h\u00e0ng d\u1ef1a v\u00e0o T\u00ean h\u00e0ng =&gt; S\u1eed d\u1ee5ng h\u00e0m VLOOKUP.<\/li>\n<li>Sum_range: k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh l\u00e0 S\u1ed1 l\u01b0\u1ee3ng. Do\u00a0\u0111\u00f3 ch\u1ecdn v\u00f9ng C2:C15<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Viet_ham_VLOOKUP\"><\/span>Vi\u1ebft h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta mu\u1ed1n tham chi\u1ebfu M\u00e3 h\u00e0ng d\u1ef1a v\u00e0o T\u00ean h\u00e0ng, do\u00a0\u0111\u00f3 <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>s\u1ebd vi\u1ebft nh\u01b0 sau:<\/p>\n<p><strong>=VLOOKUP(gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, v\u00f9ng tham chi\u1ebfu, c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3, ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm)<\/strong><\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm: l\u00e0 t\u00ean h\u00e0ng t\u1ea1i\u00a0\u00f4 F11<\/li>\n<li>V\u00f9ng tham chi\u1ebfu: V\u00f9ng b\u1ea3ng E2:F8 (c\u00f3 th\u1ec3 b\u1ecf qua d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1)<\/li>\n<li>C\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3: c\u1ed9t M\u00e3 h\u00e0ng l\u00e0 c\u1ed9t th\u1ee9 2<\/li>\n<li>Ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm: t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c theo t\u00ean h\u00e0ng =&gt; nh\u1eadp s\u1ed1 0<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ta c\u00f3 VLOOKUP(F11,E2:F8,2,0)<\/p>\n<p>Xem th\u00eam:<strong>\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">H\u00e0m vlookup trong Excel v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng n\u00e2ng cao th\u01b0\u1eddng g\u1eb7p<\/a><\/strong><\/p>\n<p>Khi k\u1ebft h\u1ee3p hai h\u00e0m v\u1edbi nhau ta c\u00f3 c\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 F13 nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\"><strong><code class=\"excel-formula-inline\">=SUMIF(A2:A15,VLOOKUP(F11,E2:F8,2,0),C2:C15)<\/code><\/strong><\/p>\n<figure id=\"attachment_23377\" aria-describedby=\"caption-attachment-23377\" style=\"width: 1013px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23377 size-full\" title=\"C\u00e1ch d\u00f9ng h\u00e0m Vlookup trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-ket-hop-vlookup-cong-thuc.png\" alt=\"C\u00e1ch d\u00f9ng h\u00e0m Vlookup trong Excel\" width=\"1013\" height=\"477\"><figcaption id=\"caption-attachment-23377\" class=\"wp-caption-text\">C\u00e1ch d\u00f9ng h\u00e0m Vlookup trong Excel<\/figcaption><\/figure>\n<p>Khi vi\u1ebft <strong>h\u00e0m SUMIF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m VLOOKUP<\/strong>, ch\u00fang ta c\u1ea7n ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh: h\u00e0m VLOOKUP s\u1ebd\u00a0\u0111\u1eb7t t\u1ea1i v\u1ecb tr\u00ed tham s\u1ed1\u00a0n\u00e0o trong h\u00e0m SUMIF. Th\u00f4ng th\u01b0\u1eddng hay g\u1eb7p nh\u1ea5t ch\u00ednh l\u00e0:\u00a0\u0110i\u1ec1u ki\u1ec7n trong h\u00e0m SUMIF kh\u00f4ng x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c 1 c\u00e1ch tr\u1ef1c ti\u1ebfp, m\u00e0 ph\u1ea3i tham chi\u1ebfu t\u1edbi 1 b\u1ea3ng t\u00ednh n\u00e0o\u00a0\u0111\u00f3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Huong_dan_cach_su_dung_ham_Sumifs_ket_hop_ham_vlookup_trong_Excel\"><\/span>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumifs k\u1ebft h\u1ee3p h\u00e0m vlookup trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html\"><strong>H\u00e0m SUMIFS<\/strong><\/a> l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t h\u1eefu\u00a0\u00edch trong\u00a0Excel gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac. Nh\u01b0ng trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u00e1o c\u00e1o l\u1ea1i kh\u00f4ng x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c m\u1ed9t c\u00e1ch tr\u1ef1c ti\u1ebfp m\u00e0 ph\u1ea3i tham chi\u1ebfu t\u1edbi 1 v\u00f9ng d\u1eef li\u1ec7u kh\u00e1c. Khi\u00a0\u0111\u00f3 ch\u00fang ta c\u1ea7n ph\u1ea3i k\u1ebft h\u1ee3p h\u00e0m SUMIFS v\u1edbi<strong> h\u00e0m VLOOKUP<\/strong>. Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n bi\u1ebft\u00a0s\u1eed d\u1ee5ng h\u00e0m Sumifs k\u1ebft h\u1ee3p h\u00e0m vlookup trong Excel.<\/p>\n<p>Tr\u01b0\u1edbc ti\u00ean h\u00e3y x\u00e9t v\u00ed d\u1ee5 sau\u00a0\u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23387\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumifs-ket-hop-vlookup-de-bai.png\" width=\"991\" height=\"476\" title=\"sumifs-ket-hop-vlookup-de-bai\"><\/p>\n<p>Trong y\u00eau c\u1ea7u tr\u00ean, ch\u00fang ta th\u1ea5y c\u00f3 t\u1edbi 3\u00a0\u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>\u0110i\u1ec1u ki\u1ec7n 1: T\u1eeb ng\u00e0y <strong>01\/06\/2018<\/strong><\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 2:\u00a0\u0110\u1ebfn ng\u00e0y<strong> 30\/06\/2018<\/strong><\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 3: T\u00ean h\u00e0ng l\u00e0 <strong>M\u1eadn H\u00e0 Giang lo\u1ea1i 2<\/strong> (t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi m\u00e3 l\u00e0 M102 trong b\u1ea3ng E1:F8)<\/li>\n<\/ul>\n<p>V\u00ec v\u1eady\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ednh\u00a0\u0111\u01b0\u1ee3c s\u1ed1 l\u01b0\u1ee3ng b\u00e1n th\u1ecfa m\u00e3n\u00a0\u0111\u1ed3ng th\u1eddi c\u1ea3 3\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u00ean, ch\u00fang ta s\u1ebd c\u1ea7n d\u00f9ng t\u1edbi h\u00e0m SUMIFS.<\/p>\n<p>Nh\u01b0ng\u00a0\u1edf\u00a0\u0111i\u1ec1u ki\u1ec7n 3 l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n li\u00ean quan t\u1edbi t\u00ean h\u00e0ng. T\u00ean h\u00e0ng kh\u00f4ng c\u00f3 s\u1eb5n trong b\u1ea3ng d\u1eef li\u1ec7u A1:C15 m\u00e0 ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh th\u00f4ng qua b\u1ea3ng E1:F8. T\u1eeb t\u00ean h\u00e0ng (\u1edf \u00f4 F13)\u00a0tham chi\u1ebfu ra m\u00e3 h\u00e0ng t\u01b0\u01a1ng\u00a0\u1ee9ng. S\u1eed d\u1ee5ng m\u00e3 h\u00e0ng\u00a0\u0111\u00f3 tham chi\u1ebfu ti\u1ebfp t\u1edbi c\u1ed9t M\u00e3 h\u00e0ng trong b\u1ea3ng A1:C15\u00a0\u0111\u1ec3 ra k\u1ebft qu\u1ea3 cho h\u00e0m SUMIFS.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_ham_SUMIFS\"><\/span>C\u00e1ch vi\u1ebft h\u00e0m SUMIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ea5u tr\u00fac h\u00e0m SUMIFS v\u1edbi 3\u00a0\u0111i\u1ec1u ki\u1ec7n bao g\u1ed3m:<\/p>\n<p><code class=\"excel-formula-inline\">=SUMIFS(<span style=\"color: #ff0000\">V\u00f9ng t\u00ednh t\u1ed5ng<\/span>, <span style=\"color: #0000ff\">v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 1<\/span>,\u00a0<span style=\"color: #0000ff\">\u0111i\u1ec1u ki\u1ec7n 1<\/span>, <span style=\"color: #993366\">v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 2<\/span>,\u00a0<span style=\"color: #993366\">\u0111i\u1ec1u ki\u1ec7n 2<\/span>,\u00a0<span style=\"color: #339966\">v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 3<\/span>,\u00a0<span style=\"color: #339966\">\u0111i\u1ec1u ki\u1ec7n 3<\/span>)<\/code><\/p>\n<ul>\n<li>V\u00f9ng t\u00ednh t\u1ed5ng: T\u00ednh t\u1ed5ng s\u1ed1\u00a0l\u01b0\u1ee3ng, do\u00a0\u0111\u00f3 l\u1ea5y theo v\u00f9ng C2:C15<\/li>\n<li>V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 1: c\u1ed9t Ng\u00e0y (v\u00ec ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n 1 l\u00e0 ng\u00e0y) v\u00f9ng B2:B15<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n th\u1ee9 1: T\u1eeb ng\u00e0y 01\/06\/2018 l\u00e0 gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 F11. Tuy nhi\u00ean t\u1eeb ng\u00e0y\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 &gt;=, do\u00a0\u0111\u00f3 c\u00e1ch vi\u1ebft l\u00e0 \u201c&gt;=\u201d&amp;F11<\/li>\n<li>V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 2: c\u1ed9t Ng\u00e0y (v\u00ec ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a02 l\u00e0 ng\u00e0y) v\u00f9ng B2:B15<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n th\u1ee9 2:\u00a0\u0110\u1ebfn\u00a0ng\u00e0y 30\/06\/2018 l\u00e0 gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 F12. Tuy nhi\u00ean t\u1eeb ng\u00e0y\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 &lt;=, do\u00a0\u0111\u00f3 c\u00e1ch vi\u1ebft l\u00e0 \u201c&lt;=\u201d&amp;F12<\/li>\n<li>V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 3: c\u1ed9t M\u00e3 h\u00e0ng,\u00a0v\u00f9ng A2:A15<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n th\u1ee9 3:\u00a0M\u00e3 h\u00e0ng,\u00a0\u0111\u01b0\u1ee3c x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m Vlookup tham chi\u1ebfu theo T\u00ean h\u00e0ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn\u00a0\u1edf\u00a0\u00f4 F13<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_ham_VLOOKUP\"><\/span>C\u00e1ch vi\u1ebft h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>h\u00fang ta mu\u1ed1n tham chi\u1ebfu M\u00e3 h\u00e0ng d\u1ef1a v\u00e0o T\u00ean h\u00e0ng, do\u00a0\u0111\u00f3 h\u00e0m VLOOKUP s\u1ebd vi\u1ebft nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula-inline\">=VLOOKUP(gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, v\u00f9ng tham chi\u1ebfu, c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3, ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm)<\/code><\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm: l\u00e0 t\u00ean h\u00e0ng t\u1ea1i\u00a0\u00f4 F13<\/li>\n<li>V\u00f9ng tham chi\u1ebfu: V\u00f9ng b\u1ea3ng E2:F8 (c\u00f3 th\u1ec3 b\u1ecf qua d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1)<\/li>\n<li>C\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3: c\u1ed9t M\u00e3 h\u00e0ng l\u00e0 c\u1ed9t th\u1ee9 2<\/li>\n<li>Ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm: t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c theo t\u00ean h\u00e0ng =&gt; nh\u1eadp s\u1ed1 0<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ta c\u00f3 VLOOKUP(F13,E2:F8,2,0)<\/p>\n<p>Khi k\u1ebft h\u1ee3p 2 h\u00e0m n\u00e0y, ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 t\u1ea1i\u00a0\u00f4 F15 nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula-inline\">=SUMIFS(C2:C15,B2:B15,\"&gt;=\"&amp;F11,B2:B15,\"&lt;=\"&amp;F12,A2:A15,VLOOKUP(F13,E2:F8,2,0))<\/code><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23388\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumifs-ket-hop-vlookup-cong-thuc.png\" width=\"1331\" height=\"488\" title=\"sumifs-ket-hop-vlookup-cong-thuc\"><\/p>\n<p>H\u00e3y th\u1eed thay\u00a0\u0111\u1ed5i t\u00ean h\u00e0ng t\u1ea1i\u00a0\u00f4 F13\u00a0\u0111\u1ec3 xem k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m SUMIFS t\u1ea1i\u00a0\u00f4 F15 thay\u00a0\u0111\u1ed5i\u00a0\u0111\u00fang kh\u00f4ng nh\u00e9.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m SUMIFS c\u00f3 th\u1ec3 vi\u1ebft\u00a0\u0111\u01b0\u1ee3c v\u1edbi r\u1ea5t nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n. Khi\u00a0\u0111\u00f3 ch\u00fang ta ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5:\u00a0\u0110i\u1ec1u ki\u1ec7n\u00a0\u0111\u00f3 c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh tr\u1ef1c ti\u1ebfp\u00a0\u0111\u01b0\u1ee3c trong b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng.<\/p>\n<ul>\n<li>N\u1ebfu c\u00f3: Tham chi\u1ebfu tr\u1ef1c ti\u1ebfp\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u00f3 (nh\u01b0 gi\u00e1 tr\u1ecb T\u1eeb ng\u00e0y,\u00a0\u0111\u1ebfn ng\u00e0y\u00a0\u1edf v\u00ed d\u1ee5 tr\u00ean)<\/li>\n<li>N\u1ebfu kh\u00f4ng: Ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c h\u00e0m k\u1ebft h\u1ee3p (nh\u01b0 h\u00e0m VLOOKUP, h\u00e0m DATE, h\u00e0m EOMONTH\u2026)\u00a0\u0111\u1ec3 gi\u00fap t\u1eeb c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u00f3 gi\u00e1n ti\u1ebfp t\u1ea1o ra 1\u00a0\u0111i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh tr\u1ef1c ti\u1ebfp\u00a0\u0111\u01b0\u1ee3c trong v\u00f9ng d\u1eef li\u1ec7u g\u1ed1c.<\/li>\n<\/ul>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng k\u1ef9 thu\u1eadt c\u0103n b\u1ea3n gi\u00fap l\u1eadp b\u00e1o c\u00e1o theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, nhanh ch\u00f3ng.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c nh\u00e9!<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? 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\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\/excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/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-219.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2869,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2868","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\/2868","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=2868"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2868\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2869"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}