Vlookup help (1 Viewer)

[scottappleford]

Hi

I would like some help with the Vlookup function and I will try to explain as best I can.

I have sheet that lists company names in one column and then costs in another column.

e.g

company 1 - 1200
company 2 - 1300
company 1 - 1000
company 4 - 300
company 1 - 600
etc

On another summary sheet i just have the company names

company 1
company 2
comapny 3

What i would like is for excel to lookup up in the first sheet all the times the company name appears and then add up all the corresponding costs in the other column, which will then summarise this on the summary sheet in one cell

Company 1 = 2800 (based on figures above)

Hope this is explained properly and you can help.

Many Thanks

Scott

 

[DreamGenius]

You don't want VLookup, you want SumIf. VLookup will only return the first match for each company. Assuming Company List in Columns A1:B100 and Summary List in D1:E10, with column headings, try SumIf (A:A,D2,B:B)