+ Reply to Thread
Results 1 to 4 of 4

Calculate percentage of open items

  1. #1
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Calculate percentage of open items

    Hi,
    I have problem in my excel formula.
    I have here the data, in which i need to calculate the percentage of open requests.

    Completed request: 34
    Pending: 13
    Overall request received: 47

    can someone help me? Thanks

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Calculate percentage of open items

    Suppose your data a2 is 34, b2 is 13 & c2 is 47
    in "D2" =SUM(B2*100)/C2
    or =SUM(B2)/C2%
    format as percentage.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,930

    Re: Calculate percentage of open items

    (Completed requests * 100) / requests received, the result will be 72.34%
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Calculate percentage of open items

    =SUM(A2*100)/C2
    Or
    =SUM(A2/C2%

+ 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. Formula for percentage for under delivery of items
    By Deepi84 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2019, 12:05 PM
  2. Deducting percentage, calculate what percentage needs to be added to reverse
    By HereComesTheBoom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2019, 05:47 AM
  3. distribution of percentage if 2 items deleted
    By senjuti.sarkar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-16-2014, 06:39 AM
  4. Finding weekly percentage of items
    By marielouise1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-04-2014, 12:52 PM
  5. percentage:how do I calculate the percentage change
    By Knowledge001 in forum Excel General
    Replies: 3
    Last Post: 11-25-2005, 02:40 PM
  6. calculating 10 percentage of items in a column
    By ysymon in forum Excel General
    Replies: 2
    Last Post: 08-24-2005, 12:05 PM

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