How do I use the TODAY function with the SUMIF function? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Lisa B. 9/30/2005 12:37 PM PST
  Question
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
David Billigmeier 9/30/2005 12:42 PM PST
  Answer
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Lisa B. 9/30/2005 12:50 PM PST
   
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies