Suppose I have two sets of data such as:
set A
NAMEVALUE
one10
two20
three30
four40
five50
six60
set B
NAMEVALUE
three300
one100
four400
five500
six600
two200
How can I tell EXCEL to calculate with me to sum up both value if both name is
the same?
For example, if both name is "one", then sum up both value 10 & 100 and the
output is 110.
Thank you very much!
excel 問題, 請各位大大幫忙
2010-03-30 10:14 pm
回答 (3)
2010-03-31 3:09 pm
✔ 最佳答案
Let Set A in Column A & BSet B in Column C & D
Column F key in "One" , "Two".....
G1=SUMIF(A:A,F1,B:B)+SUMIF(C:C,F1,D:D)
Please download the file for reference: http://www.FunP.Net/536346
2010-04-05 2:37 pm
sheetA! C2 = +B2+ Vlookup (A2, sheetB!A2:B7, 2)
完成
完成
參考: 用 excel 做買賣業進銷存 http://tw.group.knowledge.yahoo.com/excel-learn
2010-04-05 6:28 am
You can use data consolidation (數據合併) function:
Tools->Data->Data Consolidation
Assume Two set are located: A1:B7 and C1:D7 respectively
we summarize the result in F:G
First, Click on cell F1
Then, go to this function: Tools->Data->Data Consolidation
Finally go through steps in image below
http://img40.imageshack.us/img40/5093/y20100404.jpg
Other example on data consolidation:
http://support.microsoft.com/kb/214270
----------------
http://www.excelhelp.net
http://kimbalko.blogspot.com
2010-04-04 22:46:14 補充：
Sorry, the feature should be here:
Data->Consolidate
Tools->Data->Data Consolidation
Assume Two set are located: A1:B7 and C1:D7 respectively
we summarize the result in F:G
First, Click on cell F1
Then, go to this function: Tools->Data->Data Consolidation
Finally go through steps in image below
http://img40.imageshack.us/img40/5093/y20100404.jpg
Other example on data consolidation:
http://support.microsoft.com/kb/214270
----------------
http://www.excelhelp.net
http://kimbalko.blogspot.com
2010-04-04 22:46:14 補充：
Sorry, the feature should be here:
Data->Consolidate
收錄日期: 2021-04-27 13:11:55
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100330000051KK02578