+ Reply to Thread
Results 1 to 3 of 3

COUNTA counting blank cells?

  1. #1
    Registered User
    Join Date
    06-15-2010
    Location
    Sacramento, CA, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    COUNTA counting blank cells?

    Greetings;
    Regarding Excel 2003.
    I've a column of cells with the following: =IF(COUNTIF($B$2:$B$1328,B2)>=2,B2,"")
    There are cells populated with "" , however when I use COUNTA to count non-blank cells it returns a value that includes cells populated with "". LEN(cellref), returns 0 and when I select the cell there are no hidden characters.

    I've copied and Paste Special values; COUNTA still counts the empty cells as if there is some invisible cell content. However, when I delete an empty cell, COUNTA stops counting the empty cell (thereby working the way I think it should).

    I can use COUNTIF(range,"?*") but I was wondering what I was doing wrong trying to use COUNTA to count non-blank cells.

    Thanks in advance for any insights.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: COUNTA counting blank cells?

    A formula Null ("") is not a Blank as far as the likes of COUNTA & ISBLANK are concerned - it is in fact a 0 length text string (hence why the COUNTIF wildcard approach works)

    (COUNTBLANK is one of the rarities that treats Null as Blank)

  3. #3
    Registered User
    Join Date
    06-15-2010
    Location
    Sacramento, CA, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: COUNTA counting blank cells?

    Thank you for the prompt reply and insights - I learned another Excel facet!
    Last edited by shg; 06-16-2010 at 12:38 PM. Reason: deleted quote

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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