Sum columns based on column headings

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

Please upload a sample worksheet. The text above is all garbled.

like this maybe

thats not what you asked in the original is it? that's easier
=SUMPRODUCT(($B$3:$M$3=P5)*$B$4:$M$15) where p5 =<1100> gives total of 132