Results 1 to 5 of 5

Counting a range of cells that include text and numbers

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2015
    Location
    New York
    MS-Off Ver
    2011
    Posts
    2

    Counting a range of cells that include text and numbers

    Hey guys,

    So I have been scouring the site looking for help with a particular single-cell formula to count a range of cells that have both text and numbers. Easiest way to explain is with an example:

    SalesID 10
    SalesID 13
    SalesID 17
    SalesID 21
    SalesID 28
    SalesID 31
    SalesID 32
    SalesID 33
    SalesID 37
    SalesID 38
    SalesID 43
    SalesID 53

    What would be the right formula to find the number of SalesID's in the 30-40 range without separating the numbers from the text into a separate column?

    Thanks in advance for the help!
    Last edited by jbourne21; 08-29-2015 at 04:36 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting text in cells dependant on a date range
    By Netski in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2013, 10:08 AM
  2. Counting the # of Unique Text cells in a range
    By peter_f in forum Excel General
    Replies: 2
    Last Post: 10-16-2010, 06:03 AM
  3. [SOLVED] adding cells which include numbers and text
    By Shelley in forum Excel General
    Replies: 6
    Last Post: 10-25-2005, 11:05 PM
  4. [SOLVED] Counting Occurrence of Text within Text in Cells in Range.
    By Jeremy N. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2005, 01:05 AM
  5. Counting unique text/number cells from a range
    By sudeepd12 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-06-2005, 07:05 AM
  6. Counting unique text/number cells from a range
    By sudeepd12 in forum Excel General
    Replies: 3
    Last Post: 06-15-2005, 02:58 PM
  7. Counting unique text/number cells from a range
    By sudeepd12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2005, 07:05 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