{"id":1287,"date":"2020-06-02T20:52:34","date_gmt":"2020-06-02T12:52:34","guid":{"rendered":"http:\/\/www.fyndpro.com\/?p=1287"},"modified":"2026-08-27T16:15:04","modified_gmt":"2026-08-27T08:15:04","slug":"sumproduct_replace_sumif","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/cn\/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>\n","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":3782,"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,20],"tags":[293,296,14,126,298],"class_list":["post-1287","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-onlinesupport","tag-excel","tag-excel-functions","tag-sumif","tag-sumproduct","tag-formula-simplification"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2026\/08\/new_covers_batch_01_excel_vstack_filter.jpg?fit=816%2C1088&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/comments?post=1287"}],"version-history":[{"count":1,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1287\/revisions"}],"predecessor-version":[{"id":1288,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1287\/revisions\/1288"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media\/3782"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media?parent=1287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/categories?post=1287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/tags?post=1287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}