| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
From Column select Values to sum
Col 1 Col 2
a 1 b 1 c 1 a 1 b 1 a 1 c 1 d 1 I would like a function that will search Col1 for a Value and then sum the values in Col 2 that have the same value in Col1 in the above example the sum of a is 3 the sum of b is 2 the sum of c is 2 the sum of d is 1 Can there a function or functions that can do this in excel?? -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select 50 greatest values with column matching | Excel Discussion (Misc queries) | |||
| select detail in column B if column A = date | Excel Worksheet Functions | |||
| How do I select the last 5 non zero values in a row & get an avg? | Excel Discussion (Misc queries) | |||
| Select values from list | Excel Discussion (Misc queries) | |||
| Select top 5 in column A, sum values in B | Excel Worksheet Functions | |||
Threaded Mode
