Sum multiple values that correspond to my LOOKUPVALUE.

**zsalem** · 06-06-2013, 06:09 PM

I am trying to use Sum a VLOOKUP where Table has multiple values that = the ONE lOOKUPVALUE.

This is a very complex spreadsheet but I simplified the results in an easy to ready simple spreadsheet.

Please see attached document.

Any help is greatly appreciated!

Have a wonderful day.

For Example...

A company has multiple products.
Each product has 1 sales amount.
Using the Company as my Lookupvalue I need to sum all the Product sales amounts that correspond with that company.

Example File.xlsx

**JBeaucaire** · 06-06-2013, 06:19 PM

The BEST answer I would suggest includes merging your two tables into one. If you put column E values into column C, you don't need column D at all. Then the formula in H3 would be a simple SUMIF:

=SUMIF(A:A, G3, C:C)

**TMS** · 06-06-2013, 06:28 PM

You could try it this way:

HTML Code:

Total across with: SUM(D3:R3) in column S (and copy down)

Then you can use a SUMIF formula: =SUMIF(A3:A17,U3,S3:S17)

Regards, TMS

**zsalem** · 06-07-2013, 10:17 AM

Thank you for your responses...

I cant merge the tables...

The actual spreadsheet looks like this...

Tab 1
Company
PBM
TYE
NEC
FGH

Tab2
Product Amount
AAA 100
BBB 200
CCC 300
DDD 400
EEE 500
FFF 600

A company like PBM can have multiple products. I can create a table to distinguish which products correlate with certain companies but how can I create a formula on the page with just a company listing to then refer to the products and add up the amounts that fall under that company.

is it a index/MATCH, sumif? etc?

I was I could be more clear,

Thanks for all of your help.