+ Reply to Thread
Results 1 to 8 of 8

Countif for cells with text only

  1. #1
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Countif for cells with text only

    This problem has been solved. Needs met!
    Last edited by Tortus; 02-21-2019 at 04:58 PM. Reason: Solved - works great

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Countif for cells with text only

    Try

    =SIGN(COUNTIFS(S3:W3,"?*",S3:W3,"<>*~~*"))*(M3="Low")
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: Countif for cells with text only

    Thank you sir! This works fine!
    If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!

  4. #4
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: Countif for cells with text only

    Please Login or Register  to view this content.
    This code works but how do I add in that last piece "Low" or "Lo"?

  5. #5
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Countif for cells with text only

    How about

    =SIGN(COUNTIFS(S3:W3,"?*",S3:W3,"<>*~~*"))*(Left(M3,2)="Lo")

  6. #6
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: Countif for cells with text only

    Sorry Kev, I wasn't clear. Is there a way to add 2 completely different words in that last part? *(M3="Low","L") or something like "*(M3="Low", "High")

  7. #7
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Countif for cells with text only

    *OR(M3="Low",M3="High")

  8. #8
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: Countif for cells with text only

    Thanks kev_, I've beat this thread up enough now I think!

    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. [SOLVED] Need formula to COUNTIF specific TEXT, for only visible cells
    By Kirk3737 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2019, 12:17 AM
  2. [SOLVED] COUNTIF cells contain a specific word anywhere within the text string
    By RoundaboutCJP in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-18-2018, 12:38 PM
  3. COUNTIF using park of text from a range of cells
    By rcanpolat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-22-2017, 01:04 PM
  4. [SOLVED] Countif formula to count cells that contain everything but a certain text
    By nbrp in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-03-2014, 03:26 PM
  5. [SOLVED] COUNTIF search range of cells for multiple specific text.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2013, 06:38 PM
  6. Replies: 6
    Last Post: 04-05-2013, 12:03 AM
  7. [SOLVED] How to not duplicate countif text within cells?
    By danrubi in forum Excel General
    Replies: 8
    Last Post: 08-23-2012, 09:22 AM

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