Excel 計算問題

2007-11-05 2:43 am
UPCITEM SOLD DOLLARS
123 MICKEY XS 67 670
222 MICKEY M 65 65
345 PRINCESS L 45 450
555 PRINCESS M 24 240

On above data, How to make a total SOLD & DOLLARS in MICKEY( That include all size of MICKEY) to a cell?
If can use the marco that will be the best. It is becasue in our database have much of things, i can't select the each cell to make a total.

回答 (1)

2007-11-05 5:49 pm
✔ 最佳答案
I shall write a macro for you, but you have to say the number of columns you have in the worksheet. It seems that there are 5 columns, but you only have 4 "headings".


2007-11-06 10:34:38 補充:
或者可看看下面的例子, 是否你想要的:http://www.geocities.com/shin_bingo_dog/YK-SumByGp.xls你可加多幾個entries, 第7, 8 columns會自動update.


收錄日期: 2021-04-23 17:21:09
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071104000051KK03934

檢視 Wayback Machine 備份