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

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