=SUMPRODUCT(--(B1:B1000=TODAY()),(B1:B1000<=TODAY()+30),A1:A100 0)

--

HTH

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


"Toni G." wrote in message
om...
I am trying to add a column (Col. A) based on a date (Col. B). I want
to add Col. A if Col. B is within the next 30 days of today's date
(which I've put in Col. C). The formula I've tried is: SUMIF(A,"BC
AND B<=C") but it doesn't work. Any ideas about what I'm doing wrong?