{"id":5865,"date":"2024-12-21T08:22:30","date_gmt":"2024-12-21T08:22:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-su-dung-ham-sumifs-ket-hop-ham-vlookup-trong-excel\/"},"modified":"2024-12-21T08:22:30","modified_gmt":"2024-12-21T08:22:30","slug":"huong-dan-cach-su-dung-ham-sumifs-ket-hop-ham-vlookup-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-su-dung-ham-sumifs-ket-hop-ham-vlookup-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumifs k\u1ebft h\u1ee3p h\u00e0m vlookup trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-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> <a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">h\u00e0m VLOOKUP<\/a><\/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-1.png\" width=\"991\" height=\"476\" title=\"sumifs-ket-hop-vlookup-de-bai-1\"><\/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<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-67667ac57b110\" 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-su-dung-ham-sumifs-ket-hop-ham-vlookup-trong-excel.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-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-sumifs-ket-hop-ham-vlookup-trong-excel.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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-sumifs-ket-hop-ham-vlookup-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\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<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-518.gif\" title=\"ex101_92019-nho-518\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>=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>)<\/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>=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)<\/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>=SUMIFS(C2:C15,B2:B15,\u201d&gt;=\u201d&amp;F11,B2:B15,\u201d&lt;=\u201d&amp;F12,A2:A15,VLOOKUP(F13,E2:F8,2,0))<\/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-1.png\" width=\"1331\" height=\"488\" title=\"sumifs-ket-hop-vlookup-cong-thuc-1\"><\/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<p><strong>Xem th\u00eam: Hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1<a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html\"> h\u00e0m Sumifs l\u00e0 g\u00ec?<\/a> C\u00e1ch s\u1eed d\u1ee5ng trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3<\/strong><\/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>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1 n\u00e0y\u00a0\u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-tra-cuu-du-lieu-tu-nhieu-bang-tinh-voi-ham-vlookup-va-switch.html\">C\u00e1ch tra c\u1ee9u d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng t\u00ednh v\u1edbi h\u00e0m Vlookup v\u00e0 Switch<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-vlookup-match.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Match<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-sumifs-tinh-tong-theo-tuan-thang-nam.html\">H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng theo tu\u1ea7n, th\u00e1ng, n\u0103m<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-tong-hop-theo-tung-thang-voi-ham-sumifs.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo t\u1eebng th\u00e1ng v\u1edbi h\u00e0m SUMIFS<\/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-518.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5866,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5865","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\/5865","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=5865"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5865\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5866"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}