2 columns of data in 2 worksheets to compare and then SUMIF

A

ACFO 57

I want to use a sumif formula, but have two columns of data that need to
match two columns of data in worksheet 2 and then a third column of $ to sum
if both match. See data below - worksheet 2 also has the column of $, and
below is where the formula will be in Col C. Thanks!

CWC_BROOKS-CANDELA BCBS
CWC_BROOKS-CANDELA COMM
CWC_BROOKS-CANDELA HMO/PPO
CWC_BROOKS-CANDELA INDUSTRIAL BILLING
CWC_BROOKS-CANDELA MCD
CWC_BROOKS-CANDELA MCR
CWC_BROOKS-CANDELA O GOV
CWC_BROOKS-CANDELA O NON-GOV
CWC_BROOKS-CANDELA SELF PAY
CWC_TIPPETT BCBS
CWC_TIPPETT COMM
CWC_TIPPETT HMO/PPO
CWC_TIPPETT INDUSTRIAL BILLING
CWC_TIPPETT MCD
 
P

Pete_UK

Put this in C1 of worksheet 1:

=SUMPRODUCT((Sheet2!A$1:A$100=A1)*(Sheet2!B$1:B$100=B1),Sheet2!C$1:C
$100)

I've assumed you have 100 rows of data in Sheet2 - adjust as required.

Hope this helps.

Pete
 

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

Compare data in 2 worksheets 2
Sum up 2 or more columns under same SUMIF criteria 2
comparing 2 columns for matches 2
compare 2 worksheets for simliar cells and then comb into one work 1
compare data from different worksheets and return matching results 1
Compare data from two different worksheets with a condition 2
Compare data (2 columns) from 2 worksheets within a workbook 2
matching 2 columns of data 3

Top