G
Guest
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
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