| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Vlookup values
Hi
I have a workbook with 2 sheets. In sheet 1 I have 2 colums. Colum A containing names, colum B containing numbers. On sheet 2 I would like to make a function that gives me the sum of all numbers in sheet 1 with the same name in colum A. If a type =sum(vlookup(...........) I only get the first number per name from sheet 1. /Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Vlookup with multi values | Excel Worksheet Functions | |||
| Vlookup on a worksheet with similar values | Excel Worksheet Functions | |||
| vlookup returning multiple values | Excel Worksheet Functions | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Threaded Mode
