Sumif / Sum and if???

[Guest]

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(D14,"now()-1",D14) but i guess that was a
little too simple to work.


Please help!

 

[Guest]

You were on the right track....

Try this:
=SUMIF(A1:A4,"<"&TODAY()-1,D14)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

PERFECT!!! THX!

You were on the right track....

Try this:
=SUMIF(A1:A4,"<"&TODAY()-1,D14)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Pete_UK]

NOW() returns date and time, whereas TODAY() returns date only - with
times involved you would not have had exact matches.

Hope this helps.

Pete