Sum of year dependant on start month

[scooterboygnu]

Hi All,

I have a problem with a formula and don't know where to start. I have a spreadsheet with 12 months of data for 2012 for many differennt Orgs.

I need to be able to sum up the total for an "Org" for 2012 but dependant on when the agreement starts.

e.g.

If an agreement starts OCT 2011 and lasts for 12 months in would only need to get the total for that ORG for the period JAN 2012 - OCT 2012 as I only need the amounts impacting 2012.

I have attached a spreadsheet which hopefully wxplains better.

As always many thanks in advance for anyone who can help

[zbor]

Maybe this:

[scooterboygnu]

Hi Zbor,

Many thanks for this its almost perfect. The only extra bit I need is if the start date is June 2012 I will need the sum from June 2012 to Dec 2012. Or if Start date was Mar 2012 i need the sum of Mar 2012to Dec 2012. What you have given me works perfectly if calculating always from Jan.

Again thanks for the help and appreciate it if you can help further,