Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching
HI,
Is there a way to do two way matching of two sheets? Sheet1 A1 B1 Customer Name Amounts Sheet2 A1 B1 C1 Customer Name Amounts (if the same customer is in both sheet sumup the amounts) Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching
=SUMIF(Sheet1!A:A,Name,Sheet1!B:B)+SUMIF(Sheet2!A: A,Name,Sheet2!B:B) Will sum if customer is in EITHER one OR both sheets. Replace name with TEXT or cell containing name. "John" wrote: HI, Is there a way to do two way matching of two sheets? Sheet1 A1 B1 Customer Name Amounts Sheet2 A1 B1 C1 Customer Name Amounts (if the same customer is in both sheet sumup the amounts) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching | Excel Discussion (Misc queries) | |||
Need help matching... | Excel Worksheet Functions | |||
Matching | Excel Discussion (Misc queries) | |||
Matching | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |