If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Yearly sum
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 |
#2
|
|||
|
|||
Yearly sum
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 |
#3
|
|||
|
|||
Yearly sum
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 |
#4
|
|||
|
|||
Yearly sum
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 |
Thread Tools | |
Display Modes | |
|
|