How do I add items within the last 12 months?
Assuming that Column A contains the date, and Column B contains the
numbers, try...
=SUMIF(A1:A100,"="&TODAY()-365,B1:B100)
Hope this helps!
In article ,
"Kevbro7189" wrote:
I want to add up numbers that only happened within the last 12 months from
the current date. I do have a column with the date I want to reference to.
|