Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

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,676

    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:
    Personal: The Trouble With Data
    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


Thread Information

Users Browsing this Thread

There are currently 4 users browsing this thread. (0 members and 4 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