+ Reply to Thread
Results 1 to 6 of 6

Percentage formula for specified values

  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Percentage formula for specified values

    Hello
    Can somebody help with a formula for the below?

    I have the following information, and want to calculate the percentage complete based on a value in column a.

    So column a contains a task number, and column I contains the percentage complete for the task:
    1 20%
    2 10%
    1 5%
    1 100%
    3 50%
    2 25%
    4 9%

    I want a formula in a different sheet to provide the total percentage complete for each task. So, where column A = 1, bring back a percentage (so adding up all percentages for every "1" task and dividing by the number of "1" tasks.

    Hope that makes sense.
    Thanks in advance....
    Last edited by caitfox; 05-27-2011 at 09:59 AM.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Percentage formula for specified values

    Did you try the SUMIF() function?

    http://www.excelfunctions.net/ExcelSumif.html

  3. #3
    Registered User
    Join Date
    05-26-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Percentage formula for specified values

    Yes... 2 sumif statements do the job.
    Thanks. Looking at it after a break was clearly the way forward!

  4. #4
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Percentage formula for specified values

    Is this what you are looking for - look at the attachment.

    Please Login or Register  to view this content.
    Confirm with CTRL Shift Enter
    Attached Files Attached Files

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Percentage formula for specified values

    @day92
    AVERAGEIF() would be preferable to CSE formula
    =AVERAGEIF($A$1:$A$12,E1,$B$1:$B$12)

    The OP's request
    Please Login or Register  to view this content.
    made it sound like SUMIF() was what was needed but could also be AVERAGEIF() going by the
    Please Login or Register  to view this content.
    but then the OP adds
    Please Login or Register  to view this content.
    so I don't know what that would be doing.
    Anyway - it seems the OP has resolved it.

  6. #6
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Percentage formula for specified values

    Cutter thanks for the clarification. My post came after the OP response.

    Glad its solved.

+ Reply to Thread

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