例如:
Items Qty
_________
apple 1
orange 2
banana 4
apple 5
orange 8
有冇formula可以計晒apple & orange 既數呢(唔要用sub-total)
THZ!
(急!!!廿分)點樣可以得到excel內重複性資料既數值加總?!
2008-05-18 9:43 pm
回答 (1)
2008-05-19 3:13 am
✔ 最佳答案
You can use SUMIF functionassume your [Items] in column A and [Qty] in column B,
If you want [apple] AND [orange] total, you can put the formula in 參考資料 in cell C1:
You should see [16]
參考: =SUMIF(A:A,”apple”,B:B)+SUMIF(A:A,”orange”,B:B)
收錄日期: 2021-04-13 15:34:35
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080518000051KK01342