Running total based upon current 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.
 
M

Mike H

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.
 
U

ucastores

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.
 
M

Mike H

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.
 
D

Don Guillett

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.
 
D

Don Guillett

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())))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top