Sum Data in Multiple Columns

I have an excel sheet with about 250 columns worth of data (A:IQ). Column A contains a unique value/header (9025 rows), and then each column (B:IQ) contains data associated with/for that value. This data is a combination of a year with a dollar amount for that year in the immediate column to the right. A single value from column A may have the same year in multiple columns, with different corresponding dollar amounts (a single column does not contain the same year all the way down).

I would like to perform a calculation that adds up the dollar value associated each year in the column to the left of the dollar value, so that for each row, I have a single dollar amount for each year. Since I am reading across the row, I know I can’t use a sumif function. At this point, I am at a loss of how to get this calculation. Sample data and the ideal results are below. Any thoughts/guidance are sincerely appreciated.


Example:
Source File
Title (A) Year (B) Amount (C) Year (D) Amount Year(F) Amount(G)
NAME 1 2011 100 2011 125 2013 50
NAME 2 2011 50 2012 50 2012 100
NAME 3 2012 100 2013 25 2013 100

Desired Result:
Title(A) 2011(B) 2012(C) 2013(D) 2014(E) 2015(F)
NAME 1 225 0 0 0 0
NAME 2 50 150 0 0 0
NAME 3 0 100 125 0 0

Nobody would want to type that data into an Excel sheet before being able to try different things out, so it would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

Thanks for the suggestion, Pete. I really appreciate your help.

Here is my example in an Excel sheet.

Put the first year (2011) in K2 and this formula in L2:

=K2+1

Copy across to O2. Then you can put this formula in K3:

=SUMIF($B3:$H3,K$2,$C3:$I3)

then copy across and down as required. Note the two ranges in the SUMIF formula are offset by one column.

Hope this helps.

Pete

Pete, thank you so much for your help. I have been working on this issue for awhile now and your fix has not only saved my time, but has given me new knowledge that will allow me to better solve problems like this in the future. Many, many, many thanks!

Glad to be able to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete