View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ACFO 57 ACFO 57 is offline
external usenet poster
 
Posts: 1
Default 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