| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
