Use TODAY() function as the criteria in a SUMIF formula

Discussion in 'Excel' started by P_Pohlhammer, Jul 17, 2018.

  1. P_Pohlhammer

    P_Pohlhammer

    Joined:
    Jul 17, 2018
    Messages:
    1
    Likes Received:
    0
    I want to sum numbers in a range of records based on whether the date in records is greater or less than TODAY(). When I use SUMIF(C4:C29,"<TODAY()",F4:F29) the returned value is 0. I think this is because the formula is looking for text, not a function. If I remove the quote marks the formula returns an error. Is there another function that will perform this task? Or is there a way to write this formula to return the values I'm looking for?
     
    P_Pohlhammer, Jul 17, 2018
    #1
    1. Advertisements

  2. P_Pohlhammer

    Becky Administrator

    Joined:
    Aug 3, 2011
    Messages:
    61
    Likes Received:
    5
    Instead of "<TODAY()" try "<"&TODAY() as your condition, hopefully that should do the trick :)
     
    Becky, Jul 17, 2018
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.