| Home |
| Search |
| Today's Posts |
|
#1
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
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 ... 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
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 ... 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
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 ... 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
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 ... 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!!! . |
|
#6
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 ... 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!!! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation using IF | Excel Worksheet Functions | |||
| Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
| Really need calculation help | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
