combination of functions for a Monthly Total

[WhytheQ]

I have a table like the below

01-Jun-06 02-Jun-06 03-Jun-06 04-Jun-06..........01-Jul-06....
PlayerA 10 10 5 50
PlayerB 20 20 6 40
PlayerC 30 30 9 609
PlayerD 40 40 40 21


the table goes the full length of the worksheet i.e upto column IV
I have another table which sums the players scores by month:

Jun-06 Jul-06 Aug-06 Sep-06.........Dec-06....
PlayerA
PlayerB
PlayerC
PlayerD

is there a formula I can use which will sum all the daily figures from
the first table

Any help greatly appreciated.
Jason

 

[Max]

See response to your later post ..