Sumif / Sum and if???
 

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!

Sumif / Sum and if???
 

You were on the right track....

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

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

XL2002, WinXP


"Daniel Q." wrote:

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!

Sumif / Sum and if???
 

PERFECT!!! THX!

"Ron Coderre" wrote:

You were on the right track....

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

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

XL2002, WinXP


"Daniel Q." wrote:

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!

Sumif / Sum and if???
 

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

Hope this helps.

Pete

On Feb 9, 5:16 pm, Daniel Q.
wrote:
PERFECT!!! THX!



"Ron Coderre" wrote:
You were on the right track....

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

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

XL2002, WinXP

"Daniel Q." wrote:

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!- Hide quoted text -

- Show quoted text -