Running total based upon current date
in [Functions]
|
From: ucastores on 10 Apr 2010 09:05 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.
From: Mike H on 10 Apr 2010 09:09 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.
From: ucastores on 10 Apr 2010 09:24 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.
From: Mike H on 10 Apr 2010 09:31 Hi, With the obvious changes M dot L dot hughes at virginmedia dot com -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "ucastores" wrote: > 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.
From: Don Guillett on 10 Apr 2010 09:35
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. |