excel條件加總:Realtime－進擊的巨人14, 進擊的巨人線上看, 進擊的巨人漫畫, 進擊的巨人遊戲, 進擊的巨人動畫, 進擊的巨人線上漫畫, 進擊的巨人14線上看, 進擊的巨人13, 進擊的巨人 h, 進擊的巨人op

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中

excel條件加總

Jan 23rd 2015, 01:12

請問我想要計算每個人在各類別中的金額加總,但是公式套不出答案來

這式子是要表達王小明在類別ＢＫ，Ｄ，Ｅ，Ｒ，Ｓ，Ｗ，Ｃ且金額＞０加總為多少
=SUMPRODUCT((B2:B992="王小明")*(R2:R992="BK")*(R2:R992="D")*(R2:R992="E")*(R2:R992="R")*(R2:R992="S")*(R2:R992="W")*(R2:R992="C")*W2:W992,>0)

亦或者是我可以直接表示　除了　ＮＡ類別不包含以外的其他類別加總嗎
=SUMPRODUCT((B2:B992="王小明")*(R2:R992=＜＞"ＮＡ")*W2:W992,>0)

請高人指點一下　謝謝

Recommended article: Chomsky: We Are All – Fill in the Blank.
This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions