MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### calculation help

• Follow

```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)

8/19/2012 5:01:28 PM

 Reply: