Prev: How do I get drop-down list that includes, eg top10
Next: Monday closest to today's date?
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:f92ce723-224c-4aff-99de-31a77f17561(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:f92ce723-224c-4aff-99de-31a77f17561(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:15d35bb6-d9ac-42ce-b02c-bbe3cf23c1c9(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:f92ce723-224c-4aff-99de-31a77f17561(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 drop-down list that includes, eg top10
Next: Monday closest to today's date?