我想問以下的統計點可用Excel set formula?

2008-03-26 8:55 pm
如果我想計Peter 在今個月賣Nokia機共賣左幾錢可以點set formula先計到共賣左 $3000 Nokia機?

係米可以用sumproduct?

Thanks!

Row 1 (Name)
1.Peter
2.Peter
3.Eric
4.Peter
5.Mary
6.Peter
7.John
8.Peter

Row 2 (Phone)
1.Sony
2.Nokia
3.Samsung
4.Samsung
5.Nokia
6.Nokia
7.Sony
8.Nokia

Row 3 (Price)
1.1000
2.1500
3.1300
4.1300
5.1500
6.1500
7.1500
8.1500

回答 (1)

2008-03-26 10:09 pm
✔ 最佳答案
=SUMPRODUCT((A2:A9="Peter")*(B2:B9="Nokia")*(C2:C9))


收錄日期: 2021-04-13 15:21:50
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080326000051KK01247

檢視 Wayback Machine 備份