From: jam on 16 Mar 2010 08:01 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
From: Bernard Liengme on 16 Mar 2010 09:08 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" <jamalhakem(a)gmail.com> wrote in message news:f92ce723224c4aff99de31a77f17561(a)t41g2000yqt.googlegroups.com... > > 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
From: jam on 16 Mar 2010 09:27 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" <jamalhakem(a)gmail.com> wrote in message > news:f92ce723224c4aff99de31a77f17561(a)t41g2000yqt.googlegroups.com... > > > > 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
From: Luke M on 16 Mar 2010 10:40 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)  Best Regards, Luke M "jam" <jamalhakem(a)gmail.com> wrote in message news:15d35bb6d9ac42ceb02cbbe3cf23c1c9(a)30g2000yqi.googlegroups.com... > 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" <jamalhakem(a)gmail.com> wrote in message >> news:f92ce723224c4aff99de31a77f17561(a)t41g2000yqt.googlegroups.com... >> > >> > 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

Pages: 1 Prev: How do I get dropdown list that includes, eg top10 Next: Monday closest to today's date? 