Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: CountIF Not Blank

  1. #1
    Join Date
    9th June 2003
    Location
    Wichita, KS
    Posts
    3

    CountIF Not Blank

    Is there a way to use Countif to count non blank spaces.

    I have tried many variations in the criteria, including:

    =countif(e14:e20,"<>"""), =countif(e14:e20,"<>isblank()"), etc.

    None seem to work.

    Am I missing something?
    Brian

  2. #2
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,678

    Re: CountIF Not Blank

    Moved to Excel forum. You posted in a "No Questions" Forum

    Try

    =COUNTIF(E14:E20,"<>")
    Kind Regards, Will Riley

    Web Presence:
    LinkedIn: Will Riley

  3. #3
    Join Date
    14th July 2004
    Posts
    10,539

    Re: CountIF Not Blank

    Brian

    Why not use COUNTA?

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    10th March 2011
    Location
    Mashhad , IRAN
    Posts
    1

    Re: CountIF Not Blank

    this code work very well :

    With Worksheets("sheet1")
    MsgBox WorksheetFunction.CountA(.Range("A1", .Range("A65536").End(xlUp)))
    End With

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,345

    Re: CountIF Not Blank

    1. Why answer a question that is 10 years old?

    2. Why use VBA when a formula exists, and in fact has already been suggested?

    You would be better reading the Forum Rules than spending time on an old question. That way you would know about using Code Tags!
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. COUNTIF function does not work with blank or null cell
    By ByTheCringe2 in forum EXCEL HELP
    Replies: 11
    Last Post: July 15th, 2012, 10:08
  2. XL97: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: April 11th, 2008, 14:05
  3. XL2000: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: April 11th, 2008, 14:00
  4. XL98: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: April 11th, 2008, 14:00
  5. XL97: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: April 11th, 2008, 14:00

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
  •  
porno