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 :)
 

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

Excel - Wich Function should I use? 1
Use a variable in a ShapeRange.Increment 0
Autonumber field in Excel that behaves the same as Access 0
Lookup Function Help 1
Problem with SET & REF function 0
Calculate the median value before a specified list 0
Folder structure in teams channel. 0
SUMIF with criteria "<>" & "=" 4

Top