SUM / VLOOKUP

[Pippy79]

Hi,

how can i VLOOKUP and SUM the below table? as you cna see we have multiple rows with the same item i need column B total for each item number.

	A	B
1	Item number	Total available
2	RM-000002	18.00
3	RM-000002	95.00
4	RM-000002	23.00
5	RM-000002	95.00
6	RM-000002	95.00
7	RM-000002	35.00
8	RM-000002	47.00
9	RM-000003	0.00
10	RM-000003	0.00
11	RM-000003	9.00
12	RM-000003	3.00
13	RM-000004	30.00
14	RM-000005	40.00
15	RM-000006	33.00
16	RM-000006	9.00
17	RM-000006	21.00
18	RM-000006	20.00
19	RM-000007	15.00
20	RM-000007	15.00
21	RM-000008	3.00
22	RM-000009	67.00
23	RM-000010	4.00
24	RM-000010	12.00

Thanks

 

[kevin9999]

I think you just need Sumif()

Book1
	A	B	C	D	E
1	RM-000002	18.00		RM-000002	408.00
2	RM-000002	95.00		RM-000003	12.00
3	RM-000002	23.00		RM-000004	30.00
4	RM-000002	95.00		RM-000005	40.00
5	RM-000002	95.00		RM-000006	83.00
6	RM-000002	35.00		RM-000007	30.00
7	RM-000002	47.00		RM-000008	3.00
8	RM-000003	0.00		RM-000009	67.00
9	RM-000003	0.00		RM-000010	16.00
10	RM-000003	9.00
11	RM-000003	3.00
12	RM-000004	30.00
13	RM-000005	40.00
14	RM-000006	33.00
15	RM-000006	9.00
16	RM-000006	21.00
17	RM-000006	20.00
18	RM-000007	15.00
19	RM-000007	15.00
20	RM-000008	3.00
21	RM-000009	67.00
22	RM-000010	4.00
23	RM-000010	12.00
Sheet1

Cell Formulas
Range	Formula
E1:E9	E1	=SUMIF(A:A,D1,B:B)

 

[Pippy79]

Thanks Kevin, i was having a mind blank there.

 

[kevin9999]

Thanks Kevin, i was having a mind blank there.

You're welcome, and thanks for the feedback