ExcelBanter - Yearly sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Yearly sum (https://www.excelbanter.com/excel-worksheet-functions/259021-yearly-sum.html)

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

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

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

Bernard Liengme wrote:
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

First, I would suggest you read this:
http://spreadsheetpage.com/index.php...ing_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)

--
Best Regards,

Luke M
"jam" wrote in message
...
Thanks Bernard, but I am forced to do it in column since I have many
years in one sheet
Regards
Jamal

Bernard Liengme wrote:
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