How do I use the TODAY function with the SUMIF function?

L

Lisa B.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Excel - Wich Function should I use? 1
SUMIF function 3
SumIf conditional to date range 5
=sumif function 1
Using the TODAY() function in a SUMIF function 4
SUMIF Function 3
How to Control a formula by a character in adjacent column on same 4

Top