Vlookup when more than one lookup value

[blacktour]

Hi,

I am trying to make a formula to process the following:

010101358000000		CF	C	0
010301900000000		CF	C	12840000
010301900000000		CV	C	3745000
010301900000000		RF	1	1912000
010301900000000		CY	Y	2532000
010301900010000		CF	C	1093000
				
010301900020000		DF	D	1033000
010301900020000		CF	C	2096000

So for any number that is the same in the left most column I want to make a total of the values in the right column.

So 010301900020000 would = 3129000

 

[barry houdini]

Try SUMIF,

Assuming your values in the first column are text

=SUMIF(A:A,"010301900020000",D:D)

 

[blacktour]

Try SUMIF,

Assuming your values in the first column are text

=SUMIF(A:A,"010301900020000",D:D)

That works perfect, Thanks!