I wish to make a formula that adds dollars in 1 column if a date .

[Guest]

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?

 

[Bob Phillips]

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

 

[Anne Troy]

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/if_statements_in_formulas_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com