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

"Don Guillett" wrote in message
...
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

"ucastores" wrote in message
...
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.