{"id":18241,"date":"2024-09-18T16:09:40","date_gmt":"2024-09-18T09:09:40","guid":{"rendered":"\/amis-danh-gia\/?post_type=ht_kb&#038;p=18241"},"modified":"2026-07-14T10:55:01","modified_gmt":"2026-07-14T03:55:01","slug":"bo-sung-ham-sumproduct-khi-dat-cong-thuc-tinh-diem-danh-gia-cua-nhan-vien-tren-phieu-danh-gia","status":"publish","type":"ht_kb","link":"\/amis-danh-gia\/kb\/bo-sung-ham-sumproduct-khi-dat-cong-thuc-tinh-diem-danh-gia-cua-nhan-vien-tren-phieu-danh-gia\/","title":{"rendered":"Thi\u1ebft l\u1eadp h\u00e0m SUMPRODUCT khi \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh \u0111i\u1ec3m \u0111\u00e1nh gi\u00e1 c\u1ee7a nh\u00e2n vi\u00ean tr\u00ean phi\u1ebfu \u0111\u00e1nh gi\u00e1"},"content":{"rendered":"<h3 style=\"text-align: justify;\"><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p style=\"text-align: justify;\">B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn <strong>thi\u1ebft l\u1eadp h\u00e0m SUMPRODUCT khi \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh \u0111i\u1ec3m \u0111\u00e1nh gi\u00e1<\/strong>, gi\u00fap HR \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh kh\u00e1c nhau gi\u1eefa nh\u00f3m ti\u00eau ch\u00ed v\u00e0 ti\u00eau ch\u00ed tr\u00ean phi\u1ebfu \u0111\u00e1nh gi\u00e1 theo h\u00e0m SUMPRODUCT. T\u1eeb \u0111\u00f3 gi\u00fap<strong> ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c<\/strong> cho HR so v\u1edbi vi\u1ec7c t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng b\u1eb1ng file excel t\u1eebng phi\u1ebfu \u0111\u00e1nh gi\u00e1.<\/p>\n<p style=\"text-align: justify;\"><strong>N\u1ed9i dung b\u00e0i vi\u1ebft g\u1ed3m:<\/strong><\/p>\n<ul style=\"list-style-type: circle;\">\n<li>H\u01b0\u1edbng d\u1eabn t\u1ea1o h\u00e0m SUMPRODUCT khi \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh \u0111i\u1ec3m \u0111\u00e1nh gi\u00e1.<\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><strong>2. H\u01b0\u1edbng d\u1eabn th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1: Th\u00eam m\u1edbi<\/strong> ho\u1eb7c <strong>S\u1eeda<\/strong> K\u1ef3 \u0111\u00e1nh gi\u00e1\/Phi\u1ebfu \u0111\u00e1nh gi\u00e1 t\u1ea1i <strong>Thi\u1ebft l\u1eadp tr\u01b0\u1eddng<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2: Ki\u1ec3u d\u1eef li\u1ec7u C\u00f4ng th\u1ee9c<\/strong>\\ch\u1ecdn h\u00e0m <strong>SUMPRODUCT<\/strong> \u0111\u1ec3 \u0111\u1eb7t c\u00f4ng th\u1ee9c v\u00e0 t\u00ednh to\u00e1n t\u1eeb c\u00e1c tr\u01b0\u1eddng trong b\u1ea3ng.<\/p>\n<p><a href=\"\/amis-danh-gia\/wp-content\/uploads\/2026\/07\/2026-07-14_10-51-22.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-21099\" src=\"\/amis-danh-gia\/wp-content\/uploads\/2026\/07\/2026-07-14_10-51-22.png\" alt=\"\" width=\"1893\" height=\"1377\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp h\u00e0m SUMPRODUCT khi \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh \u0111i\u1ec3m \u0111\u00e1nh gi\u00e1, gi\u00fap HR \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh kh\u00e1c nhau gi\u1eefa nh\u00f3m ti\u00eau ch\u00ed v\u00e0 ti\u00eau ch\u00ed tr\u00ean phi\u1ebfu \u0111\u00e1nh gi\u00e1 theo h\u00e0m SUMPRODUCT. T\u1eeb \u0111\u00f3 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng&#8230;<\/p>\n","protected":false},"author":106,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[341],"ht-kb-tag":[],"class_list":["post-18241","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r5-phat-hanh-ngay-05-09-2024"],"_links":{"self":[{"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/ht-kb\/18241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/users\/106"}],"replies":[{"embeddable":true,"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/comments?post=18241"}],"version-history":[{"count":4,"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/ht-kb\/18241\/revisions"}],"predecessor-version":[{"id":21101,"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/ht-kb\/18241\/revisions\/21101"}],"wp:attachment":[{"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/media?parent=18241"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/ht-kb-category?post=18241"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/amis-danh-gia\/wp-json\/wp\/v2\/ht-kb-tag?post=18241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}