+ Reply to Thread
Results 1 to 5 of 5

Calculating percentages

  1. #1
    Registered User
    Join Date
    10-11-2007
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20806) 64-bit
    Posts
    30

    Calculating percentages

    In the attached file, I am trying to calculate the percentage of the sum of items in column a by dividing it by the sum of all cells in columns/cells a1-c3. Obviously the formula that I am using in cell e3 is incorrect. I know that the correct percentage should be 40%. Can someone please help; I am at a loss at this point.

    By the way, I posted this question incorrectly previously. I thought I was having a problem uploading the file but wasn't.

    V/r

    Greg Wade
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,391

    Re: Calculating percentages

    Without a solid explanation of how one should perform the calculation, it is difficult to help find the programming solution. That said, here's my guess:

    1) Understanding "percentage" formulas is all about figuring out what belongs in the numerator and what belongs in the denominator. I notice that your denominator in E1 is SUM(A1:C3). Entering that into another cell, I see that SUM(A1:C3) is 30.
    2) You say that the correct result should be 40%. Multiply 30 by 0.4 in a convenient cell, and I see that 40% of 30 is 12. So, I guess that I want the numerator in my percentage calculation to be 12. Who knows how many different ways there are to combine those 9 numbers to get a value of 12 -- especially if other operations (like dividing some values by 2) are also allowed. That said, following the pattern I see in the formula in E1, I notice that SUM(A1:A3) is 10, SUM(C1:C3)/2 is 2, and 10+2 would be 12. Is the solution to your question as simple, then, as adding a pair of parentheses to the formula in E1 so that it adds 10+2 before dividing by the overall total? =(SUM(C1:C3)/2+SUM(A1:A3))/SUM(A1:C3)
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,246

    Re: Calculating percentages

    More brackets:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    10-11-2007
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20806) 64-bit
    Posts
    30

    Re: Calculating percentages

    Thank you! Yes, it was as simple as adding a couple of parentheses. I was not aware that you could add a parentheses before a formula command.

    V/r

    Greg Wade

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,246

    Re: Calculating percentages

    You're welcome.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. [SOLVED] Calculating percentages
    By dumbguy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-11-2016, 05:41 AM
  2. [SOLVED] Calculating Percentages
    By Jennifer2010 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-15-2015, 04:23 PM
  3. calculating percentages
    By baileybydesign in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 05-28-2010, 10:15 PM
  4. Excel 2007 : Calculating Percentages
    By Rmannon in forum Excel General
    Replies: 9
    Last Post: 04-29-2010, 02:24 PM
  5. [SOLVED] Calculating percentages
    By Yari in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-30-2005, 03:38 PM
  6. [SOLVED] calculating percentages
    By Louise in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2005, 02:05 PM
  7. Calculating Percentages
    By tifosi3 in forum Excel General
    Replies: 7
    Last Post: 07-11-2005, 04:05 PM

Tags for this Thread

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