I wish to make a formula that adds dollars in 1 column if a date range is
satisfied in a second column. This is the formula I came up with but it
doesn't return the correct answer. Can any one help me with a correction?
--
D. W. Cameron

=SUMPRODUCT(--(A2:A20=--"2005-10-01"),--(A2:A20<=--"2005-10-30"),B2:B20)

where the dates are in A, amounts in B

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Wayne Cameron" wrote in message
...
I wish to make a formula that adds dollars in 1 column if a date range is
satisfied in a second column. This is the formula I came up with but it
doesn't return the correct answer. Can any one help me with a correction?
--
D. W. Cameron

I don't see your formula, Wayne, but something like this?

=If(a2$G$1,b2+1,a2)
That will add 1 to the value in B2 if the date in A2 is greater than a date
in G1 (you can change the date in G1 or pur =NOW() to make G1 have today's
date in it). If the date in G1 is before today, then the value comes over
without the extra $1.
This may help:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Wayne Cameron" wrote in message
...
I wish to make a formula that adds dollars in 1 column if a date range is
satisfied in a second column. This is the formula I came up with but it
doesn't return the correct answer. Can any one help me with a correction?
--
D. W. Cameron