|
| 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
April 20th, 2010, 02:11 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
calculation help
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!!! 
|
|
#2
April 20th, 2010, 02:19 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation help
Try the Subtotal feature;
http://www.ozgrid.com/Excel/subtotal.htm -- Regards Dave Hawley www.ozgrid.com "Norm" wrote in message news  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!!!
|
|
#3
April 20th, 2010, 02:34 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation help
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" wrote in message news 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!!!
|
|
#4
April 20th, 2010, 04:44 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation help
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" wrote in message ... 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" wrote in message news 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!!!
|
|
#5
April 20th, 2010, 03:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation help
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" wrote in message ... 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" wrote in message news
I will try to explain thisI 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!!! .
|
|
#6
April 20th, 2010, 04:58 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation help
You're welcome. Thanks for the feedback.
Fred. "Norm" wrote in message ... 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" wrote in message ... 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" wrote in message news
I will try to explain thisI 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!!! .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
