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


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?
 
Ad

Advertisements

Becky

Administrator
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

Sum data using sumif 3
Sumif using partial string 7
Sumif does not work 2
Combine Sumifs with Subtotal 0

Top