+ Reply to Thread
Results 1 to 3 of 3

Calculating the Percentage of Cells in a Range that Contain a Specified Stri

  1. #1
    Aaron
    Guest

    Calculating the Percentage of Cells in a Range that Contain a Specified Stri

    i am sort of new to Excel, and im planning on using that formula for some spread sheets i am creating. However, what is the reason for the ,B1? i dont understand what each string in columb b means.

  2. #2
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Calculating the Percentage of Cells in a Range that Contain a Specified String

    Problem:

    We want to create a formula that searches List1 (cells A2:A9) for each string in column B and returns the percentage of cells containing that string.

    Solution:

    Use the COUNTIF and COUNTA functions in the following formula, and then apply percentage formatting to the cells:
    =COUNTIF($A$2:$A$9,B2)/COUNTA($A$2:$A$9)

  3. #3
    Registered User
    Join Date
    06-02-2007
    Posts
    1

    ,b2?

    what i want to do is use this formula or alter this formula to help me out. I want it to give me a % of say one word through one column on all of my work sheet..i guess what im trying to ask is what is a string?

+ 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