+ Reply to Thread
Results 1 to 3 of 3

Allocate amounts accross a spread of months

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Excel 2020
    Posts
    308

    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.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Allocate amounts accross a spread of months

    Try this formula in cell I2 and copy it across the table:
    Please Login or Register  to view this content.
    hope this helps
    Last edited by p24leclerc; 10-19-2014 at 08:57 PM.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Excel 2020
    Posts
    308

    Re: Allocate amounts accross a spread of months

    Working fine, thanks for the help.

+ Reply to Thread

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