• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 434
  • Last Modified:

SUM 12 months of data not in chrono order Excel 2010

Referencing attached...I need to sum the values in column for the 12 months starting with the MOST RECENT ENTRY (in this case Jul, 2013 - August 2012). The values will be scattered, not in chrono order. The most recent date may not be the first one encountered. So I'll need to check to find the most recent date, use it as month 1 and then sum the values from month 1 through 12.

The day of the month isn't important so column K could be used to check the date.

Need it in a formula. Any suggestions?

(I'll also need to sum the values for months 13-24 but I can probably tackle that if I can get the formula for months 1-12.)
1 Solution
barry houdiniCommented:
You could use this formula for the last 12 months


If the max date is 7th July 2013, for example, then that will sum from August 1st 2012 onwards (assumes data in rows 2 to 100, adjust as required)

To get months 13 to 24 just subtract that figure from the figure for the last 24 months, e.g. assume above formula is in cell P2 then use this version in another cell


regards, barry
author3000Author Commented:
Works better than a snake charmer with a magic wand.

Thank you!
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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