Send to a Friend

erniefernandez's avatar

What is wrong here? =SUMIFS(D2:D3,">(TODAY()-14)",(N2:N3))

Asked by erniefernandez (556points) 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

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.