如果我想計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