Sum of mulpiple values in a column using a vlookup

[AadVissers]

Hey there,

I need some help with a vlookup/sumif formula, which I want to use to get the total amount of sales per employee. In table 1 are the names of the employees in column A. In table 2 are names of employees, but these can occure more than once or not at all, and the sales they make.

In column b of sheet 1 i want the total sales an employee makes. So for employee 1 that should be 2425+774+1154+2789.


[TABLE="width: 584"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]sheet1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]sheet2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]a[/TD]
[TD][/TD]
[TD]b[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]a[/TD]
[TD][/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]name[/TD]
[TD][/TD]
[TD]total[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]sales by[/TD]
[TD][/TD]
[TD]sales[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]employee 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]employee2[/TD]
[TD][/TD]
[TD="align: right"]678[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]employee 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]employee4[/TD]
[TD][/TD]
[TD="align: right"]2345[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]employee 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]employee1[/TD]
[TD][/TD]
[TD="align: right"]2425[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD]employee 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD]employee3[/TD]
[TD][/TD]
[TD="align: right"]667[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD]employee 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD]employee1[/TD]
[TD][/TD]
[TD="align: right"]774[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD]employee 6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD]employee5[/TD]
[TD][/TD]
[TD="align: right"]3664[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD]employee 7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD]employee1[/TD]
[TD][/TD]
[TD="align: right"]1154[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD]employee 8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD]employee2[/TD]
[TD][/TD]
[TD="align: right"]3223[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD]employee 9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD]employee1[/TD]
[TD][/TD]
[TD="align: right"]2789[/TD]
[/TR]
</tbody>[/TABLE]

Can anyone help me calculate the values in column B of table 1? I allready tried an sumif/vlookup combination, but I didn't get it right.

Thanks a lot!

 

[gaz_chops]

Just use a sumif

=SUMIF(Sheet2!$A$2:$A$10,Sheet1!$A2,Sheet2!$B$2:$B$10)

 

[AadVissers]

Thank for the reply.

I already tried that, but is wasn't working properly. I guess I didn't have the two ranges matching..... Above the table in sheet2 there are a couple of empty cells. I think I had the two ranges start in a different row. When it din't work I started thinking to complicated I guess. Sorry for the unnecessary post

 

[gaz_chops]

You're welcome, not unnecessary if it helped.