Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

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
0
mainelytrusses
Asked:
mainelytrusses
  • 2
  • 2
1 Solution
 
barry houdiniCommented:
Try SUMIF, e.g. with data in column A

=SUMIF(A:A,">="&TODAY()-365)

regards, barry
0
 
jppintoCommented:
Try this formula:

=SUMPRODUCT(((A1:A5)>TODAY()-365)*(B1:B5))

Please check the attached example.

jppinto
SUMPRODUCT-LAST-YEAR.xlsx
0
 
barry houdiniCommented:
Sorry. you need a sin range - with dates in A and amounts in B

=SUMIF(A:A,">="&TODAY()-365,B:B)

regards, barry
0
 
mainelytrussesAuthor Commented:
Thank you for your prompt answer.
0
 
jppintoCommented:
Didn't you like my formula?!? Wasn't it working?!?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now