+ Reply to Thread
Results 1 to 2 of 2

Count Values (Text and Numbers Combination and Text ONLY)

  1. #1
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,000

    Count Values (Text and Numbers Combination and Text ONLY)

    Looking for formula to count values with text and numbers combination and Text ONLY. Values to count are in column K and desired outcome is in column L2. See attached sample file.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Count Values (Text and Numbers Combination and Text ONLY)

    Why not a simple

    =COUNTA(K:K)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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] Find function doesn't accept combination of numbers, text and values from variables
    By Onreron in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-05-2019, 08:16 AM
  2. [SOLVED] Fill series combination of text and numbers
    By spishowtime in forum Excel General
    Replies: 7
    Last Post: 09-05-2018, 04:18 PM
  3. Replies: 2
    Last Post: 11-18-2014, 06:26 AM
  4. Replies: 4
    Last Post: 07-21-2014, 10:33 AM
  5. Replies: 4
    Last Post: 11-20-2013, 10:16 PM
  6. Count Text & Unique numbers in Text Box
    By l4ya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2008, 01:06 AM
  7. [SOLVED] Combination text & numbers - use what format for pivot
    By Amy in forum Excel General
    Replies: 2
    Last Post: 06-14-2006, 01:10 PM

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