Results 1 to 3 of 3

Sum of year dependant on start month

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    17

    Sum of year dependant on start month

    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
    Attached Files Attached Files
    Last edited by scooterboygnu; 09-26-2011 at 12:16 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1