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