I need a formula that adds only the rows in a a column if the column next to
it (dates) are at least a day behind today

D E F
1 2/1 600
2 2/2 600
3 2/3 600
4 2/4 600

i started out with sumif(D1:D4,"now()-1",D1:D4) but i guess that was a
little too simple to work.


Please help!