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

**Marcomm** · 11-14-2012, 10:40 AM

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?

**Pete_UK** · 11-14-2012, 10:58 AM

I would suggest that you change your title, before the moderators force you to - take a look at the forum rules at the top of the screen.

Pete

**Marcomm** · 11-14-2012, 11:10 AM

To be honest Pete, I dont really know what formula I am looking for hence I don't know how to phrase the question.

Also, where are the amend thread tools? can't put my finger on them.

Thanks

**FDibbins** · 11-14-2012, 11:13 AM

To change a Title on your post, click EDIT (of you're 1st post) then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**Kevin UK** · 11-14-2012, 11:13 AM

Sum function to match criteria, something along those lines!

**Qualo_Jinn** · 11-14-2012, 11:18 AM

First, to change the post title or information or add a worksheet (which always helps whomever wants to answer your question) click the 'Edit Post' button on your original post.

Second, it sounds like SUMIF() or SUMIFS() will get you where you need to be, unless I'm not understanding your question. I may not understand the full scope of what you want so please add a worksheet if that's the case.

**alansidman** · 11-14-2012, 11:24 AM

Look at this tutorial on Sumifs.

http://office.microsoft.com/en-us/ex...010047504.aspx

**jeffreybrown** · 11-14-2012, 11:25 AM

Your profile shows 2003, and if this is the case then...

=SUMPRODUCT(--($A$2:$A$10=2009),--($B$2:$B$10="Speherical 500"),$C$2:$C$10)

...if you do have 2007+

=SUMIFS($C$2:$C$10,$A$2:$A$10,2009,B2:B10,"Speherical 500")