| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare 2 worksheets all 6 columns in each worksheet | Excel Worksheet Functions | |||
| Compare 2 columns - new worksheets | Excel Worksheet Functions | |||
| compare two columns with different ranges in two worksheets | Excel Discussion (Misc queries) | |||
| how to compare columns in 4 worksheets | Excel Discussion (Misc queries) | |||
| compare columns of different worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
