Show the total sales for each year for specific Product Name.

[Marcomm]

Hi There,

I am an intermediate user of Excel and need some help with automated a task I need to do.

What I have is two sets of data. Set one columns are:

Product Name, 2008, 2009, 2010, 2011, 2012

Product Name example is "Spherical 500"

Set two is as follows;

Product, 2008, 2009, 2010, 2011, 2012 - Approx 4600 Records

Product Example is "NSHBA-BL-00001 Basics 114mm x 1200mm Bollard Root Fixed Bollard Galvanised"

The ultimate result I want is to show the total sales for each year for "Product Name". What I need to do is search the data for a match to "Product Name" e.g. Spherical 500. Where there is a match sum the sales for all the matches and return the value in the first set of data.


So in simple terms - Look at Value in Product Name, Look for all matches in second set of data, where there is a match or multilple matches, sum those numbers. I will need to do this for each year.

Can anyone help?