I will try to explain this
I want to have a running total for C D F and G and use the numbers in A as a
filter
so if I filter the numbers = 33369 I want the totals of C D F G in other
cells on the sheet (ie L6,M6,N6,O6)
The data in A C D F G is entered maually
> In the data below I want to calculate the column C ,D, F ,G but filtered by
> Column A
> A C D F G
>
> 33369 04/06/10 2 10 04/06/10 2 3
> 33369 04/07/10 0 11 04/07/10 2 10
> 33369
> 23456
> 23456
> 789
>
> I have the total page on the same sheet L6 to O6
> Cheers!!!
>
|
|
0
|
|
|
|
Reply
|
 Utf
|
4/20/2010 1:11:01 AM |
|
Try the Subtotal feature;
http://www.ozgrid.com/Excel/subtotal.htm
--
Regards
Dave Hawley
www.ozgrid.com
"Norm" <Norm@discussions.microsoft.com> wrote in message
news:DC0420AF-155D-425A-958D-0A0CE4C96C17@microsoft.com...
>I will try to explain this
> I want to have a running total for C D F and G and use the numbers in A as
> a
> filter
> so if I filter the numbers = 33369 I want the totals of C D F G in other
> cells on the sheet (ie L6,M6,N6,O6)
> The data in A C D F G is entered maually
>
>
>> In the data below I want to calculate the column C ,D, F ,G but filtered
>> by
>> Column A
>> A C D
>> F G
>>
>> 33369 04/06/10 2 10 04/06/10 2 3
>> 33369 04/07/10 0 11 04/07/10 2 10
>> 33369
>> 23456
>> 23456
>> 789
>>
>> I have the total page on the same sheet L6 to O6
>> Cheers!!!
>>
>
|
|
|
0
|
|
|
|
Reply
|
ozgrid
|
4/20/2010 1:19:11 AM
|
|
I dont think I am explaining this right
In the total cells below I want the running total from Each column C, D, and
to keep updating as data is entered in C and D
A B C D
33369 03/30/10 2 5
33369 03/31/10 0 3
33369 04/03/10 2 3
33369 04/06/10 2 10
33369 04/07/10 0 11
So the total cells will look like this and will update as data is entered
in C and D
L M N
33369 6 32
13969 0 0
39210 0 0
34287 0 0
33035 0 0
"ozgrid.com" wrote:
> Try the Subtotal feature;
> http://www.ozgrid.com/Excel/subtotal.htm
>
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "Norm" <Norm@discussions.microsoft.com> wrote in message
> news:DC0420AF-155D-425A-958D-0A0CE4C96C17@microsoft.com...
> >I will try to explain this
> > I want to have a running total for C D F and G and use the numbers in A as
> > a
> > filter
> > so if I filter the numbers = 33369 I want the totals of C D F G in other
> > cells on the sheet (ie L6,M6,N6,O6)
> > The data in A C D F G is entered maually
> >
> >
> >> In the data below I want to calculate the column C ,D, F ,G but filtered
> >> by
> >> Column A
> >> A C D
> >> F G
> >>
> >> 33369 04/06/10 2 10 04/06/10 2 3
> >> 33369 04/07/10 0 11 04/07/10 2 10
> >> 33369
> >> 23456
> >> 23456
> >> 789
> >>
> >> I have the total page on the same sheet L6 to O6
> >> Cheers!!!
> >>
> >
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/20/2010 1:34:01 AM
|
|
I would do a Sumif. M1 would be:
M1: =sumif($A$1:$A$5,L1,$C$1:$C$5)
N1: =sumif($A$1:$A$5,L1,$D$1:$D$5)
Adjust ranges to suit. Drag the formulas down the column.
Regards,
Fred
"Norm" <Norm@discussions.microsoft.com> wrote in message
news:966BF4AD-ADC2-46B3-A6B1-886E9EB1D8AB@microsoft.com...
>I dont think I am explaining this right
> In the total cells below I want the running total from Each column C, D,
> and
> to keep updating as data is entered in C and D
> A B C D
> 33369 03/30/10 2 5
> 33369 03/31/10 0 3
> 33369 04/03/10 2 3
> 33369 04/06/10 2 10
> 33369 04/07/10 0 11
> So the total cells will look like this and will update as data is entered
> in C and D
> L M N
> 33369 6 32
> 13969 0 0
> 39210 0 0
> 34287 0 0
> 33035 0 0
>
>
> "ozgrid.com" wrote:
>
>> Try the Subtotal feature;
>> http://www.ozgrid.com/Excel/subtotal.htm
>>
>>
>>
>>
>> --
>> Regards
>> Dave Hawley
>> www.ozgrid.com
>> "Norm" <Norm@discussions.microsoft.com> wrote in message
>> news:DC0420AF-155D-425A-958D-0A0CE4C96C17@microsoft.com...
>> >I will try to explain this
>> > I want to have a running total for C D F and G and use the numbers in A
>> > as
>> > a
>> > filter
>> > so if I filter the numbers = 33369 I want the totals of C D F G in
>> > other
>> > cells on the sheet (ie L6,M6,N6,O6)
>> > The data in A C D F G is entered maually
>> >
>> >
>> >> In the data below I want to calculate the column C ,D, F ,G but
>> >> filtered
>> >> by
>> >> Column A
>> >> A C D
>> >> F G
>> >>
>> >> 33369 04/06/10 2 10 04/06/10 2 3
>> >> 33369 04/07/10 0 11 04/07/10 2 10
>> >> 33369
>> >> 23456
>> >> 23456
>> >> 789
>> >>
>> >> I have the total page on the same sheet L6 to O6
>> >> Cheers!!!
>> >>
>> >
>>
|
|
|
0
|
|
|
|
Reply
|
Fred
|
4/20/2010 3:44:08 AM
|
|
Thanks Fred,
I was having a hard time explaining this problem
Your solution was exactly what I needed
Thanks again
Cheers!!!
"Fred Smith" wrote:
> I would do a Sumif. M1 would be:
> M1: =sumif($A$1:$A$5,L1,$C$1:$C$5)
> N1: =sumif($A$1:$A$5,L1,$D$1:$D$5)
>
> Adjust ranges to suit. Drag the formulas down the column.
>
> Regards,
> Fred
>
> "Norm" <Norm@discussions.microsoft.com> wrote in message
> news:966BF4AD-ADC2-46B3-A6B1-886E9EB1D8AB@microsoft.com...
> >I dont think I am explaining this right
> > In the total cells below I want the running total from Each column C, D,
> > and
> > to keep updating as data is entered in C and D
> > A B C D
> > 33369 03/30/10 2 5
> > 33369 03/31/10 0 3
> > 33369 04/03/10 2 3
> > 33369 04/06/10 2 10
> > 33369 04/07/10 0 11
> > So the total cells will look like this and will update as data is entered
> > in C and D
> > L M N
> > 33369 6 32
> > 13969 0 0
> > 39210 0 0
> > 34287 0 0
> > 33035 0 0
> >
> >
> > "ozgrid.com" wrote:
> >
> >> Try the Subtotal feature;
> >> http://www.ozgrid.com/Excel/subtotal.htm
> >>
> >>
> >>
> >>
> >> --
> >> Regards
> >> Dave Hawley
> >> www.ozgrid.com
> >> "Norm" <Norm@discussions.microsoft.com> wrote in message
> >> news:DC0420AF-155D-425A-958D-0A0CE4C96C17@microsoft.com...
> >> >I will try to explain this
> >> > I want to have a running total for C D F and G and use the numbers in A
> >> > as
> >> > a
> >> > filter
> >> > so if I filter the numbers = 33369 I want the totals of C D F G in
> >> > other
> >> > cells on the sheet (ie L6,M6,N6,O6)
> >> > The data in A C D F G is entered maually
> >> >
> >> >
> >> >> In the data below I want to calculate the column C ,D, F ,G but
> >> >> filtered
> >> >> by
> >> >> Column A
> >> >> A C D
> >> >> F G
> >> >>
> >> >> 33369 04/06/10 2 10 04/06/10 2 3
> >> >> 33369 04/07/10 0 11 04/07/10 2 10
> >> >> 33369
> >> >> 23456
> >> >> 23456
> >> >> 789
> >> >>
> >> >> I have the total page on the same sheet L6 to O6
> >> >> Cheers!!!
> >> >>
> >> >
> >>
>
> .
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/20/2010 2:35:01 PM
|
|
You're welcome. Thanks for the feedback.
Fred.
"Norm" <Norm@discussions.microsoft.com> wrote in message
news:13BC3D19-8CBF-43D0-95D7-89716062A7C9@microsoft.com...
> Thanks Fred,
> I was having a hard time explaining this problem
> Your solution was exactly what I needed
> Thanks again
> Cheers!!!
>
> "Fred Smith" wrote:
>
>> I would do a Sumif. M1 would be:
>> M1: =sumif($A$1:$A$5,L1,$C$1:$C$5)
>> N1: =sumif($A$1:$A$5,L1,$D$1:$D$5)
>>
>> Adjust ranges to suit. Drag the formulas down the column.
>>
>> Regards,
>> Fred
>>
>> "Norm" <Norm@discussions.microsoft.com> wrote in message
>> news:966BF4AD-ADC2-46B3-A6B1-886E9EB1D8AB@microsoft.com...
>> >I dont think I am explaining this right
>> > In the total cells below I want the running total from Each column C,
>> > D,
>> > and
>> > to keep updating as data is entered in C and D
>> > A B C D
>> > 33369 03/30/10 2 5
>> > 33369 03/31/10 0 3
>> > 33369 04/03/10 2 3
>> > 33369 04/06/10 2 10
>> > 33369 04/07/10 0 11
>> > So the total cells will look like this and will update as data is
>> > entered
>> > in C and D
>> > L M N
>> > 33369 6 32
>> > 13969 0 0
>> > 39210 0 0
>> > 34287 0 0
>> > 33035 0 0
>> >
>> >
>> > "ozgrid.com" wrote:
>> >
>> >> Try the Subtotal feature;
>> >> http://www.ozgrid.com/Excel/subtotal.htm
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> Regards
>> >> Dave Hawley
>> >> www.ozgrid.com
>> >> "Norm" <Norm@discussions.microsoft.com> wrote in message
>> >> news:DC0420AF-155D-425A-958D-0A0CE4C96C17@microsoft.com...
>> >> >I will try to explain this
>> >> > I want to have a running total for C D F and G and use the numbers
>> >> > in A
>> >> > as
>> >> > a
>> >> > filter
>> >> > so if I filter the numbers = 33369 I want the totals of C D F G in
>> >> > other
>> >> > cells on the sheet (ie L6,M6,N6,O6)
>> >> > The data in A C D F G is entered maually
>> >> >
>> >> >
>> >> >> In the data below I want to calculate the column C ,D, F ,G but
>> >> >> filtered
>> >> >> by
>> >> >> Column A
>> >> >> A C D
>> >> >> F G
>> >> >>
>> >> >> 33369 04/06/10 2 10 04/06/10 2 3
>> >> >> 33369 04/07/10 0 11 04/07/10 2 10
>> >> >> 33369
>> >> >> 23456
>> >> >> 23456
>> >> >> 789
>> >> >>
>> >> >> I have the total page on the same sheet L6 to O6
>> >> >> Cheers!!!
>> >> >>
>> >> >
>> >>
>>
>> .
>>
|
|
|
0
|
|
|
|
Reply
|
Fred
|
4/20/2010 3:58:02 PM
|
|
|
5 Replies
260 Views
(page loaded in 0.155 seconds)
|
Search |
Post Question |
Groups |
Stream |
About |
Register
79177 articles. 
66 followers. 