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?