{"id":1287,"date":"2020-06-02T20:52:34","date_gmt":"2020-06-02T12:52:34","guid":{"rendered":"http:\/\/www.fyndpro.com\/?p=1287"},"modified":"2020-06-02T20:59:35","modified_gmt":"2020-06-02T12:59:35","slug":"sumproduct_replace_sumif","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/en\/sumproduct_replace_sumif\/","title":{"rendered":"\u5229\u7528SUMPRODUCT\u53d6\u4ee3\u7d2f\u8d05\u7684SUMIF\u516c\u5f0f"},"content":{"rendered":"<blockquote><p>\u4e00\u689d\u5481\u9577\u53c8\u91cd\u8986\u5605SUMIF\u516c\u5f0f\u9ede\u6a23\u9760SUMPRODUCT\u7c21\u5316\u5462\uff1f<\/p>\n<p>=SUMIF($A$2:$A$16,F3,$B$2:$B$16)+SUMIF($A$2:$A$16,F3,$C$2:$C$16)+SUMIF($A$2:$A$16,F3,$D$2:$D$16)<\/p><\/blockquote>\n<p>\u4e00\u9f4a\u7747\u7747\u6559\u5b78\u7247\u8a73\u7d30\u8b1b\u89e3\u5566\uff01<\/p>\n<p><iframe loading=\"lazy\" title=\"\u3010Excel\u6559\u5b78\u3011\u5229\u7528SUMPRODUCT\u53d6\u4ee3\u7d2f\u8d05\u7684SUMIF\u516c\u5f0f\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/eGWCfdsmfVY?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>","protected":false},"excerpt":{"rendered":"<p>\u4e00\u689d\u5481\u9577\u53c8\u91cd\u8986\u5605SUMIF\u516c\u5f0f\u9ede\u6a23\u9760SUMPRODUCT\u7c21\u5316\u5462\uff1f =SUMIF($A$2:$A$16,F3,$ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1290,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[8,7,12,20],"tags":[14,126],"class_list":["post-1287","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-formulas","category-mathematical","category-onlinesupport","tag-sumif","tag-sumproduct"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/06\/%E5%88%A9%E7%94%A8SUMPRODUCT%E5%8F%96%E4%BB%A3%E7%B4%AF%E8%B4%85%E7%9A%84SUMIF%E5%85%AC%E5%BC%8F2.png?fit=1084%2C681&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/comments?post=1287"}],"version-history":[{"count":1,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1287\/revisions"}],"predecessor-version":[{"id":1288,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1287\/revisions\/1288"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media\/1290"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media?parent=1287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/categories?post=1287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/tags?post=1287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}