Sum columns based on column headings

[Jario]

Hi

Please can someone help.

Im trying to sum columns based on the column headings. Please see example below.

The data needs to stay in this format and I only want totals for the columns without "R", ie the ones listed to the right.
The column headings do also repeat several times.

Please see attached.

Your help would be much appreciated.


<1100> <1100R> <1018> <1018R> <1019> <1019R> <2005> <2005R> <1100> <1100R> <2005> <2005R>
4 5 9 2 3 4 2 7 2 3 6 9
5 4 5 9 2 3 4 2 7 2 3 6
4 5 9 2 3 4 2 7 2 3 6 9
9 2 3 4 2 7 2 3 6 9 1 7
5 4 5 9 2 3 4 2 7 2 3 6
4 5 9 2 3 4 2 7 2 3 6 9
9 2 3 4 2 7 2 3 6 9 1 8
4 5 9 2 3 4 2 7 2 3 6 9
9 2 3 4 2 7 2 3 6 9 1 2
5 4 5 9 2 3 4 2 7 2 3 6
9 2 3 4 2 7 2 3 6 9 1 2
5 4 5 9 2 3 4 2 7 2 3 6

TOTAL
<1100> X
<1018> X
<1019> X
<2005> X