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.


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

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.

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.

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.

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.