Why not keep data like this
----- JAN FEB MAR APR
1 100 70 etc
2 150 90 etc
3 etc
..
..
SUM =SUM(B2:B31) =SUM(C2:C31) .....
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"jam" wrote in message
...

Any help?
I have a column that I want the monthly sum and then the yearly sum,
any way to make it easier?
A B
1 Jan
2 1 100
3 2 150
4 3 260
5 31 100
6 Sum 610
7 Feb 50
8 1 70
9 90
10 28 100
11 sum 310
12
13 December
14 1 100
15 31 150
16 sum 250
17 Year 1170 (=b6+b11+b16)

Thanks in advance
Jam