Hi all,
I need to combine two workbooks with a sum needed. Here is an example of the files
The county names are the same in many states, so using the state and county will be necessary. The "money" variable will need to be summed for each county, and the number of entries per county is not the same for each county.
There are around 400+ counties that we need to do this for.
Hopefully my question makes sense.
Thanks, Dolez
I need to combine two workbooks with a sum needed. Here is an example of the files
Input Worksheet 1 | Input Worksheet 2 | |||||
County | State | Rate | county | State | Money | |
Adams | ID | 10 | Adams | ID | 1000 | |
Davidson | TN | 20 | Adams | ID | 1500 | |
Adams | ID | 2000 | ||||
Davidson | TN | 800 | ||||
Davidson | TN | 700 | ||||
Davidson | TN | 500 | ||||
Davidson | TN | 1000 | ||||
Output Worksheet | ||||||
County | State | Rate | MoneyTotal | |||
Adams | ID | 10 | 4500 | |||
Davidson | TN | 20 | 3000 |
The county names are the same in many states, so using the state and county will be necessary. The "money" variable will need to be summed for each county, and the number of entries per county is not the same for each county.
There are around 400+ counties that we need to do this for.
Hopefully my question makes sense.
Thanks, Dolez