Summarizing multiple dynamic columns with a formula

ASample.xlsxHi.

I have a spreadsheet that contains 12(x3) columns - one for each month of the year - and I'm desperately looking for a way to summarize them, ie. make 1(x3) column containing the same information and summarizing.

To make it a bit more visual, I'll recreate it a bit in BBCode (but I can't merge the columns here):

January			February			March
Name	Time	%	Name	Time	%	Name	Time	%
A	10	20	A	20	40	B	5	10
B	10	20	C	20	40	D	25	50
C	30	60	D	10	20	E	20	40

What I would like is a formula that creates the following:

A	30
B	15
C	50
D	35
E	20

This serves two purposes:
1) Being able to calculate percentages on a yearly basis; and
2) Creating a graph on those data

Obviously I could do this with static data, but in reality the data is dynamic and I cannot predict the size of the ranges (but I did limit it to 200 rows - from A38:AJ240 to be exact, including the two header rows). I cannot use VBA because of policies so I wonder how to do this with a formula.

Thanks for your advice!