SUM all payments made in the last year
I'm trying to add up all the payments in a column that were made in the last 365 days from the current date. The date the payment was made is in a second column, formatted as a date column. I have written this formula:
=SUMIF([Payment 1 Paid Date]:[Payment 1 Paid Date], TODAY(@cell) >= TODAY(-365), [Payment 1]:[Payment 1])
Its returning INVALID DATA TYPE, so I'm guessing I'm using the wrong functions in the criterion - TODAY(@cell) >= TODAY(-365)
Help Article Resources
Check out the Formula Handbook template!