+ Reply to Thread
Results 1 to 3 of 3

Count Range Of Cells That Contain Text That Includes Numbers And Letters

  1. #1
    Registered User
    Join Date
    08-09-2015
    Location
    Toronto
    MS-Off Ver
    Microsoft Office 2007
    Posts
    23

    Count Range Of Cells That Contain Text That Includes Numbers And Letters

    Hello All,

    Thanks in advance for your help.

    A few weeks ago I posted several requests regarding help with counting cells with many criteria - I did have some success with a user helping me with a code to help count these particular cells and it worked -for a bit.

    I'm back again with a much simpler issue. It's in a few parts.

    PART 1

    I would like to count the cells within a range. The cells in that range are all text, some cells are blank.

    I would like to count the cells that ONLY contain numbers and/or numbers with letters in it. I do not want to count blank cells or cells with ONLY letters in them.

    PART 2

    I would like to count the cells within a range. The cells in that range are all text, some cells are blank.

    I would like to count the cells that ONLY contain numbers and the letters BB in it. I do not want to count blank cells or cells with any other numbers or letters in them.

    PART 3

    I would like to count the cells within a range. The cells in that range are all text, some cells are blank.

    I would like to count the cells that ONLY contain numbers and the letters BR in it. I do not want to count blank cells or cells with any other numbers or letters in them.

    PART 4

    I would like to count the cells within a range. The cells in that range are all text, some cells are blank.

    I would like to count the cells that ONLY contain numbers and the letters BS in it. I do not want to count blank cells or cells with any other numbers or letters in them.

    PART 5

    I would like to count the cells within a range. The cells in that range are all text, some cells are blank.

    I would like to count the cells that ONLY contain numbers and the letters FR in it. I do not want to count blank cells or cells with any other numbers or letters in them.

    PART 6

    I would like to count the cells within a range. The cells in that range are all text, some cells are blank.

    I would like to count the cells that ONLY contain numbers and the letters BS in it. I do not want to count blank cells or cells with any other numbers or letters in them.

    Thanks In Advance!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Count Range Of Cells That Contain Text That Includes Numbers And Letters

    What range of cells are you looking at (I don;t fancy trawling throught all that data to find BR BS etc...) ?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    08-09-2015
    Location
    Toronto
    MS-Off Ver
    Microsoft Office 2007
    Posts
    23

    Re: Count Range Of Cells That Contain Text That Includes Numbers And Letters

    Thanks for the response

    Use the Monday Sept 21 - Sun Sept 27 worksheet as reference. That's a completed schedule

    The range for each parts is the following:

    Part 1: F21 - F48

    Part 2: F86 - F97

    Parts 3-6: F67 - F81

    Thanks Again!

+ 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. Replies: 3
    Last Post: 08-16-2015, 07:03 PM
  2. Average of Cells in a Range Which Includes Text
    By atwy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2014, 04:11 AM
  3. Count specific phrase (letters and numbers) in continuous range
    By macneill5 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2012, 04:56 AM
  4. Return a max currency value from a range that includes numbers/text
    By simontek in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-28-2012, 06:00 AM
  5. [SOLVED] Counting Cells that includes exact match and also if a cell includes specific text
    By smclachlan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2012, 07:42 PM
  6. Sum Numbers in A Range That Includes Text Strings
    By robertmdvs in forum Excel General
    Replies: 5
    Last Post: 11-01-2011, 04:42 PM
  7. Extract only text and numbers from a range that includes 0's and ""
    By emricki in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2011, 04:19 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