有什麼公式可以自動加總數 (不用篩選)
舉例 : 項目 / 數量
apple = 100pcs
orange = 50pcs
grape = 20pcs
apple = 300pcs
orange = 10pcs
total = 480pcs
*****************
apple = 400pcs
orange = 60pcs
grape = 20pcs
==================
收錄日期: 2021-04-16 11:38:11
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100907000051KK00568