Sum Data in Multiple Columns

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