Running total based upon current date
in [Functions]
|
From: Don Guillett on 10 Apr 2010 11:48 To get the sum for 2011 for the 1st one for both rows. If this is what you want? =SUM(A8:OFFSET(A8,1,MONTH(TODAY()))) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Don Guillett" <dguillett1(a)gmail.com> wrote in message news:uMGuyKL2KHA.6048(a)TK2MSFTNGP06.phx.gbl... > If mike is not avail > > If desired, send your file to my address below. I will only look if: > 1. You send a copy of this message on an inserted sheet > 2. You give me the newsgroup and the subject line > 3. You send a clear explanation of what you want > 4. You send before/after examples and expected results. > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "ucastores" <ucastores(a)discussions.microsoft.com> wrote in message > news:CA4CE3F0-A074-47D8-A4AD-01651A0DC5B0(a)microsoft.com... >> Mike, being the usual slow thinking person i can sometimes be, i think a >> left >> an important bit of info out. ... can i send you a copy that work >> sheet? >> The columns are titled with the months of the year and those that are in >> the >> future i don't want included but the ones that have passed i do. >> >> "Mike H" wrote: >> >>> Hi, >>> >>> Change the ranges to suit >>> >>> =SUMPRODUCT((A1:A20<>"")*(A1:A20<=TODAY())*(B1:B20)) >>> >>> -- >>> Mike >>> >>> When competing hypotheses are otherwise equal, adopt the hypothesis that >>> introduces the fewest assumptions while still sufficiently answering the >>> question. >>> >>> >>> "ucastores" wrote: >>> >>> > I have cells with dollar values from formulas and i am trying to place >>> > the >>> > total of all those values in another cell based upon the current date >>> > backwards. An IF gives me a #name result. I know i am not using the >>> > Date >>> > command properly, but i can't figure out how to do it. can anyone >>> > help me? >>> > I used =IF(Date<=TODAY, sum(. ... Or is there a better way to do it? >>> > What >>> > i want is if the date is today or inthe past to add the dollar values >>> > in the >>> > cells, but not the ones that are in the future. > |