mainelytrusses
asked on
add data within the rolling last 365 days
I want to sum a column if the data in that column occurred within the past 365 day period, based on a date column
Try this formula:
=SUMPRODUCT(((A1:A5)>TODAY ()-365)*(B 1:B5))
Please check the attached example.
jppinto
SUMPRODUCT-LAST-YEAR.xlsx
=SUMPRODUCT(((A1:A5)>TODAY
Please check the attached example.
jppinto
SUMPRODUCT-LAST-YEAR.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your prompt answer.
Didn't you like my formula?!? Wasn't it working?!?
=SUMIF(A:A,">="&TODAY()-36
regards, barry