vlookup and adding up values

[ben123456]

Hello,

i want to be able to search a random value and then for it to lookup the value. say "DP0001" add all the ones with "DP0001" up and then search for "DP0002" and all the ones with "DP0002" on the next line.

Excel Workbook
	A	B	C	D
1	DP0001		10
2	DP0002		5
3	DP0003		3
4	DP0001		5
5	DP0023		2
6	DP0001		5
7	DP0002		23
8
9
10
Sheet1

Excel Workbook
	A	B	C
1
2	DP0001	ADDED UP RESULT HERE
3
4	DP0002	ADDED UP RESULT HERE
5
6
7
Sheet2

but because i have lots of different values with different codes would it be able to search for different values without having to write - search for "DP0001" in the forumula

 

[Marcelo Branco]

Hi,

Maybe

Formula in Sheet2 B2
=IF(A2<>"",SUMIF(Sheet1!$A$1:$A$500,A2,Sheet1!$C$1:$C$500),"")
copy down

HTH

M.

 

[ben123456]

thats brilliant thanks.

 

[Marcelo Branco]

thats brilliant thanks.

You are welcome and tks for the feedback

M.