{"id":6674,"date":"2024-12-21T15:53:31","date_gmt":"2024-12-21T15:53:31","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien\/"},"modified":"2024-12-21T15:53:31","modified_gmt":"2024-12-21T15:53:31","slug":"huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Nh\u1eafc t\u1edbi \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n ch\u00fang ta th\u01b0\u1eddng ngh\u0129 t\u1edbi h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/ham-countifs-dem-theo-nhieu-dieu-kien.html\">COUNTIFS<\/a>. Nh\u01b0ng b\u1ea1n c\u00f3 bi\u1ebft r\u1eb1ng SUMPRODUCT c\u0169ng l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y? H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u c\u00e1ch\u00a0d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">h\u00e0m SUMPRODUCT<\/a> \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n nh\u00e9:<\/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-6766e47a5f1bc\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien.html#Nguyen_tac_dem_cua_ham_SUMPRODUCT\" title=\"Nguy\u00ean t\u1eafc \u0111\u1ebfm c\u1ee7a\u00a0h\u00e0m SUMPRODUCT\">Nguy\u00ean t\u1eafc \u0111\u1ebfm c\u1ee7a\u00a0h\u00e0m SUMPRODUCT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien.html#Ung_dung_ham_SUMPRODUCT_dem_theo_nhieu_dieu_kien\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Nguyen_tac_dem_cua_ham_SUMPRODUCT\"><\/span>Nguy\u00ean t\u1eafc \u0111\u1ebfm c\u1ee7a\u00a0h\u00e0m SUMPRODUCT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m SUMPRODUCT l\u00e0 m\u1ed9t h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng m\u1ea3ng. C\u1ea5u tr\u00fac c\u1ee7a SUMPRODUCT \u0111\u01a1n gi\u1ea3n ch\u1ec9 l\u00e0 c\u00e1c m\u1ea3ng:<\/p>\n<p style=\"padding-left: 30px\">=SUMPRODUCT(array1, [array2], [array3], \u2026)<\/p>\n<p>N\u1ebfu ch\u1ec9 nh\u00ecn v\u00e0o c\u1ea5u tr\u00fac tr\u00ean th\u00ec b\u1ea1n c\u00f3 h\u00ecnh dung \u0111\u01b0\u1ee3c h\u00e0m SUMPRODUCT c\u00f3 s\u1ee9c m\u1ea1nh th\u1ebf n\u00e0o kh\u00f4ng? S\u1ee9c m\u1ea1nh n\u1eb1m \u1edf ch\u1eef \u201c\u201dM\u1ea3ng-Array\u201d, b\u1edfi v\u00ec:<\/p>\n<ul>\n<li>Ph\u1ea1m vi c\u1ee7a m\u1ea3ng r\u1ea5t linh ho\u1ea1t, c\u00f3 th\u1ec3 g\u1ed3m nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i l\u1ea1i ho\u1eb7c m\u1ed9t ph\u1ea7n trong m\u1ed7i ph\u1ea7n t\u1eed c\u1ee7a 1 v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n<li>Vi\u1ec7c t\u00ednh to\u00e1n theo m\u1ea3ng g\u1ea7n nh\u01b0 kh\u00f4ng g\u1eb7p gi\u1edbi h\u1ea1n g\u00ec<\/li>\n<\/ul>\n<p>V\u1eady h\u00e0m SUMPRODUCT th\u1ef1c hi\u1ec7n vi\u1ec7c \u0111\u1ebfm d\u1ef1a tr\u00ean nguy\u00ean t\u1eafc n\u00e0o?<\/p>\n<p>B\u1ea3n ch\u1ea5t c\u1ee7a vi\u1ec7c \u0111\u1ebfm l\u00e0 m\u1ed7i ph\u1ea7n t\u1eed trong 1 v\u00f9ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n th\u00ec \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 1. K\u1ebft qu\u1ea3 c\u1ea7n \u0111\u1ebfm l\u00e0 t\u1ed5ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3. Nh\u01b0 v\u1eady trong vi\u1ec7c \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n\u00a0c\u00f3 th\u1ec3 hi\u1ec3u g\u1ea7n gi\u1ed1ng\u00a0t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n, ch\u1ec9 kh\u00e1c l\u00e0 m\u1ed7i gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n n\u00e0y kh\u00f4ng ph\u1ee5 thu\u1ed9c 1 gi\u00e1 tr\u1ecb n\u00e0o m\u00e0 ch\u1ec9 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 1.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ung_dung_ham_SUMPRODUCT_dem_theo_nhieu_dieu_kien\"><\/span>\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u0111\u1ec3 gi\u00fap ch\u00fang ta l\u00e0m quen v\u1edbi vi\u1ec7c d\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 \u0111\u1ebfm:<\/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-598.gif\" title=\"ex101_92019-nho-598\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19701\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-nhieu-dieu-kien-sumproduct-01.png\" width=\"1219\" height=\"473\" title=\"dem-nhieu-dieu-kien-sumproduct-01\"><\/p>\n<p><strong>Y\u00eau c\u1ea7u th\u1ee9 1: D\u1ef1a v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u A1:D18 \u0111\u1ebfm s\u1ed1 m\u1eb7t h\u00e0ng Cam b\u00e1n trong th\u00e1ng 6<\/strong><\/p>\n<p>Trong y\u00eau c\u1ea7u n\u00e0y c\u00f3 2 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ebfm:<\/p>\n<ul>\n<li>M\u1eb7t\u00a0h\u00e0ng l\u00e0 Cam. X\u00e9t trong c\u1ed9t T\u00ean h\u00e0ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u201cCam\u201d<\/li>\n<li>Th\u00e1ng 6. X\u00e9t trong c\u1ed9t Ng\u00e0y, m\u1ed7i ph\u1ea7n t\u1eed (\u00f4) trong c\u1ed9t ng\u00e0y ch\u1ec9 x\u00e9t gi\u00e1 tr\u1ecb th\u00e1ng b\u1eb1ng 6<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady m\u1ed7i gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n c\u1ea3 2 \u0111i\u1ec1u ki\u1ec7n n\u00e0y th\u00ec \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 1. K\u1ebft qu\u1ea3 l\u00e0 t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n c\u1ea3 2 \u0111i\u1ec1u ki\u1ec7n n\u00e0y.<\/p>\n<p><strong>X\u00e9t \u0111i\u1ec1u ki\u1ec7n th\u1ee9 1:<\/strong><\/p>\n<p>\u00a0<\/p>\n<p>Theo c\u00e1ch vi\u1ebft th\u00f4ng th\u01b0\u1eddng th\u00ec ch\u00fang ta vi\u1ebft<\/p>\n<p style=\"padding-left: 30px\">C2=\u201dCam\u201d<\/p>\n<p style=\"padding-left: 30px\">C3=\u201dCam\u201d<\/p>\n<p style=\"padding-left: 30px\">\u2026<\/p>\n<p style=\"padding-left: 30px\">C18=\u201dCam\u201d<\/p>\n<p>Khi vi\u1ebft d\u01b0\u1edbi \u0111\u1ea1ng m\u1ea3ng th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft g\u1ecdn l\u00e0 C2:C18=\u201dCam\u201d.\u00a0Khi vi\u1ebft\u00a0nh\u01b0 tr\u00ean th\u00ec ch\u00fang ta hi\u1ec3u l\u00e0 x\u00e9t m\u1ed7i gi\u00e1 tr\u1ecb trong v\u00f9ng C2:C18, \u00f4 n\u00e0o c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 Cam.<\/p>\n<p><strong>X\u00e9t \u0111i\u1ec1u ki\u1ec7n th\u1ee9 2:<\/strong><\/p>\n<p>\u0110\u1ec3 x\u00e9t th\u00e1ng c\u1ee7a m\u1ed9t Ng\u00e0y th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel.html\">MONTH<\/a>. \u0110\u1ec3 x\u00e9t m\u1ed7i gi\u00e1 tr\u1ecb trong c\u1ed9t Ng\u00e0y c\u00f3 th\u00e1ng b\u1eb1ng 6 th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">MONTH(A2:A18)=6<\/p>\n<p>H\u00e0m\u00a0MONTH th\u00f4ng th\u01b0\u1eddng ch\u1ec9 x\u00e9t \u0111\u01b0\u1ee3c tr\u00ean 1 gi\u00e1 tr\u1ecb. Do \u0111\u00f3 n\u1ebfu vi\u1ebft th\u00f4ng th\u01b0\u1eddng th\u00ec ch\u1ec9 vi\u1ebft d\u1ea1ng:<\/p>\n<p style=\"padding-left: 30px\">Month(A2)=6<\/p>\n<p style=\"padding-left: 30px\">Month(A3)=6<\/p>\n<p style=\"padding-left: 30px\">\u2026<\/p>\n<p style=\"padding-left: 30px\">Month(A18)=6<\/p>\n<p>Khi vi\u1ebft d\u01b0\u1edbi d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng th\u00ec c\u00f3 th\u1ec3 vi\u1ebft Month(A2:A18)=6<\/p>\n<p>Do h\u00e0m Sumproduct l\u00e0 h\u00e0m d\u1ea1ng m\u1ea3ng n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp c\u00e1ch vi\u1ebft r\u00fat g\u1ecdn n\u00e0y.<\/p>\n<p>Hai \u0111i\u1ec1u ki\u1ec7n tr\u00ean l\u00e0 \u0111\u1ed3ng th\u1eddi, n\u00ean trong h\u00e0m SUMPRODUCT c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=SUMPRODUCT((C2:C18=\u201dCam\u201d)*(MONTH(A2:A18)=6)*1)<\/p>\n<p>M\u1ed7i \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c vi\u1ebft trong d\u1ea5u ngo\u1eb7c \u0111\u01a1n, li\u00ean k\u1ebft v\u1edbi nhau b\u1edfi d\u1ea5u *.<\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c \u0111i\u1ec1u ki\u1ec7n s\u1ebd tr\u1ea3 v\u1ec1 TRUE ho\u1eb7c FALSE ch\u1ee9 kh\u00f4ng ph\u1ea3i b\u1eb1ng 1. Do \u0111\u00f3 ph\u1ea3i nh\u00e2n th\u00eam gi\u00e1 tr\u1ecb 1 \u0111\u1ec3 quy k\u1ebft qu\u1ea3 v\u1ec1 d\u1ea1ng s\u1ed1 \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng \u0111\u01b0\u1ee3c.<\/p>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19702\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-nhieu-dieu-kien-sumproduct-ket-qua-yeu-cau-01.png\" width=\"745\" height=\"142\" title=\"dem-nhieu-dieu-kien-sumproduct-ket-qua-yeu-cau-01\"><\/p>\n<p>(C\u00e1c v\u00f9ng tham chi\u1ebfu A2:A18, C2:C18 c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh l\u1ea1i b\u1eb1ng ph\u00edm F4)<\/p>\n<p><strong>Y\u00eau c\u1ea7u 2:\u00a0\u0110\u1ebfm s\u1ed1 l\u1ea7n b\u00e1n c\u1ee7a ca 1 trong th\u00e1ng 6 v\u1edbi m\u1eb7t h\u00e0ng T\u00e1o<\/strong><\/p>\n<p>Trong y\u00eau c\u1ea7u n\u00e0y c\u00f3 t\u1edbi 3 \u0111i\u1ec1u ki\u1ec7n: Ca1, Th\u00e1ng 6 v\u00e0 M\u1eb7t h\u00e0ng \u201cT\u00e1o\u201d<\/p>\n<p>Khi t\u0103ng th\u00eam \u0111i\u1ec1u ki\u1ec7n th\u00ec ch\u00fang ta ch\u1ec9 c\u1ea7n t\u0103ng th\u00eam c\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m SUMPRODUCT nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=SUMPRODUCT(($B$2:$B$18=1)*(MONTH($A$2:$A$18)=6)*($C$2:$C$18=\u201dT\u00e1o\u201d)*1)<\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19703\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-nhieu-dieu-kien-sumproduct-ket-qua-yeu-cau-02.png\" width=\"746\" height=\"282\" title=\"dem-nhieu-dieu-kien-sumproduct-ket-qua-yeu-cau-02\"><\/p>\n<p>Nh\u01b0 v\u1eady vi\u1ec7c th\u00eam \u0111i\u1ec1u ki\u1ec7n th\u1ef1c ra ch\u1ec9 l\u00e0m h\u00e0m SUMPRODUCT d\u00e0i h\u01a1n, c\u00f2n \u00fd ngh\u0129a v\u00e0 \u0111\u1ed9 kh\u00f3 kh\u00f4ng h\u1ec1 t\u0103ng l\u00ean. Khi \u0111\u00e3 hi\u1ec3u r\u00f5 ph\u01b0\u01a1ng ph\u00e1p v\u00e0 c\u00e1ch v\u1eadn d\u1ee5ng h\u00e0m SUMPRODUCT v\u00e0o vi\u1ec7c \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n th\u00ec ch\u00fang ta s\u1ebd th\u1ea5y t\u00ednh \u1ee9ng d\u1ee5ng c\u1ee7a vi\u1ec7c n\u00e0y r\u1ea5t cao trong th\u1ef1c t\u1ebf.<\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/4-phuong-phap-dem-nhieu-dieu-kien-dang-hoac-ham-sumproduct.html\">4 ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n d\u1ea1ng ho\u1eb7c \u2013 H\u00e0m SUMPRODUCT<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2KouKtM\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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-598.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6675,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6674","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6674","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=6674"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6674\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6675"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}