+ Reply to Thread
Results 1 to 7 of 7

Excel formula assistance

  1. #1
    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.

  2. #2
    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
    35,980

    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 - Excel Aid

    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


  3. #3
    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...

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,536

    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

  5. #5
    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

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,285

    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" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,285

    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 to 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. [SOLVED] 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1