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

P

P_Pohlhammer

Joined
Jul 17, 2018
Messages
1
Reaction score
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?
 
Becky

Becky

Joined
Aug 3, 2011
Messages
70
Reaction score
6
Instead of "<TODAY()" try "<"&TODAY() as your condition, hopefully that should do the trick :)
 
Top