HELP....Excel formula!!!

2012-04-05 11:15 pm

圖片參考:http://imgcld.yimg.com/8/n/HA00099353/o/701204050054613873389230.jpg


留意以下三點:
1. Category : 分別有723010,723160 & 727160
2. Unit Cost
3. Every month order quantity

在every month totoal amount下面分別mark左那三個category model #723010, 723160 and 727160....
現正想set formula自動顯示每月每category買左總共幾錢
e.g. Feb: #723010 sub total = 5 x $129
#727160 sub total = 5 x $498
Jan: #723010 sub total = 5 x $129 + 3 x $185 + 2 x $75

Thanks a lot!!!!!

回答 (1)

2012-04-06 7:43 am
✔ 最佳答案
圖中紅字金額似乎不對........

E16=SUMPRODUCT(($D$3:$D$15)*(E3:E15)) (右拉)

E17=SUMPRODUCT(($C$3:$C$15=$D17)*($D$3:$D$15)*(E$3:E$15))

右拉下拉便成

請參考附件: http://www.FunP.Net/199585


收錄日期: 2021-04-16 14:17:44
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20120405000051KK00546

檢視 Wayback Machine 備份