matching

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum If function 3
match and extract 4
Countif certain values on specific date 1
Search Entire Sheet instead of 1? 4
comparing two sheets og copy value 8
Compare and copy/paste 1
Copying a cell value to another sheet by using If statement 1
add hyperlink using sheet names and cells(i,j) 3

Back
Top