I wish to make a formula that adds dollars in 1 column if a date .
=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
|