Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use the TODAY function with the SUMIF function?
How do I use the TODAY() formula in the SUMIF function?
I'm tracking training time and I want to sum only the hours completed, not the hours to be completed. Example: 1/2/2005 5 3/22/2005 3 10/9/2005 4 11/1/2005 5 8 I have tried =SUMIF(A2:A6,"TODAY()",B2:B7) and I have tried entering the TODAY function into another cell and referencing that cell in the SUMIF function (i.e =SUMIF(A2:A6,"E6",B2:B7). I cannot seem to find the correct way to make this work. Any help/advice would be greatly appreciated! Best, Lisa B. |
#2
|
|||
|
|||
You're Close...
=SUMIF(A2:A6,""&E6,B2:B7) -- Regards, Dave "Lisa B." wrote: How do I use the TODAY() formula in the SUMIF function? I'm tracking training time and I want to sum only the hours completed, not the hours to be completed. Example: 1/2/2005 5 3/22/2005 3 10/9/2005 4 11/1/2005 5 8 I have tried =SUMIF(A2:A6,"TODAY()",B2:B7) and I have tried entering the TODAY function into another cell and referencing that cell in the SUMIF function (i.e =SUMIF(A2:A6,"E6",B2:B7). I cannot seem to find the correct way to make this work. Any help/advice would be greatly appreciated! Best, Lisa B. |
#3
|
|||
|
|||
David,
You are my hero - thank you! Lisa B. "David Billigmeier" wrote: You're Close... =SUMIF(A2:A6,""&E6,B2:B7) -- Regards, Dave "Lisa B." wrote: How do I use the TODAY() formula in the SUMIF function? I'm tracking training time and I want to sum only the hours completed, not the hours to be completed. Example: 1/2/2005 5 3/22/2005 3 10/9/2005 4 11/1/2005 5 8 I have tried =SUMIF(A2:A6,"TODAY()",B2:B7) and I have tried entering the TODAY function into another cell and referencing that cell in the SUMIF function (i.e =SUMIF(A2:A6,"E6",B2:B7). I cannot seem to find the correct way to make this work. Any help/advice would be greatly appreciated! Best, Lisa B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Improve SUMIF function to sum more than one column | Excel Worksheet Functions | |||
Sumif function? | Excel Worksheet Functions | |||
Can SUMIF function include AND function | Excel Worksheet Functions | |||
Dynamic sumif function | Excel Worksheet Functions | |||
SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions |