Sum multiple vlookup values from column

[Sweedler]

Hello

Ok, so I have a sheet with a column of Article numbers and how many of each unit is sold. But there are multiple occurrences for each article number and I need to total them all up. Now I have made a separate sheet with a list of unique article numbers, but cannot figure out how to total up all of the sales with the info from the register sheet.


Help please

 

[mohadin]

Hi
Try Sumif

 

[ExceLoki]

this should be able to get what you're looking for
---------------

Book1
	A	B	C	D	E
1	article	sold		article	total sold
2	a	81		a	210
3	b	57		b	344
4	c	44		c	327
5	d	32		d	232
6	a	12
7	b	98
8	c	89		a	210
9	d	12		b	344
10	a	54		c	327
11	b	98		d	232
12	c	66
13	d	32
14	a	12
15	b	54
16	c	94
17	d	98
18	a	51
19	b	37
20	c	34
21	d	58
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=SUM(IF($A$2:$B$22=D2,$B$2:$B$22))
E8:E11	E8	=SUMIF($A$2:$A$21,D8,$B$2:$B$21)

 

[mohadin]

=SUMIF($A$1:$B$21,D2,$B$1:B21)

 

[Fluff]

@mohadin that could potentially give odd answers (albeit unlikely)

+Fluff 1.xlsm
	A	B	C	D	E
1
2	a	1		a	13
3	a	a	5
4	a	3
5	a	4
6
List

Cell Formulas
Range	Formula
E2	E2	=SUMIF($A$1:$B$21,D2,$B$1:B21)

 

[Sweedler]

Thank you all for your input. The SUMIF formula worked beautifully