Send to a Friend
What is wrong here? =SUMIFS(D2:D3,">(TODAY()-14)",(N2:N3))
Asked by erniefernandez (556)
September 20th, 2013
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.
Haaaaaalp!
Using Fluther
or