Results 1 to 3 of 3

Allocate amounts accross a spread of months

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Allocate amounts accross a spread of months

    HI
    I'm hoping someone can provide me with a formula that spreads allocated hours across the allocated months as per the attached spreadsheet.
    In summary, if my date range is January to October and the number allocated is 100, then I need a total of 10 to appear in each month from Jan to Oct.
    But if the range is only one month, then the total would only appear in that month's data.
    thanks
    Attached Files Attached Files
    Last edited by Christopherdj; 10-19-2014 at 09:02 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Allocate monthly pay across months.
    By faithnfaith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2013, 12:47 AM
  2. [SOLVED] Summarise data accross months
    By appolo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-02-2013, 05:46 PM
  3. [SOLVED] Allocate months across periods in which they fall?
    By maladrat in forum Excel General
    Replies: 9
    Last Post: 07-26-2012, 01:21 PM
  4. Macro to allocate amounts to different period
    By raj8000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2009, 03:00 PM
  5. need to share value accross months in excel
    By cu525 in forum Excel General
    Replies: 5
    Last Post: 11-04-2008, 06:05 AM

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