+ Reply to Thread
Results 1 to 7 of 7

Excel formula assistance

  1. 10-09-2021, 10:23 PM #1
    mgroms
    mgroms is offline
    Registered User
    Join Date
    10-09-2021
    Location
    Canada
    MS-Off Ver
    office365
    Posts
    6

    Excel formula assistance

    I am planning to derive an answer in percentage in excel by using excel formula. Basically, I am trying to select a specific number from a cell, then add that specific number and then divide to get percentage.

    For example -

    In the excel sheet from total 5 cells - if Cell A1 has 100, Cell A2 has 100, Cell A5 has 100 - then select those 3 numbers from A1, A2, A5 and add them (100 + 100 + 100 = 300) then divide 5 and take that answer as percentage & in this case - 300 / 5 = 60

    Can you share a formula by using select or another manner. Thank for your assistance.
    Reply With QuoteRegister To Reply
  2. 10-09-2021, 10:56 PM #2
    TMS
    TMS is online now
    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
    44,374

    Re: Excel formula assistance

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    formatted as a percentage = 60.00%
    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

    Reply With QuoteRegister To Reply
  3. 10-09-2021, 11:17 PM #3
    mgroms
    mgroms is offline
    Registered User
    Join Date
    10-09-2021
    Location
    Canada
    MS-Off Ver
    office365
    Posts
    6

    Re: Excel formula assistance

    Thanks TMS, there may be other numbers in A3 & A4. I wanted to use a formula to automatically pick the number 100 weather its in A1 or A3 or A4 (instead of manually entering that cell numbers) & add those numbers and divide by 5...
    Reply With QuoteRegister To Reply
  4. 10-09-2021, 11:54 PM #4
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Excel formula assistance

    is this what you want...?
    =(COUNTIF(A1:A5,100)*100/COUNTA(A1:A5))/100
    or this...?
    =(COUNTIF(A1:A5,100)*100/COUNT(A1:A5))/100
    or this...?
    =(COUNTIF(A1:A5,100)*100/5)/100

    then format as percent.
    Last edited by Sam Capricci; 10-10-2021 at 12:08 AM.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  5. 10-10-2021, 12:28 AM #5
    mgroms
    mgroms is offline
    Registered User
    Join Date
    10-09-2021
    Location
    Canada
    MS-Off Ver
    office365
    Posts
    6

    Re: Excel formula assistance

    Thanks Sam...this one helped as well - =SUMIF(P7:P12,H15,P7:P12)/5/100
    Reply With QuoteRegister To Reply
  6. 10-10-2021, 01:39 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Excel formula assistance

    Please review the forum rule about titles before you post here again. This thread title was not detailed enough. Almost everyone here wants help with a formula!

    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 all those who offered help.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  7. 10-10-2021, 01:55 AM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Excel formula assistance

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. I will do this for you today, as you are new here: https://www.excelguru.ca/forums/show...ula-assistance)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. excel formula assistance
    By platinumaa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2019, 10:31 PM
  2. Excel formula - need assistance with challenging formula or table
    By m masi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-05-2017, 08:19 AM
  3. excel formula assistance
    By LisaCon69 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2013, 02:10 AM
  4. Excel Formula Assistance
    By Carlosthejackal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-04-2012, 11:25 AM
  5. [SOLVED] I was looking to get assistance with a formula in Excel 2002
    By cashman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-21-2006, 09:20 AM
  6. Excel Formula assistance
    By mauddib13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2006, 11:30 PM
  7. I need assistance with wrting an Excel formula
    By mdavis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2005, 02:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1