{"id":2898,"date":"2024-12-02T09:25:45","date_gmt":"2024-12-02T09:25:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/bi-kip-vo-lam-2-sumproduct-than-chuong\/"},"modified":"2024-12-02T09:25:45","modified_gmt":"2024-12-02T09:25:45","slug":"bi-kip-vo-lam-2-sumproduct-than-chuong","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/bi-kip-vo-lam-2-sumproduct-than-chuong\/","title":{"rendered":"B\u00ed k\u00edp v\u00f5 l\u00e2m 2: SUMPRODUCT th\u1ea7n ch\u01b0\u1edfng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>H\u00f4m nay ch\u00fang ta c\u00f9ng quay tr\u1edf l\u1ea1i v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Exel Online<\/strong><\/a> \u0111\u1ec3 c\u00f9ng b\u00e0n lu\u1eadn v\u1ec1 <strong>h\u00e0m Sumproduct<\/strong>.\u00a0<\/em><\/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-674d7d17e1325\" 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\/bi-kip-vo-lam-sumproduct-than-chuong.html#Cu_phap_ham_SUMPRODUCT\" title=\"C\u00fa ph\u00e1p h\u00e0m SUMPRODUCT\">C\u00fa ph\u00e1p h\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\/bi-kip-vo-lam-sumproduct-than-chuong.html#Vay_dau_nhan_va_dau_phay_trong_SUMPRODUCT_khac_nhau_o_dau_Cach_xu_ly_loi_tra_ve_khi_ap_dung\" title=\"V\u1eady d\u1ea5u nh\u00e2n v\u00e0 d\u1ea5u ph\u1ea9y trong SUMPRODUCT kh\u00e1c nhau \u1edf \u0111\u00e2u? C\u00e1ch x\u1eed l\u00fd l\u1ed7i tr\u1ea3 v\u1ec1 khi \u00e1p d\u1ee5ng.\">V\u1eady d\u1ea5u nh\u00e2n v\u00e0 d\u1ea5u ph\u1ea9y trong SUMPRODUCT kh\u00e1c nhau \u1edf \u0111\u00e2u? C\u00e1ch x\u1eed l\u00fd l\u1ed7i tr\u1ea3 v\u1ec1 khi \u00e1p d\u1ee5ng.<\/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\/bi-kip-vo-lam-sumproduct-than-chuong.html#Cac_ung_dung_thuong_gap_va_cac_ham_thuong_dung_voi_SUMPRODUCT\" title=\"C\u00e1c \u1ee9ng d\u1ee5ng th\u01b0\u1eddng g\u1eb7p, v\u00e0 c\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng v\u1edbi SUMPRODUCT.\">C\u00e1c \u1ee9ng d\u1ee5ng th\u01b0\u1eddng g\u1eb7p, v\u00e0 c\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng v\u1edbi SUMPRODUCT.<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\">\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/bi-kip-vo-lam-sumproduct-than-chuong.html#Cac_ham_kiem_tra_logic_ISNUMBERISERROR_SEARCH\" title=\"C\u00e1c h\u00e0m ki\u1ec3m tra logic: ISNUMBER\/ISERROR + SEARCH\">C\u00e1c h\u00e0m ki\u1ec3m tra logic: ISNUMBER\/ISERROR + SEARCH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/bi-kip-vo-lam-sumproduct-than-chuong.html#Tinh_tong_tat_ca_cac_sheet_voi_SUMIFS\" title=\"T\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c sheet v\u1edbi SUMIFS\">T\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c sheet v\u1edbi SUMIFS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/bi-kip-vo-lam-sumproduct-than-chuong.html#Tinh_so_gio_di_muon_ve_som_gio_lam_cua_nhan_vien_voi_ham_SUMPRODUCT\" title=\"T\u00ednh s\u1ed1 gi\u1edd \u0111i mu\u1ed9n, v\u1ec1 s\u1edbm, gi\u1edd l\u00e0m c\u1ee7a nh\u00e2n vi\u00ean v\u1edbi h\u00e0m SUMPRODUCT.\">T\u00ednh s\u1ed1 gi\u1edd \u0111i mu\u1ed9n, v\u1ec1 s\u1edbm, gi\u1edd l\u00e0m c\u1ee7a nh\u00e2n vi\u00ean v\u1edbi h\u00e0m SUMPRODUCT.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/bi-kip-vo-lam-sumproduct-than-chuong.html#Ung_dung_SUMPRODUCT_trong_viec_cham_cong_tinh_cong_cho_nhan_vien\" title=\"\u1ee8ng d\u1ee5ng SUMPRODUCT trong vi\u1ec7c ch\u1ea5m c\u00f4ng, t\u00ednh c\u00f4ng cho nh\u00e2n vi\u00ean.\">\u1ee8ng d\u1ee5ng SUMPRODUCT trong vi\u1ec7c ch\u1ea5m c\u00f4ng, t\u00ednh c\u00f4ng cho nh\u00e2n vi\u00ean.<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_ham_SUMPRODUCT\"><\/span>C\u00fa ph\u00e1p h\u00e0m SUMPRODUCT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><code class=\"excel-formula\"><strong><span style=\"font-family: 'courier new', courier, monospace\">=SUMPRODUCT(--(Bi\u1ec3u th\u1ee9c),(V\u00f9ng t\u00ednh t\u1ed5ng))<\/span><\/strong><\/code><\/p>\n<p>ho\u1eb7c:<\/p>\n<p><code class=\"excel-formula\"><strong><span style=\"font-family: 'courier new', courier, monospace\">=SUMPRODUCT((Bi\u1ec3u th\u1ee9c)*(V\u00f9ng t\u00ednh t\u1ed5ng))<\/span><\/strong><\/code><\/p>\n<ul>\n<li>Khi <em><strong>ch\u1ec9 c\u00f3 bi\u1ec3u th\u1ee9c<\/strong><\/em>: <code class=\"excel-formula\"><span style=\"font-family: 'courier new', courier, monospace\">=SUMPRODUCT(--(Bi\u1ec3u th\u1ee9c))<\/span><\/code>, l\u00fac n\u00e0y SUMPRODUCT t\u00ednh theo d\u1ea1ng \u0111\u1ebfm t\u01b0\u01a1ng t\u1ef1 COUNTIFS.<\/li>\n<li>Khi <em><strong>c\u00f3 c\u1ea3 bi\u1ec3u th\u1ee9c l\u1eabn v\u00f9ng t\u00ednh t\u1ed5ng<\/strong><\/em>: <code class=\"excel-formula\"><span style=\"font-family: 'courier new', courier, monospace\">=SUMPRODUCT(--(Bi\u1ec3u th\u1ee9c),(V\u00f9ng t\u00ednh t\u1ed5ng))<\/span><\/code>, l\u00fac n\u00e0y SUMPRODUCT s\u1ebd t\u00ednh theo d\u1ea1ng t\u00ednh t\u1ed5ng t\u01b0\u01a1ng t\u1ef1 SUMIFS.<\/li>\n<li>H\u00e0m SUMPRODUCT s\u1ebd t\u00ednh to\u00e1n ch\u1eadm h\u01a1n so v\u1edbi SUMIFS\/COUNTIFS, tuy nhi\u00ean s\u1ebd c\u00f3 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p ta ch\u1ec9 c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n. V\u00ec v\u1eady c\u00e1c b\u1ea1n n\u00ean x\u00e9t tr\u01b0\u1eddng h\u1ee3p ph\u00f9 h\u1ee3p m\u00e0 \u00e1p d\u1ee5ng.<\/li>\n<li>C\u00e1c v\u00f9ng tham chi\u1ebfu, ch\u1ec9 n\u00ean gi\u1edbi h\u1ea1n, kh\u00f4ng n\u00ean d\u00f9ng c\u1ea3 c\u1ed9t (A:A, ph\u1ea3i ghi r\u00f5 t\u1eeb \u0111\u00e2u t\u1edbi \u0111\u00e2u, v\u00ed d\u1ee5 A2:A1000).<\/li>\n<li>C\u0103n b\u1ea3n h\u00e0m SUMPRODUCT l\u00e0 1 h\u00e0m m\u1ea3ng, v\u00ec v\u1eady KH\u00d4NG c\u1ea7n ph\u1ea3i nh\u1ea5n CTRL+SHIFT+ENTER.<\/li>\n<li>L\u01b0u \u00fd: <code class=\"excel-formula\">d\u1ea5u <span style=\"font-family: 'courier new', courier, monospace\">--<\/span><\/code>, l\u00e0 2 d\u1ea5u tr\u1eeb, d\u00f9ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u201cch\u1eef s\u1ed1\u201d th\u00e0nh s\u1ed1. V\u00ed d\u1ee5: =<code><span style=\"font-family: 'courier new', courier, monospace\">--<\/span>\"1\"<\/code> =&gt; 1.<\/li>\n<\/ul>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\">h\u00e0m Sumif<\/a> trong Excel qua c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/strong><\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o video gi\u1ea3i th\u00edch h\u00e0m SUMPRODUCT qua video b\u00e0i gi\u1ea3ng sau:<\/p>\n<iframe loading=\"lazy\" title=\"H\u1ecdc Excel C\u01a1 B\u1ea3n | H\u00e0m SUMPRODUCT | C\u00e1ch vi\u1ebft \u0111\u1ec3 hi\u1ec3u SUMPRODUCT\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/yoiEz7uGz2Y?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\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-221.gif\" title=\"ex101_92019-nho-221\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ta c\u00f3 v\u00ed d\u1ee5 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/sumproduct-cu-phap-tinh-tong-dieu-kien.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24311 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-cu-phap-tinh-tong-dieu-kien.jpg\" width=\"900\" height=\"238\" title=\"sumproduct-cu-phap-tinh-tong-dieu-kien\"><\/a><\/p>\n<p>Ta nh\u1eefng s\u1ea3n ph\u1ea9m kh\u00e1c nhau c\u00f3 trong kho A, B, C. B\u00e2y gi\u1edd l\u00e0m sao t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u00f3 trong Kho A? V\u00e0 c\u00f3 bao nhi\u00eau s\u1ea3n ph\u1ea9m trong kho A? K\u1ebft qu\u1ea3 ta c\u00f3:<\/p>\n<ul>\n<li><strong>D\u1ea5u ph\u1ea9y ph\u00e2n c\u00e1ch<\/strong>: <span style=\"font-family: 'courier new', courier, monospace\"><code class=\"excel-formula\">=SUMPRODUCT($E$2:$E$5,--($A$2:$A$5=G2))<\/code><\/span>\n<ul>\n<li>V\u00f9ng t\u00ednh t\u1ed5ng: $E$2:$E$5.<\/li>\n<li>Bi\u1ec3u th\u1ee9c so s\u00e1nh \u0111i\u1ec1u ki\u1ec7n: $A$2:$A$5=G2.<\/li>\n<li>Khi ch\u1ec9 c\u00f3 1 bi\u1ec3u th\u1ee9c, b\u1ea1n n\u00ean d\u00f9ng d\u1ea5u <code><span style=\"font-family: 'courier new', courier, monospace\">--()<\/span><\/code> \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u t\u1eeb TRUE\/FALSE sang d\u1ea1ng s\u1ed1. C\u00f3 l\u00fac b\u1ea1n s\u1ebd th\u1ea5y c\u00f3 l\u00fac *1, ho\u1eb7c +0, th\u1ef1c ra \u0111\u00f3 c\u0169ng l\u00e0 c\u00e1ch chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u TRUE\/FALSE sang s\u1ed1. Nh\u01b0ng c\u00e1ch t\u1ed1t nh\u1ea5t n\u00ean d\u00f9ng l\u00e0 <span style=\"font-family: 'courier new', courier, monospace\"><code class=\"excel-formula\">--()<\/code><\/span>, s\u1ebd gi\u00fap Excel \u0111\u1ee1 t\u00ednh to\u00e1n h\u01a1n.<\/li>\n<li>B\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1i n\u00e0o tr\u01b0\u1edbc, c\u00e1i n\u00e0o sau kh\u00f4ng quan tr\u1ecdng, nh\u01b0ng m\u00ecnh khuy\u1ebfn kh\u00edch c\u00e1c b\u1ea1n n\u00ean \u0111\u1ed3ng nh\u1ea5t theo ki\u1ec3u <strong>SUMIFS(V\u00f9ng t\u00ednh t\u1ed5ng, V\u00f9ng \u0111i\u1ec1u ki\u1ec7n, \u0110i\u1ec1u ki\u1ec7n)<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<li><strong>D\u1ea5u nh\u00e2n (*) k\u1ebft h\u1ee3p<\/strong>:\u00a0<span style=\"font-family: 'courier new', courier, monospace\"><code class=\"excel-formula\">=SUMPRODUCT(($E$2:$E$5)*($A$2:$A$5=G2))<\/code><\/span>\n<ul>\n<li>Thay v\u00ec d\u00f9ng d\u1ea5u ph\u1ea9y, ta c\u00f3 th\u1ec3 d\u00f9ng c\u00e1c v\u00f9ng nh\u00e2n v\u1edbi nhau.<\/li>\n<li>L\u00fac n\u00e0y khi c\u00f3 ph\u00e9p t\u00ednh nh\u00e2n gi\u1eefa c\u00e1c v\u00f9ng \u0111i\u1ec1u ki\u1ec7n v\u00e0 v\u00f9ng t\u00ednh t\u1ed5ng, n\u00ean b\u1ea1n c\u0169ng kh\u00f4ng c\u1ea7n chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u TRUE\/FALSE, v\u00ec khi c\u00f3 ph\u00e9p to\u00e1n t\u1eed th\u00ec Excel s\u1ebd chuy\u1ec3n d\u1eef li\u1ec7u sang s\u1ed1 r\u1ed3i m\u1edbi t\u00ednh.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Vay_dau_nhan_va_dau_phay_trong_SUMPRODUCT_khac_nhau_o_dau_Cach_xu_ly_loi_tra_ve_khi_ap_dung\"><\/span><strong>V\u1eady d\u1ea5u nh\u00e2n v\u00e0 d\u1ea5u ph\u1ea9y trong SUMPRODUCT kh\u00e1c nhau \u1edf \u0111\u00e2u? C\u00e1ch x\u1eed l\u00fd l\u1ed7i tr\u1ea3 v\u1ec1 khi \u00e1p d\u1ee5ng.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/sumproduct-khac-nhau-giua-dau-phay.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24312 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-khac-nhau-giua-dau-phay.jpg\" width=\"900\" height=\"257\" title=\"sumproduct-khac-nhau-giua-dau-phay\"><\/a><\/p>\n<p>Khi d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n b\u1ecb l\u1eabn \u201cch\u1eef\u201d k\u00fd t\u1ef1 \u1edf \u00f4 E6, l\u00fac n\u00e0y SUMPRODUCT ph\u00e9p nh\u00e2n s\u1ebd tr\u1ea3 v\u1ec1 #VALUE. B\u1edfi v\u00ec \u201cCh\u1eef\u201d nh\u00e2n v\u1edbi\u00a0m\u1ed9t\u00a0s\u1ed1 s\u1ebd tr\u1ea3 v\u1ec1 #VALUE. L\u00fac n\u00e0y ta d\u00f9ng d\u1ea5u ph\u1ea9y, s\u1ebd b\u1ecf qua ch\u1eef t\u01b0\u01a1ng t\u1ef1 h\u00e0m SUM, s\u1ebd t\u00ednh t\u1ed5ng v\u00f9ng b\u1ecf qua ch\u1eef v\u00e0 n\u1ebfu c\u00f3 gi\u00e1 tr\u1ecb l\u1ed7i trong v\u00f9ng t\u00ednh t\u1ed5ng, s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i.<\/p>\n<p>V\u1eady t\u00f9y t\u00ecnh hu\u1ed1ng, c\u00e1c b\u1ea1n c\u1ea7n \u00e1p d\u1ee5ng cho ph\u00f9 h\u1ee3p, c\u0169ng c\u00f3 h\u01b0\u1edbng d\u1eabn n\u00ean d\u00f9ng h\u00e0m SUMIFS ho\u1eb7c COUNTIFS \u0111\u1ec3 c\u00f3 th\u1ec3 b\u1ecf qua l\u1ed7i #NA, #VALUE trong d\u1eef li\u1ec7u. Tuy nhi\u00ean, m\u00ecnh c\u0169ng khuy\u1ebfn kh\u00edch n\u00ean d\u00f9ng SUMPRODUCT \u0111\u1ec3 khi nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o l\u1ed7i! V\u00ec sao? V\u00ec n\u1ebfu b\u1ecf qua l\u1ed7i, ch\u00fang ta s\u1ebd b\u1ecb sai l\u1ec7ch s\u1ed1 li\u1ec7u m\u00e0 kh\u00f4ng hay bi\u1ebft\u00a0c\u00f3 l\u1ed7i ph\u00e1t sinh trong d\u1eef li\u1ec7u.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/sumproduct-loi-tra-ve.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24313\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-loi-tra-ve.jpg\" width=\"900\" height=\"157\" title=\"sumproduct-loi-tra-ve\"><\/a><\/p>\n<p>Ngo\u00e0i ra, t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m COUNTIFS, SUMIFS n\u1ebfu c\u00e1c \u0111\u1ed9 d\u00e0i c\u1ee7a c\u00e1c v\u00f9ng kh\u00f4ng kh\u1edbp nhau. V\u00ed d\u1ee5: <code>SUMPRODUCT($E$1:$E$6,--($A$2:$A$6))<\/code>, s\u1ebd tr\u1ea3 v\u1ec1 #VALUE. V\u00ec v\u00f9ng E1:E6 l\u00e0 sai, ph\u1ea3i kh\u1edbp nhau E2:E6 so v\u1edbi A2:A6. V\u1eady t\u1ea1i sao kh\u00f4ng s\u1eeda l\u1ea1i A1:A6 cho kh\u1edbp, b\u1ea1n n\u00ean b\u1ecf qua v\u00f9ng ti\u00eau \u0111\u1ec1 v\u00ec \u0111\u00f3 l\u00e0 ch\u1eef, n\u1ebfu d\u00f9ng ph\u00e9p nh\u00e2n * s\u1ebd l\u1ed7i.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/sumproduct-2-vung-tinh-tong-tich.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24315 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-2-vung-tinh-tong-tich.jpg\" width=\"680\" height=\"409\" title=\"sumproduct-2-vung-tinh-tong-tich\"><\/a><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ta c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng t\u00edch nh\u00e2n nhau gi\u1eefa S\u1ed1 l\u01b0\u1ee3ng v\u00e0 \u0110\u01a1n gi\u00e1 theo \u0111i\u1ec1u ki\u1ec7n s\u1ea3n ph\u1ea9m trong kho A. \u1ede \u0111\u00e2y b\u1ea1n l\u01b0u \u00fd, v\u1edbi d\u1ea5u ph\u1ea9y m\u00ecnh c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u v\u00f9ng bao g\u1ed3m ch\u1eef. Nh\u01b0ng v\u1edbi ph\u00e9p nh\u00e2n, th\u00ec m\u00ecnh \u0111\u00e3 b\u1ecf qua d\u00f2ng ti\u00eau \u0111\u1ec1, b\u1eaft \u0111\u1ea7u t\u1eeb d\u00f2ng th\u1ee9 2. L\u00fac n\u00e0y ph\u00e9p t\u00ednh x\u1ea3y ra nh\u01b0 sau: (1*2000)+(1000*2) = 4000, cho s\u1ea3n ph\u1ea9m c\u00f3 trong kho A.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/sumproduct-dieu-kien-nang-cao.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24317 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-dieu-kien-nang-cao.jpg\" width=\"827\" height=\"324\" title=\"sumproduct-dieu-kien-nang-cao\"><\/a><\/p>\n<p>Ngo\u00e0i ra, ph\u1ee9c t\u1ea1p h\u01a1n b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n tr\u01b0\u1edbc \u0111\u1ec3 gh\u00e9p n\u1ed1i t\u00ecm ra t\u1eeb b\u1ea3ng kh\u00e1c t\u01b0\u01a1ng \u1ee9ng. B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng c\u1ee5 Evaluate Formula \u0111\u1ec3 ki\u1ec3m tra c\u00f4ng th\u1ee9c m\u00ecnh b\u1ecb l\u1ed7i ch\u1ed7 n\u00e0o, khi m\u1eafc l\u1ed7i, c\u0169ng nh\u01b0 xem x\u00e9t c\u00e1c \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/sumproduct-evaluate-dieu-kien-nang-cao.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24319 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-evaluate-dieu-kien-nang-cao.jpg\" width=\"779\" height=\"563\" title=\"sumproduct-evaluate-dieu-kien-nang-cao\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_ung_dung_thuong_gap_va_cac_ham_thuong_dung_voi_SUMPRODUCT\"><\/span>C\u00e1c \u1ee9ng d\u1ee5ng th\u01b0\u1eddng g\u1eb7p, v\u00e0 c\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng v\u1edbi SUMPRODUCT.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"Cac_ham_kiem_tra_logic_ISNUMBERISERROR_SEARCH\"><\/span>C\u00e1c h\u00e0m ki\u1ec3m tra logic: ISNUMBER\/ISERROR + SEARCH<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ul>\n<li>H\u00e0m SEARCH gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm \u0111i\u1ec1u ki\u1ec7n c\u00f3 trong v\u00f9ng t\u00ecm ki\u1ebfm hay kh\u00f4ng? N\u1ebfu t\u00ecm th\u1ea5y s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 c\u1ee7a v\u1ecb tr\u00ed t\u00ecm th\u1ea5y, c\u00f2n kh\u00f4ng t\u00ecm th\u1ea5y h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 #VALUE. L\u00fac n\u00e0y \u0111\u1ec3 tr\u00e1nh l\u1ed7i, ta d\u00f9ng h\u00e0m ISNUMBER \u0111\u1ec3 b\u1ecf qua l\u1ed7i, ch\u1ec9 t\u00ednh c\u00e1i t\u00ecm th\u1ea5y.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/sumproduct-isnumber-search.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24321\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-isnumber-search-1.jpg\" width=\"680\" height=\"322\" title=\"sumproduct-isnumber-search-1\"><\/a><br \/>\nV\u00ed d\u1ee5, ta t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m ch\u1ee9a ch\u1eef \u201c<strong>\u00e1<\/strong>\u201c, trong v\u00ed d\u1ee5 b\u1ea1n l\u01b0u \u00fd kh\u00e1c bi\u1ec7t gi\u1eefa d\u1ea5u * v\u1edbi d\u1ea5u ph\u1ea9y (,).<\/li>\n<li>H\u00e0m SEARCH gi\u00fap ch\u00fang ta t\u00ecm ki\u1ebfm kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef Hoa\/th\u01b0\u1eddng. N\u1ebfu b\u1ea1n c\u1ea7n t\u00ecm ch\u1eef gi\u1ed1ng nhau th\u00ec l\u00fac n\u00e0y c\u00f3 h\u00e0m FIND.<\/li>\n<\/ul>\n<\/li>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"Tinh_tong_tat_ca_cac_sheet_voi_SUMIFS\"><\/span><strong>T\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c sheet v\u1edbi SUMIFS<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ul>\n<li>Khi b\u1ea1n c\u00f3 c\u00e1c sheet kh\u00e1c nhau \u0111\u1ed3ng nh\u1ea5t v\u1ec1 c\u1ea5u tr\u00fac, v\u00ed d\u1ee5 b\u1ea3ng ch\u1ea5m c\u00f4ng t\u1eebng th\u00e1ng trong n\u0103m. B\u1ea1n l\u00e0m b\u00e1o c\u00e1o t\u1ed5ng k\u1ebft cu\u1ed1i n\u0103m, l\u00fac n\u00e0y h\u00e0m SUMPRODUCT+SUMIFS+INDIRECT s\u1ebd gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c n\u00e0y.<br \/>\nHo\u1eb7c b\u1ea1n c\u00f3 danh s\u00e1ch s\u1ea3n ph\u1ea9m t\u1eebng th\u00e1ng, b\u1ea1n c\u1ea7n t\u00ednh s\u1ed1 l\u01b0\u1ee3ng t\u01b0\u01a1ng \u1ee9ng. L\u00fac n\u00e0y b\u1ea1n ch\u1ec9 c\u1ea7n li\u1ec7t k\u00ea danh s\u00e1ch t\u00ean c\u00e1c sheet, v\u00e0 v\u00f9ng d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng. V\u1eady l\u00e0 ta c\u00f3 \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-tinh-tong-qua-cac-sheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24329\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-tinh-tong-qua-cac-sheet-1.jpg\" width=\"925\" height=\"411\" title=\"sumproduct-tinh-tong-qua-cac-sheet-1\"><\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>T\u00e1ch chu\u1ed7i ra \u0111\u1ec3 l\u1ea5y s\u1ed1 li\u1ec7u t\u00ednh to\u00e1n:<\/strong>\n<ul>\n<li>B\u00e0i to\u00e1n \u0111\u1eb7t ra b\u1ea1n c\u00f3 chu\u1ed7i k\u00fd t\u1ef1: u, x, 3g, nhu\u1ed9m. V\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00e1ch ra theo c\u00e1c \u0111\u01a1n v\u1ecb t\u00ednh t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<li>V\u1eadn d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m TEXT \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c s\u1ed1, ch\u1eef, v\u00e0 s\u1ed1 0 th\u00e0nh con s\u1ed1 t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-text-substitute-tach-chuoi-tinh-toan.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-31285\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-text-substitute-tach-chuoi-tinh-toan-1.png\" width=\"1215\" height=\"230\" title=\"sumproduct-text-substitute-tach-chuoi-tinh-toan-1\"><\/a><\/p>\n<ul>\n<li><strong>Chuy\u1ec3n chu\u1ed7i k\u00fd t\u1ef1 bi\u1ec3u th\u1ee9c c\u1ed9ng tr\u1eeb th\u00e0nh k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n:<\/strong>\n<ul>\n<li>B\u01b0\u1edbc 1: Ch\u00fang ta s\u1ebd t\u00ecm thay th\u1ebf k\u00fd t\u1ef1 \u201c-\u201d th\u00e0nh \u201c+-\u201c.<\/li>\n<li>B\u01b0\u1edbc 2: Ch\u00fang ta s\u1ebd t\u00ecm thay th\u1ebf k\u00fd t\u1ef1 \u201c+\u201d v\u1edbi h\u00e0m REPT(\u201d \u201c,99) nh\u1eb1m ch\u00e8n thay th\u1ebf 99 k\u00fd t\u1ef1 \u201d \u201c.<\/li>\n<li>B\u01b0\u1edbc 3: H\u00e0m MID s\u1ebd t\u00e1ch c\u00e1c ph\u1ea7n ra gi\u1eefa 99 k\u00fd t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam qua b\u00e0i vi\u1ebft<strong> <a href=\"http:\/\/blog.ezworkapp.com\/substitute-va-40-ten-cuop.html\" target=\"_blank\" rel=\"noopener noreferrer\">SUBSTITUTE v\u00e0 40 t\u00ean c\u01b0\u1edbp<\/a><\/strong>.<\/li>\n<li>B\u01b0\u1edbc 4: Kh\u00e1c v\u1edbi h\u00e0m TRIM, ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m TEXT nh\u1eadn d\u1ea1ng k\u00fd t\u1ef1.<\/li>\n<li>B\u01b0\u1edbc 5: V\u1edbi h\u00e0m SUMPRODUCT k\u1ebft h\u1ee3p d\u1ea5u <code>-- (d\u00f9ng \u0111\u1ec3 chuy\u1ec3n ch\u1eef th\u00e0nh s\u1ed1)<\/code>, sau \u0111\u00f3 c\u1ed9ng d\u1ed3n l\u1ea1i v\u1edbi nhau.<\/li>\n<li>K\u1ebft qu\u1ea3:<code class=\"excel-formula\">=SUMPRODUCT(--TEXT(MID(SUBSTITUTE(SUBSTITUTE(A2,\"-\",\"+-\"),\"+\",REPT(\" \",99)),ROW(INDIRECT(\"1:\"&amp;LEN(A2)))*99-98,99),\"0.00;-0.00;0;\"))<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-28456 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-cong-tru-chuoi-bieu-thuc-1.png\" width=\"724\" height=\"288\" title=\"sumproduct-cong-tru-chuoi-bieu-thuc-1\"><\/p>\n<ul>\n<li><strong>\u0110\u1ebfm duy nh\u1ea5t v\u1edbi SUMPRODUCT:<\/strong><\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-dem-so-duy-nhat-tinh-tong.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-28030 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-dem-so-duy-nhat-tinh-tong-1.png\" width=\"858\" height=\"412\" title=\"sumproduct-dem-so-duy-nhat-tinh-tong-1\"><\/a><\/p>\n<ul>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"Tinh_so_gio_di_muon_ve_som_gio_lam_cua_nhan_vien_voi_ham_SUMPRODUCT\"><\/span>T\u00ednh s\u1ed1 gi\u1edd \u0111i mu\u1ed9n, v\u1ec1 s\u1edbm, gi\u1edd l\u00e0m c\u1ee7a nh\u00e2n vi\u00ean v\u1edbi h\u00e0m SUMPRODUCT.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ul>\n<li>Ta quy \u01b0\u1edbc gi\u1edd \u0111i mu\u1ed9n v\u00e0o \u00f4 BM1, l\u00e0 8:00, n\u1ebfu \u0111i sau gi\u1edd \u0111\u00f3 t\u00ednh l\u00e0 mu\u1ed9n.<\/li>\n<li>SUMPRODUCT l\u00fac n\u00e0y l\u1ea5y gi\u1edd checkin, tr\u1eeb cho gi\u1edd quy \u0111\u1ecbnh.<\/li>\n<li>\u0110\u1ec3 quy ra s\u1ed1 ph\u00fat, ta c\u1ea7n nh\u00e2n cho 24 gi\u1edd x 60 ph\u00fat. V\u00ec th\u1eddi gian trong Excel l\u00e0 m\u1ed9t con s\u1ed1 th\u1eadp ph\u00e2n t\u1eeb 0 -&gt; 1.<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-chamcong.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25386\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-chamcong-1.jpg\" width=\"1326\" height=\"337\" title=\"sumproduct-chamcong-1\"><\/a><\/li>\n<\/ul>\n<\/li>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"Ung_dung_SUMPRODUCT_trong_viec_cham_cong_tinh_cong_cho_nhan_vien\"><\/span>\u1ee8ng d\u1ee5ng SUMPRODUCT trong vi\u1ec7c ch\u1ea5m c\u00f4ng, t\u00ednh c\u00f4ng cho nh\u00e2n vi\u00ean.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ul>\n<li>B\u1ea1n c\u00f3 th\u1ec3 l\u1eadp b\u1ea3ng k\u00fd hi\u1ec7u, v\u00e0 quy \u0111\u1ed5i k\u00fd hi\u1ec7u \u0111\u00f3 sang ng\u00e0y c\u00f4ng t\u01b0\u01a1ng \u1ee9ng. R\u1ed3i t\u1eeb \u0111\u00f3 b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u00ednh ng\u00e0y c\u00f4ng.<\/li>\n<li>V\u00ed d\u1ee5 nh\u01b0 sau, ta th\u1ea5y c\u00f3 4x = 4 ng\u00e0y c\u00f4ng, 1np = 1 ng\u00e0y c\u00f4ng, x2 = 2 ng\u00e0y c\u00f4ng. K\u1ebft qu\u1ea3 7 l\u00e0 ch\u00ednh x\u00e1c.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-cham-cong.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24333\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-cham-cong-1.jpg\" width=\"789\" height=\"256\" title=\"sumproduct-cham-cong-1\"><\/a><\/li>\n<li>\u1ee8ng d\u1ee5ng ch\u1ea5m c\u00f4ng theo gi\u1edd, t\u00ednh t\u0103ng ca ngo\u00e0i gi\u1edd v\u00e0 Ch\u1ee7 nh\u1eadt.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/ung-dung-sumproduct-cham-cong-thoi-gian.png\"><br \/>\n<\/a><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/ung-dung-sumproduct-cham-cong-thoi-gian-lam-viec.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-29920 alignnone\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ung-dung-sumproduct-cham-cong-thoi-gian-lam-viec-1024x385-2.png\" width=\"1024\" height=\"385\" title=\"ung-dung-sumproduct-cham-cong-thoi-gian-lam-viec-1024x385-2\"><\/a><\/li>\n<li>\u1ee8ng d\u1ee5ng SUMPRODUCT k\u1ebft h\u1ee3p SUBTOTAL \u0111\u1ec3 t\u00ednh to\u00e1n b\u1ecf qua c\u00e1c d\u00f2ng \u1ea9n, c\u1ed9t \u1ea9n:<br \/>\nB\u00e0i to\u00e1n \u0111\u1eb7t ra: S\u1ebd t\u00ednh t\u1ed5ng s\u1ed1\u00a0nh\u00e2n c\u00f4ng theo t\u1eebng ng\u00e0y, v\u00e0 h\u1ecd c\u00f3 th\u1ec3 ngh\u1ec9 l\u1ec5 nh\u01b0ng v\u1eabn \u0111i l\u00e0m n\u00ean c\u1ea7n t\u00ednh c\u00f4ng t\u1eebng ng\u00e0y.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/sumproduct-ket-hop-SUBTOTAL-de-tinh-bo-qua-dong-an-cot-an.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-30672 alignnone\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-ket-hop-subtotal-de-tinh-bo-qua-dong-an-cot-an-1024x561-2.png\" width=\"1024\" height=\"561\" title=\"sumproduct-ket-hop-subtotal-de-tinh-bo-qua-dong-an-cot-an-1024x561-2\"><\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\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-221.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2899,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2898","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\/2898","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=2898"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2898\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2899"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}