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

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

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

Put this in C1 of worksheet 1:

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

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

Hope this helps.

Pete

On Apr 21, 5:06*pm, ACFO 57 <ACFO
wrote:
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