calculation help
in [General]
|
From: Fred Smith on 20 Apr 2010 11:58 You're welcome. Thanks for the feedback. Fred. "Norm" <Norm(a)discussions.microsoft.com> wrote in message news:13BC3D19-8CBF-43D0-95D7-89716062A7C9(a)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(a)discussions.microsoft.com> wrote in message >> news:966BF4AD-ADC2-46B3-A6B1-886E9EB1D8AB(a)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(a)discussions.microsoft.com> wrote in message >> >> news:DC0420AF-155D-425A-958D-0A0CE4C96C17(a)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!!! >> >> >> >> >> > >> >> >> >> . >> |