{"id":10717,"date":"2022-11-03T16:29:09","date_gmt":"2022-11-03T09:29:09","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=10717"},"modified":"2022-12-06T14:15:22","modified_gmt":"2022-12-06T07:15:22","slug":"ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/","title":{"rendered":"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;10717&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><b><i>H\u00e0m Sumproduct l\u00e0 g\u00ec<\/i><\/b><i><span style=\"font-weight: 400;\">? C\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong Excel? Xem Ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin chi ti\u1ebft.<\/span><\/i><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi d\u00e2n k\u1ebf to\u00e1n chuy\u00ean nghi\u1ec7p ch\u1eafc s\u1ebd kh\u00f4ng c\u1ea7n ph\u1ea3i th\u1eafc m\u1eafc <\/span><b>h\u00e0m Sumproduct l\u00e0 g\u00ec<\/b><span style=\"font-weight: 400;\">. B\u1edfi \u0111\u00e2y l\u00e0 h\u00e0m r\u1ea5t quen thu\u1ed9c v\u00e0 c\u00f3 t\u00ednh \u1ee9ng d\u1ee5ng cao trong h\u1ec7 th\u1ed1ng Excel. Nh\u01b0ng v\u1edbi nh\u1eefng \u201ct\u00e2n binh\u201d \u0111ang t\u00ecm hi\u1ec3u v\u1ec1 ph\u1ea7n m\u1ec1m n\u00e0y ch\u1eafc s\u1ebd c\u00f2n b\u1ee1 ng\u1ee1 v\u1edbi h\u00e0m Sumproduct. N\u1ebfu b\u1ea1n \u0111ang th\u1eafc m\u1eafc v\u1ec1 h\u00e0m t\u00ednh n\u00e0y v\u00e0 ch\u01b0a bi\u1ebft c\u00f4ng d\u1ee5ng c\u01a1 b\u1ea3n khi \u00e1p d\u1ee5ng trong Excel nh\u01b0 th\u1ebf n\u00e0o th\u00ec \u0111\u1eebng b\u1ecf qua nh\u1eefng chia s\u1ebb d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Teky.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#Ham_Sumproduct_la_gi\" >H\u00e0m Sumproduct l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#Cong_thuc_ham_Sumproduct\" >C\u00f4ng th\u1ee9c h\u00e0m Sumproduct<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#Huong_dan_cach_su_dung_ham_Sumproduct_trong_Excel_co_ban_nhat\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumproduct trong Excel c\u01a1 b\u1ea3n nh\u1ea5t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#Huong_dan_cach_su_dung_ham_Sumproduct_co_dieu_kien\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumproduct c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#Tinh_tong_cac_ma_giong_nhau_bang_ham_Sumproduct\" >T\u00ednh t\u1ed5ng c\u00e1c m\u00e3 gi\u1ed1ng nhau b\u1eb1ng h\u00e0m Sumproduct\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#Tinh_tong_dua_vao_dieu_kien_bang_ham_Sumproduct_ket_hop_voi_%E2%80%9COR%E2%80%9D\" >T\u00ednh t\u1ed5ng d\u1ef1a v\u00e0o \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng h\u00e0m Sumproduct k\u1ebft h\u1ee3p v\u1edbi \u201cOR\u201d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#Huong_dan_su_dung_ham_Sumproduct_nang_cao\" >H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Sumproduct n\u00e2ng cao\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#Cach_tinh_ham_Sumproduct_nang_cao_bang_cach_long_ghep_them_cac_ham_khac\" >C\u00e1ch t\u00ednh h\u00e0m Sumproduct n\u00e2ng cao b\u1eb1ng c\u00e1ch l\u1ed3ng gh\u00e9p th\u00eam c\u00e1c h\u00e0m kh\u00e1c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#Su_dung_ham_Sumproduct_nang_cao_de_tinh_bang_du_lieu_2_chieu\" >S\u1eed d\u1ee5ng h\u00e0m Sumproduct n\u00e2ng cao \u0111\u1ec3 t\u00ednh b\u1ea3ng d\u1eef li\u1ec7u 2 chi\u1ec1u<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Sumproduct_la_gi\"><\/span><b>H\u00e0m Sumproduct l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10721 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-11.jpg\" alt=\"H\u00e0m Sumproduct l\u00e0 g\u00ec?-01\" width=\"600\" height=\"310\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-11.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-11-400x207.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n \u0111ang th\u1eafc m\u1eafc <\/span><b>h\u00e0m Sumproduct l\u00e0 g\u00ec<\/b><span style=\"font-weight: 400;\">? \u0110\u00e2y th\u1ef1c ra l\u00e0 m\u1ed9t h\u00e0m trong Excel c\u00f3 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa 2 h\u00e0m l\u1ea1i v\u1edbi nhau. \u0110\u00f3 ch\u00ednh l\u00e0 h\u00e0m Sum v\u00e0 h\u00e0m Product. Theo \u0111\u00f3, h\u00e0m n\u00e0y s\u1ebd gi\u00fap tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ed5ng c\u1ee7a nhi\u1ec1u t\u00edch trong c\u00f9ng 1 d\u00e3y s\u1ed1 \u0111\u01b0\u1ee3c cho trong ph\u1ea7n m\u1ec1m. Vi\u1ec7c \u1ee9ng d\u1ee5ng h\u00e0m Sumproduct<\/span> <span style=\"font-weight: 400;\">gi\u00fap vi\u1ec7c nh\u00e2n t\u00edch c\u00e1c ph\u00e9p c\u1ed9ng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nhanh v\u00e0 c\u00f3 \u0111\u1ed9 ch\u00ednh x\u00e1c cao nh\u1ea5t.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_Sumproduct\"><\/span><b>C\u00f4ng th\u1ee9c h\u00e0m Sumproduct<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: center;\">\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10723 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-21.jpg\" alt=\"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumproduct trong Excel\" width=\"600\" height=\"221\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-21.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-21-400x147.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Mu\u1ed1n t\u00ednh \u0111\u01b0\u1ee3c <\/span><b><i>h\u00e0m Sumproduct<\/i><\/b><span style=\"font-weight: 400;\"> th\u00ec b\u1ea1n ph\u1ea3i n\u1eafm \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p c\u1ee7a h\u00e0m. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">SUMPRODUCT(array1, [array2], [array3], \u2026)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Theo \u0111\u00f3, trong c\u00fa ph\u00e1p n\u00e0y, c\u00e1c gi\u00e1 tr\u1ecb\u00a0 array ch\u00ednh l\u00e0 d\u1ea3i s\u1ed1 li\u00ean t\u1ee5c ho\u1eb7c l\u00e0 m\u1ed9t m\u1ea3ng c\u00f3 c\u00e1c th\u00e0nh ph\u1ea7n c\u1ea7n \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n. Vi\u1ec7c nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb array c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n c\u1ea9n th\u1eadn v\u1edbi h\u00e0m n\u00e0y. \u0110\u1eb7c bi\u1ec7t, c\u00e1c m\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u00f2i h\u1ecfi ph\u1ea3i c\u00f3 c\u00f9ng s\u1ed1 h\u00e0ng hay c\u00f9ng s\u1ed1 c\u1ed9t. N\u1ebfu ch\u1ecdn sai, h\u00e0m khi t\u00ednh s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 #VALUE.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumproduct trong Excel (c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/OQfoTt5qeTA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_cach_su_dung_ham_Sumproduct_trong_Excel_co_ban_nhat\"><\/span><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumproduct trong Excel c\u01a1 b\u1ea3n nh\u1ea5t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng <\/span><b><i>h\u00e0m Sumproduct trong excel<\/i><\/b><span style=\"font-weight: 400;\"> kh\u00f4ng qu\u00e1 kh\u00f3. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng ti\u1ec1n trong danh s\u00e1ch mua tr\u00e1i c\u00e2y theo v\u00ed d\u1ee5 trong h\u00ecnh th\u00ec b\u1ea1n s\u1ebd c\u1ea7n \u00e1p d\u1ee5ng theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10720 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-1.jpg\" alt=\"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumproduct trong Excel\" width=\"600\" height=\"162\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-1-400x108.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn v\u00f9ng s\u1ed1 l\u01b0\u1ee3ng t\u1eeb F6:F9<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn v\u00f9ng \u0111\u01a1n gi\u00e1 t\u1eeb G6:G9<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u00f9ng h\u00e0m Sumproduct \u0111\u1ec3 nh\u00e2n 2 v\u00f9ng n\u00e0y l\u1ea1i v\u1edbi nhau \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_cach_su_dung_ham_Sumproduct_co_dieu_kien\"><\/span><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumproduct c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c <\/span><b>h\u00e0m Sumproduct l\u00e0 g\u00ec<\/b><span style=\"font-weight: 400;\"> th\u00ec c\u0169ng c\u1ea7n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y trong Excel v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau. N\u1ebfu \u00e1p d\u1ee5ng ch\u00ednh x\u00e1c <\/span><b><i>h\u00e0m Sumproduct c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/i><\/b><span style=\"font-weight: 400;\"> s\u1ebd gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfn h\u00e0nh t\u00ednh to\u00e1n c\u00e1c con s\u1ed1 trong ph\u1ea7n m\u1ec1m Excel \u0111\u01b0\u1ee3c nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u.\u00a0 D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u01a1 b\u1ea3n \u0111\u1ec3 b\u1ea1n tham kh\u1ea3o.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_tong_cac_ma_giong_nhau_bang_ham_Sumproduct\"><\/span><b>T\u00ednh t\u1ed5ng c\u00e1c m\u00e3 gi\u1ed1ng nhau b\u1eb1ng h\u00e0m Sumproduct\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cho b\u1ea3ng Doanh Thu th\u1ef1c ph\u1ea9m \u1edf c\u00e1c khu v\u1ef1c kh\u00e1c nhau theo b\u1ea3ng d\u01b0\u1edbi. B\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m Sumproduct \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh thu tr\u00e0 t\u1ea1i khu v\u1ef1c ph\u00eda B\u1eafc trong b\u1ea3ng.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10725 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-31.jpg\" alt=\"\" width=\"600\" height=\"213\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-31.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-31-400x142.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi y\u00eau c\u1ea7u t\u00ednh tr\u00ean, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m Sumproduct\u00a0 theo c\u00f4ng th\u1ee9c: =SUMPRODUCT((B3:B10=&#8221;Tr\u00e0&#8221;*(C3:C10=&#8221;B\u1eafc&#8221;)*D3:D10). Theo \u0111\u00f3, k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb trong ph\u1ea7n m\u1ec1m Excel s\u1ebd l\u00e0:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10727 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-41.jpg\" alt=\"ham-sumproduct-la-gi-2\" width=\"600\" height=\"221\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-41.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-41-400x147.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_tong_dua_vao_dieu_kien_bang_ham_Sumproduct_ket_hop_voi_%E2%80%9COR%E2%80%9D\"><\/span><b>T\u00ednh t\u1ed5ng d\u1ef1a v\u00e0o \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng h\u00e0m Sumproduct k\u1ebft h\u1ee3p v\u1edbi \u201cOR\u201d<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1eabn v\u1edbi v\u00ed d\u1ee5 t\u00ednh b\u1ea3ng doanh thu tr\u00ean nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng <\/span><b><i>h\u00e0m Sumproduct nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/i><\/b><span style=\"font-weight: 400;\"> n\u1ebfu y\u00eau c\u1ea7u t\u00ednh nhi\u1ec1u h\u01a1n 1 d\u1eef ki\u1ec7n. C\u1ee5 th\u1ec3 l\u00e0 t\u1eeb b\u1ea3ng tr\u00ean, b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng doanh thu c\u1ee7a tr\u00e0 hay c\u1ee7a cafe \u1edf ph\u00eda B\u1eafc. V\u1edbi y\u00eau c\u1ea7u t\u00ednh n\u00e0y, b\u1ea1n v\u1eabn s\u1ebd s\u1eed d\u1ee5ng h\u00e0m Sumproduct nh\u01b0ng c\u1ea7n k\u1ebft h\u1ee3p th\u00eam \u201cOR\u201d \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u00ednh t\u1ed5ng chu\u1ea9n nh\u1ea5t.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10728 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-5.jpg\" alt=\"\" width=\"600\" height=\"194\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-5-400x129.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c t\u00ednh nh\u01b0 sau: =SUMPRODUCT(OR((B3:B10=&#8221;Tr\u00e0&#8221;;(B3:B10=&#8221;C\u00e0 ph\u00ea&#8221;))*(C3:C10=&#8221;B\u1eafc&#8221;)*D3:D10). K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd c\u00f3 nh\u01b0 b\u1ea3ng sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10729 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg\" alt=\"ham-sumproduct-la-gi-xem-ngay\" width=\"600\" height=\"197\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6-400x131.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_su_dung_ham_Sumproduct_nang_cao\"><\/span><b>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Sumproduct n\u00e2ng cao\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn <\/span><b><i>h\u00e0m Sumproduct n\u00e2ng cao<\/i><\/b><span style=\"font-weight: 400;\">. \u0110\u00e2y l\u00e0 lo\u1ea1i h\u00e0m c\u1ea7n ph\u1ea3i c\u00f3 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m Sumproduct v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c m\u00e0 v\u1eabn \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n t\u00ednh. C\u00f3 nhi\u1ec1u c\u00e1ch \u00e1p d\u1ee5ng <\/span><b><i>h\u00e0m Sumproduct n\u00e2ng cao<\/i><\/b><span style=\"font-weight: 400;\"> m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o theo c\u00e1c h\u01b0\u1edbng d\u1eabn sau:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_tinh_ham_Sumproduct_nang_cao_bang_cach_long_ghep_them_cac_ham_khac\"><\/span><b>C\u00e1ch t\u00ednh h\u00e0m Sumproduct n\u00e2ng cao b\u1eb1ng c\u00e1ch l\u1ed3ng gh\u00e9p th\u00eam c\u00e1c h\u00e0m kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Quay tr\u1edf l\u1ea1i v\u00ed d\u1ee5 danh s\u00e1ch tr\u00e1i c\u00e2y \u1edf m\u1ee5c t\u00ednh h\u00e0m Sumproduct c\u01a1 b\u1ea3n, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00eam c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u00ednh t\u1ed5ng ti\u1ec1n c\u00e1c tr\u00e1i c\u00e2y \u0111\u00e3 b\u00e1n \u0111\u01b0\u1ee3c trong th\u00e1ng 3. Nh\u01b0ng trong b\u1ea3ng l\u1ea1i ch\u1ec9 c\u00f3 c\u1ed9t ng\u00e0y m\u00e0 kh\u00f4ng c\u00f3 c\u1ed9t th\u00e1ng. \u0110i\u1ec1u b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 s\u1eed d\u1ee5ng th\u00eam h\u00e0m MONTH. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10722 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-2.jpg\" alt=\"\" width=\"600\" height=\"132\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-2-400x88.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u1ede c\u1ed9t Ng\u00e0y b\u00e1n s\u1ebd t\u00ednh t\u1eeb B2;B5 k\u1ebft h\u1ee3p h\u00e0m MONTH v\u00e0 \u0111em so s\u00e1nh v\u1edbi 3<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u1ed9t s\u1ed1 l\u01b0\u1ee3ng ch\u1ecdn t\u00ednh t\u1eeb C2:C5<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u1ed9t \u0111\u01a1n gi\u00e1 t\u00ednh t\u1eeb D2:D6=5<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sau khi c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ee7a 3 c\u1ed9t, b\u1ea1n d\u00f9ng h\u00e0m Sumproduct \u0111\u1ec3 nh\u00e2n l\u1ea1i v\u1edbi nhau s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 b\u1ea3ng sau:<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_Sumproduct_nang_cao_de_tinh_bang_du_lieu_2_chieu\"><\/span><b><i>S\u1eed d\u1ee5ng h\u00e0m Sumproduct n\u00e2ng cao \u0111\u1ec3 t\u00ednh b\u1ea3ng d\u1eef li\u1ec7u 2 chi\u1ec1u<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 m\u1ed9t c\u00e1ch \u00e1p d\u1ee5ng <\/span><b><i>h\u00e0m Sumproduct n\u00e2ng cao<\/i><\/b><span style=\"font-weight: 400;\"> m\u00e0 nhi\u1ec1u ng\u01b0\u1eddi v\u1eabn ch\u01b0a bi\u1ebft. \u0110\u00f3 ch\u00ednh l\u00e0 t\u00ednh b\u1ea3ng c\u00f3 d\u1eef li\u1ec7u 2 chi\u1ec1u. B\u1ea1n c\u00f3 th\u1ec3 xem v\u00ed d\u1ee5 nh\u01b0 h\u00ecnh sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10724 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-3.jpg\" alt=\"\" width=\"600\" height=\"461\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-3-400x307.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Theo \u0111\u00f3, b\u1ea1n c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c \u0111\u01a1n gi\u00e1 c\u1ee7a 1 m\u1eb7t h\u00e0ng nh\u01b0ng n\u00f3 ph\u1ea3i \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c 2 \u0111i\u1ec1u ki\u1ec7n. \u0110\u00f3 l\u00e0 M\u00e3 c\u00f4ng ty v\u00e0 M\u00e3 h\u00e0ng. Nh\u01b0 v\u1eady, t\u1ea1i \u201cB\u1ea3ng \u0111\u01a1n gi\u00e1 h\u00e0ng h\u00f3a\u2019 s\u1ebd c\u00f3 2 chi\u1ec1u. 1 chi\u1ec1u d\u1ecdc l\u00e0 M\u00e3 c\u00f4ng ty v\u00e0 1 chi\u1ec1u ngang l\u00e0 M\u00e3 h\u00e0ng. Hai chi\u1ec1u n\u00e0y c\u00f3 c\u00e1c \u0111i\u1ec3m giao nhau ch\u00ednh l\u00e0 c\u00e1c \u0111\u01a1n gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi y\u00eau c\u1ea7u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <\/span><b><i>h\u00e0m Sumproduct<\/i><\/b><span style=\"font-weight: 400;\"> v\u1edbi c\u00e1c d\u1eef ki\u1ec7n \u0111\u01b0\u1ee3c l\u1ea5y nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">M\u1ea3ng M\u00e3 c\u00f4ng ty s\u1ebd l\u1ea5y t\u1eeb B14:B17 c\u00f3 m\u00e3 \u0111\u01b0\u1ee3c l\u1ea5y \u1edf \u00f4 C3<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">M\u1ea3ng M\u00e3 h\u00e0ng s\u1ebd l\u1ea5y t\u1eeb C13:F13 v\u1edbi m\u00e3 \u0111\u01b0\u1ee3c l\u1ea5y \u1edf \u00f4 B3<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u01b0\u01a1ng \u1ee9ng theo 2 \u0111i\u1ec1u ki\u1ec7n tr\u00ean, b\u1ea1n s\u1ebd l\u1ea5y \u0111\u01a1n gi\u00e1 t\u1eeb C14:F17<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1eeb nh\u1eefng d\u1eef ki\u1ec7n \u0111\u01b0\u1ee3c l\u1ea5y tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp <\/span><b><i>h\u00e0m Sumproduct<\/i><\/b><span style=\"font-weight: 400;\"> theo c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">G3=SUMPRODUCT(($B$14:$B$17=C3)*($C$13:$F$13=B3)*$C$14:$F$17)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 t\u00ecm \u0111\u01b0\u1ee3c s\u1ebd th\u1ec3 hi\u1ec7n r\u00f5 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10726 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-4.jpg\" alt=\"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumproduct trong Excel\" width=\"600\" height=\"238\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-4-400x159.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">So v\u1edbi c\u00e1c <\/span><b><i>h\u00e0m Sumproduct<\/i><\/b><span style=\"font-weight: 400;\"> kh\u00e1c th\u00ec h\u00e0m n\u00e2ng cao n\u00e0y c\u00f3 ph\u1ea7n ph\u1ee9c t\u1ea1p h\u01a1n. V\u00ec th\u1ebf, khi t\u00ednh to\u00e1n, b\u1ea1n c\u1ea7n ph\u1ea3i ch\u1ecdn ch\u00ednh x\u00e1c c\u00e1c v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c h\u00e0m. N\u1ebfu ch\u1ecdn sai v\u00f9ng s\u1ebd khi\u1ebfn Excel tr\u1ea3 k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y, Teky \u0111\u00e3 gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u r\u00f5 th\u00f4ng tin <\/span><b>h\u00e0m Sumproduct l\u00e0 g\u00ec<\/b><span style=\"font-weight: 400;\"> c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c <\/span><b><i>h\u00e0m Sumproduct trong excel<\/i><\/b><span style=\"font-weight: 400;\"> v\u1edbi \u0111i\u1ec1u ki\u1ec7n v\u00e0 n\u00e2ng cao chi ti\u1ebft nh\u1ea5t. N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n hay \u0111\u0103ng k\u00fd c\u00e1c kh\u00f3a h\u1ecdc Excel ch\u1ea5t l\u01b0\u1ee3ng th\u00ec \u0111\u1eebng qu\u00ean li\u00ean h\u1ec7 \u0111\u1ebfn <strong><a href=\"https:\/\/teky.edu.vn\/\">Teky<\/a><\/strong> \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c s\u1ef1 h\u1ed7 tr\u1ee3 uy t\u00edn, chuy\u00ean nghi\u1ec7p nh\u1ea5t. D\u1ecbch v\u1ee5 cam k\u1ebft mang \u0111\u1ebfn b\u1ea1n c\u00e1c kh\u00f3a \u0111\u00e0o t\u1ea1o gi\u00e1 t\u1ed1t, k\u1ebft qu\u1ea3 v\u01b0\u1ee3t tr\u1ed9i.<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Len trong Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Sumproduct l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong Excel? Xem Ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin chi ti\u1ebft. V\u1edbi d\u00e2n k\u1ebf to\u00e1n chuy\u00ean nghi\u1ec7p ch\u1eafc s\u1ebd kh\u00f4ng c\u1ea7n ph\u1ea3i th\u1eafc m\u1eafc h\u00e0m Sumproduct l\u00e0 g\u00ec. B\u1edfi \u0111\u00e2y l\u00e0 h\u00e0m r\u1ea5t quen thu\u1ed9c v\u00e0 c\u00f3 t\u00ednh \u1ee9ng d\u1ee5ng cao trong &hellip;<\/p>\n","protected":false},"author":3,"featured_media":10729,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-10717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct<\/title>\n<meta name=\"description\" content=\"H\u00e0m Sumproduct l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong Excel? Xem Ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin chi ti\u1ebft. C\u00f9ng xem c\u00e1ch th\u1ef1c hi\u1ec7n\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m Sumproduct l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong Excel? Xem Ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin chi ti\u1ebft. C\u00f9ng xem c\u00e1ch th\u1ef1c hi\u1ec7n\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-03T09:29:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T07:15:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"197\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct\",\"datePublished\":\"2022-11-03T09:29:09+00:00\",\"dateModified\":\"2022-12-06T07:15:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/\"},\"wordCount\":1934,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/\",\"name\":\"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg\",\"datePublished\":\"2022-11-03T09:29:09+00:00\",\"dateModified\":\"2022-12-06T07:15:22+00:00\",\"description\":\"H\u00e0m Sumproduct l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong Excel? Xem Ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin chi ti\u1ebft. C\u00f9ng xem c\u00e1ch th\u1ef1c hi\u1ec7n\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg\",\"width\":600,\"height\":197},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"IT - L\u1eadp tr\u00ecnh\",\"item\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct","description":"H\u00e0m Sumproduct l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong Excel? Xem Ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin chi ti\u1ebft. C\u00f9ng xem c\u00e1ch th\u1ef1c hi\u1ec7n","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct","og_description":"H\u00e0m Sumproduct l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong Excel? Xem Ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin chi ti\u1ebft. C\u00f9ng xem c\u00e1ch th\u1ef1c hi\u1ec7n","og_url":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-03T09:29:09+00:00","article_modified_time":"2022-12-06T07:15:22+00:00","og_image":[{"width":600,"height":197,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct","datePublished":"2022-11-03T09:29:09+00:00","dateModified":"2022-12-06T07:15:22+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/"},"wordCount":1934,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/","name":"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg","datePublished":"2022-11-03T09:29:09+00:00","dateModified":"2022-12-06T07:15:22+00:00","description":"H\u00e0m Sumproduct l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong Excel? Xem Ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin chi ti\u1ebft. C\u00f9ng xem c\u00e1ch th\u1ef1c hi\u1ec7n","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-sumproduct-la-gi-6.jpg","width":600,"height":197},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-sumproduct-la-gi-huong-dan-cach-su-dung-ham-sumproduct-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"IT - L\u1eadp tr\u00ecnh","item":"https:\/\/teky.edu.vn\/blog\/lap-trinh\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m Sumproduct l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m Sumproduct"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=10717"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10717\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/10729"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=10717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=10717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=10717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}