SUMIF a date is equal to or less than today
I have made this work in other formulas by entering dates manually eg "<=x/xx/xxxx". How do I achieve the above? Thank you for your responses.
Question marked as
Top-ranking reply
You only have the one condition so you could use SUMIF instead of SUMIFS, but either will work.
The condition should be "<="&TODAY()
It probably does not matter in your spreadsheet but note that "TODAY" = today at 12:00AM. 7/16/23 is <=TODAY because it is given the default time of 12:00AM but 7/16/23 12:00:01 AM is not.