+ Reply to Thread
Results 1 to 8 of 8

COunting percent of valuess appear in provided bracket ranges

  1. #1
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2007
    Posts
    107

    COunting percent of valuess appear in provided bracket ranges

    Hi Everyone!
    I have provided a data in excel in column A. In the next column I have defined certain braket ranges. I want to calculate percent of total values in Column A appearing in those specified bracket ranges.

    If you see screenshot and attachment excel file then you will easily get the problem.

    Thanks in advance.

    Excel Snapshot forum.PNG
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: COunting percent of valuess appear in provided bracket ranges

    And what happens if the profit is between 2000 and 3000??
    Glenn



  3. #3
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2007
    Posts
    107

    Re: COunting percent of valuess appear in provided bracket ranges

    Quote Originally Posted by Glenn Kennedy View Post
    And what happens if the profit is between 2000 and 3000??
    It should calculate the percent of values in column A in that bracket of 2000-3000.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: COunting percent of valuess appear in provided bracket ranges

    Quote Originally Posted by anonymous321 View Post
    It should calculate the percent of values in column A in that bracket of 2000-3000.
    There isn't one. See your sheet & jpg. I will add all the missing ones.

  5. #5
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2007
    Posts
    107

    Re: COunting percent of valuess appear in provided bracket ranges

    Sir, do you understand my question completely or am I missing something?

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: COunting percent of valuess appear in provided bracket ranges

    Possibly not. in your sheet and jpg, 2500 is ignored. There is NO 2000-3000 category. Also 500 is ignored. there is no 0-1000 band. Take a look at the sheet attached here... In F2, copied down:

    =COUNTIFS(A:A,">="&E2,A:A,"<"&E3)/(COUNTIF(A:A,"<>")-1)
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2007
    Posts
    107

    Re: COunting percent of valuess appear in provided bracket ranges

    Yes you are right, I missed some information at the time of posting. However you resolved the issue very nicely. Millions Thanks

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: COunting percent of valuess appear in provided bracket ranges

    You're welcome and thanks for the rep.

+ 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] Delete all except list of ranges provided for all worksheets
    By myurathan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-27-2019, 07:31 AM
  2. [SOLVED] Commission Percent based on Gross Margin Percent Formula
    By canselmi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2019, 07:05 PM
  3. Macro to generate excel file basis the row ranges provided
    By BenTenison in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2017, 08:42 AM
  4. Replies: 2
    Last Post: 07-18-2014, 03:00 AM
  5. [SOLVED] Counting Matching values in two separate ranges without counting duplicates
    By Rhall6310 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-01-2014, 03:35 PM
  6. Remove String Within the Bracket and also the Bracket
    By seanyeap in forum Excel General
    Replies: 6
    Last Post: 04-23-2010, 10:24 AM
  7. ASAP HELP NEEDED ranges for a tax bracket
    By ifstatement in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2006, 11:33 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