Closed Thread
Results 1 to 2 of 2

Cumulative Percentage Allocation Question on Excel 2010

  1. #1
    Registered User
    Join Date
    02-17-2015
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Cumulative Percentage Allocation Question on Excel 2010

    Hello, Im new to this forum because I need some big help on this project im working on. I also posted this on the General Forum (Mods if this is not allowed to post it twice please delete one of them)

    I have several projects going on and within those projects there are separate Sub-Projects that need to get done before the entire project to be complete.

    I know that I can use the sum function to add up the percentages in order to get "100%" in the Project completion.

    What Im trying to accomplish is setting the sub-projects as I finish them at 100% thus automatically inputting about a 12% completion on the total project.

    Only thing is one sub-project can account for 60% of the whole project while others may be like 15% and the other being the remaining 25%

    In the example below the Adwords Campaign: there are 3 sub projects: Marketo Landing Page (60%), UTM Coding is (15%), and Segmenting is the remaining (25%)

    Since "marketo landing page", and "utm coding" have been completed they are at 100% for the subproject. Culminating to 75% of the entire project, with the 25% remaining at 0% as we have not started.

    I manually input those numbers to give you an idea of what I want it to look like, but need help on the formular to use in order to make this work correctly. Thank you for your time in reading this long and probably a bit confusing post.

    Attachment 377952

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,018

    Re: Cumulative Percentage Allocation Question on Excel 2010

    I will close this 1 for you (we dont allow duplicate posts, so thanks for the heads-up )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cumulative Percentage Allocation Question on Excel 2010
    By ajvalles1 in forum Excel General
    Replies: 1
    Last Post: 02-18-2015, 10:20 AM
  2. Excel 2010 fails to release memory allocation
    By TACAMO in forum Excel General
    Replies: 3
    Last Post: 02-03-2014, 07:42 PM
  3. Excel 2010 - Project Day Allocation, Time Spent Calculation
    By craigj21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-27-2013, 07:20 AM
  4. [SOLVED] Percentage Allocation Formula not working
    By Shaun Gemiver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 05:14 AM
  5. [SOLVED] Re-Allocation of Percentage
    By Harlequin in forum Excel General
    Replies: 2
    Last Post: 07-04-2012, 06:31 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