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
Bookmarks