What is wrong here? =SUMIFS(D2:D3,">(TODAY()-14)",(N2:N3))
I am trying to do a SUMIF, where if the value in the D column is greater than TODAY – 14 days, it SUMS the values in the N column. But I can’t get it to work.
The purpose is to add up all the $s in N if the date in D is more than 14 days past. This value will be the total Holds we have for reimbursement liabilitie; after 2 weeks, they expire, and should not be included in the total Hold amount.
This question is in the General Section. Responses must be helpful and on-topic.