Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup and Sum unique values
Hello,
I am trying to do a vlookup on Group Names and return a sum of the unique values only. I have many Group names all over this sheet and much of this is repeated (It is important for that sheet). However I just need to have a sum of all unique values. For example Column A Column B Group Name Number in Group F8 20 F7 30 F7 5 F8 20 F7 10 F8 5 F7 30 F7 5 F8 15 F8 5 F8 15 The reu;lt would return a total of 40 for F8(20 + 15 + 5) and a total of 45 for F7 (30 + 5 + 10) Thanks chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=if(vlookup for non-unique values | Excel Worksheet Functions | |||
Unique values | Excel Worksheet Functions | |||
Unique Values | Excel Worksheet Functions | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions |