Sumif / Sum and if???

D

Daniel Q.

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!
 
R

Ron Coderre

You were on the right track....

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

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

XL2002, WinXP
 
D

Daniel Q.

PERFECT!!! THX!

Ron Coderre said:
You were on the right track....

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

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

XL2002, WinXP
Click to expand...
 
P

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
 
Top