+ Reply to Thread
Results 1 to 5 of 5

Is it possible to get COUNTIF to display "N/A" when 0?

  1. #1
    Registered User
    Join Date
    05-07-2014
    Location
    Knoxville, Tennessee
    MS-Off Ver
    Excel 2013
    Posts
    5

    Is it possible to get COUNTIF to display "N/A" when 0?

    I'm fairly new to Excel so please forgive me if this is a simple fix. My searches have come up with nothing.

    I have a column of text ranging from A84 through A237. I need to count the number of occurrences within that range of cells then display the total, but if the total is 0, I need it to display "N/A".

    Here is my formula that returns 0 when none are found. Basic stuff.
    =COUNTIF($A$84:$A$237,"TEXT")

    I've tried this with no success (I didn't expected it to work since B25 is my target cell):
    =IF($B$25=0,"N/A",COUNTIF($A$84:$A$237,"TEXT"))

    I've looked into Conditional Formatting but it won't insert text when 0, it only highlights, bolds, etc.

    Sigh...

    Any help is appreciated!

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Is it possible to get COUNTIF to display "N/A" when 0?

    maybe something along this line

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Is it possible to get COUNTIF to display "N/A" when 0?

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  4. #4
    Registered User
    Join Date
    05-07-2014
    Location
    Knoxville, Tennessee
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Is it possible to get COUNTIF to display "N/A" when 0?

    It works!
    Exactly what I was looking for.
    Thanks a TON!

  5. #5
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Is it possible to get COUNTIF to display "N/A" when 0?

    awesome Jim.....glad we could help....

    If this has been completed to your satisfaction, please set the thread to Solved...If you feel we deserve an increase in our reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be us...just a thought...

+ 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: 0
    Last Post: 10-21-2013, 05:06 PM
  2. [SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes
    By andreindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2013, 05:49 PM
  3. compare two excel sheets using macros and display the result in "true" or "false"
    By gayunana01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 07:21 AM
  4. [SOLVED] Display , "PASS"," MERIT" or "DISTINCTION"
    By Integrity in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 05-01-2012, 05:41 AM
  5. IF(COUNTIF(Thursday,"John Doe")>1,"error"," ")
    By jayd77 in forum Excel General
    Replies: 3
    Last Post: 10-26-2005, 09:17 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