Send to a Friend

erniefernandez's avatar

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.

Haaaaaalp!

Topics: , ,

Using Fluther

or

Using Email

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

Mobile | Desktop


Send Feedback   

`