+ Reply to Thread
Results 1 to 3 of 3

Percentage of cells containing X?

  1. #1
    Registered User
    Join Date
    12-21-2010
    Location
    Leicester, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Percentage of cells containing X?

    I would like a formular to work out what percentage of cells in a range have a certain contents. the contents of the cells is preferably letters (eg 'H') as it makes assesing the information at a glance easier than numbers.

    So i want a cell to show what percentage of a range contain H. If it helps the percentage value of each cell in each range is 0.45%

    Cells in the range could have a variety of letters, but only one for each cell.

    I'm Guessing it should start with 'countif', but my formula of =COUNTIF(B10:F19,"H") isn't adding up until after i re-open the file which is a problem as the user needs to be aware if the percentage goes too high as the information is added (I plan to use conditional formatting to change the background colour of the cell) is there a way to instantly calculate changes to the range, and automatically work out the percentage?

    Any help on whether this is possible is much appreciated.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Percentage of cells containing X?

    Hi and welcome to the board

    Please Login or Register  to view this content.
    should do the trick without necessity to reopen.( it calculates the % of"h" with relation to all non empty cells of the range)

    Is your calculation set to "automatic" ? (see Tools - Options)
    Last edited by arthurbr; 12-21-2010 at 08:00 AM.

  3. #3
    Registered User
    Join Date
    12-21-2010
    Location
    Leicester, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Percentage of cells containing X?

    Quote Originally Posted by arthurbr View Post
    Hi and welcome to the board

    Please Login or Register  to view this content.
    should do the trick without necessity to reopen.( it calculates the % of"h" with relation to all non empty cells of the range)

    Is your calculation set to "automatic" ? (see Tools - Options)

    Thanks for your help, unfortunately i'm getting a devide by zero error.

    No worries i'v changed it to devide by a fixed number as i know the number of cells, and formatted to display as a percentage.
    Calculations were set to manual, should have checked that, sorry.
    Last edited by Feriol; 12-22-2010 at 08:22 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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