Yearly sum

[jam]

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

 

[Bernard Liengme]

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

 

[jam]

Thanks Bernard, but I am forced to do it in column since I have many
years in one sheet
Regards
Jamal

 

[Luke M]

First, I would suggest you read this:
http://spreadsheetpage.com/index.php/comments/arranging_your_data/
for a better way to input data. Then you could do all your data analyzing
with PivotTable and/or simple formulas.

If not, Take a look at the SUBTOTAL function. It can work similar to SUM,
but it ignores any other SUBTOTAL.

or

=SUMIF(A:A,"<>SUM",C:C)