Vlookup with Multiple Matches in one column.

[EddieD]

Hi all,

in Column A I have a series of rows of product names. In Column C I have the product values.

Often there are multiple entries of the same product name down the rows.

I am looking to sum all of the values of the products that appear in the rows.

Any suggestions?
Thanks.

 

[DanteAmor]

Use a pivot table

 

[Peter_SSs]

If the data is sorted by (or at least grouped by) Product Name then another option is to use Excel's built-in Subtotal feature (on the Data ribbon tab)

Before Subtotals

23 01 28.xlsm
	A	B	C
1	Product	Data	Value
2	Prod 1		4
3	Prod 1		2
4	Prod 1		5
5	Prod 1		3
6	Prod 2		1
7	Prod 3		2
8	Prod 3		5
9	Prod 3		4
10	Prod 4		7
11	Prod 4		2
12	Prod 4		3
13	Prod 4		5
Subtotal

After

23 01 28.xlsm
	A	B	C
1	Product	Data	Value
2	Prod 1		4
3	Prod 1		2
4	Prod 1		5
5	Prod 1		3
6	Prod 1 Total		14
7	Prod 2		1
8	Prod 2 Total		1
9	Prod 3		2
10	Prod 3		5
11	Prod 3		4
12	Prod 3 Total		11
13	Prod 4		7
14	Prod 4		2
15	Prod 4		3
16	Prod 4		5
17	Prod 4 Total		17
18	Grand Total		43
Subtotal

Cell Formulas
Range	Formula
C6,C17	C6	=SUBTOTAL(9,C2:C5)
C8	C8	=SUBTOTAL(9,C7:C7)
C12	C12	=SUBTOTAL(9,C9:C11)
C18	C18	=SUBTOTAL(9,C2:C16)

If you want, these sections can be collapsed/expanded using the numbered buttons or the +/- icons at the left