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?