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
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