| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining data
Thanks, I'll try that...
"Teethless mama" wrote: D1: holds Bob D2: holds Dan D3: holds David In E2: =SUMPRODUCT(SUMIF(INDIRECT("Sheet"&{1,2}&"!$A$2:$A $100"),D2,INDIRECT("Sheet"&{1,2}&"!$B$2:$B$100"))) Copy down "Dan" wrote: I am fairly new to excel and have a delima. I have two worksheets. The first worksheet has names and numbers, the second has names and numbers as well. The data changes in worksheet 2 from week to week. I want to input data in worksheet 2 and have worksheet 1 look at that data and append to what is already has. If there are duplicates, I want it to sum the data. Can you help...Here is what I have Worksheet 1 (This is the worksheet with the combined data) Name Points Worksheet 2 (This data is to be combined with worksheet 1 and duplicates need to be sum'd making 1 (running) total. Example Worksheet 1 Worksheet 2 Name Points Name Points Dan 20 Bob 20 Bob 14 Dan 8 David 14 I want it to look like this Worksheet 1 Name Points Bob 34 Dan 28 David 14 Can anyone help... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Data | Excel Discussion (Misc queries) | |||
| Combining Data | Excel Discussion (Misc queries) | |||
| Combining data | Excel Discussion (Misc queries) | |||
| combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
| Combining Data | Excel Discussion (Misc queries) | |||
Threaded Mode
