Sum Index Row

[terpsfan78]

I needs the results of a sum of columns (year 1 of stuff and things, year 2 of stuff and things, etc) to shop up in total stuff & things...see attached file and or below. Instead of adding each cell manually, basically using formula to drag down the column and it computs it automatically, like a transpose sum? Thx in advance.

Year 1 Year 2 Year 3 Year 1 Year 2 Year 3
stuff 1 2 3 things 1 2 3
Total Stuff & Things
Year1 2
Year2 4
Year3 6