| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum related data and move to another sheet
Hi - please could someone help me - I am trying to sum a field for all
unique values in another column e.g. James 5 James 11 Jack 1 Tim 99 and so on with variable names My output needs to be something like: James 16 + data from any of the other fields that were in the original worksheet Jack 1 Tim 99 Cheers for any input, Will |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum related data and move to another sheet
Would it be possible to use SUMIF to do this?
wrote: Hi - please could someone help me - I am trying to sum a field for all unique values in another column e.g. James 5 James 11 Jack 1 Tim 99 and so on with variable names My output needs to be something like: James 16 + data from any of the other fields that were in the original worksheet Jack 1 Tim 99 Cheers for any input, Will |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum related data and move to another sheet
Use advanced filter with the unique option on the name column to get a list
of uniques. Then use Sumif to get the sums. -- Regards, Tom Ogilvy wrote in message ups.com... Would it be possible to use SUMIF to do this? wrote: Hi - please could someone help me - I am trying to sum a field for all unique values in another column e.g. James 5 James 11 Jack 1 Tim 99 and so on with variable names My output needs to be something like: James 16 + data from any of the other fields that were in the original worksheet Jack 1 Tim 99 Cheers for any input, Will |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to copy related information from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
| How do I move daily data from one sheet to a 'yearly sheet' | Excel Worksheet Functions | |||
| Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| How to move data from one sheet to another | Excel Discussion (Misc queries) | |||
![TheWJB@gmail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
