Running total based upon current date

  • Thread starter Thread starter ucastores
  • Start date Start date
U

ucastores

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.
 
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.
 
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.
 
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.
 
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.
 
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())))
 
Back
Top