+ Reply to Thread
Results 1 to 3 of 3

Countifs (How to give criteria for blank cell).

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    India.Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    97

    Countifs (How to give criteria for blank cell).

    Hi
    I m working on “COUNTIFS” formula one of my criteria is the cell should be blank for particular column . My column is having dates data .If the cell is “NIL” the count should calculate .
    Note –For that particular column I have given the data variation as a DATA RANGE.
    I don’t know what criteria I have to give as Blank ,Can anyone help me .

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Countifs (How to give criteria for blank cell).

    Good morning Shadharani

    Does "" (ie two sets of quotes - no space between them) not work?

    HTH

    DominicB

  3. #3
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: Countifs (How to give criteria for blank cell).

    How about this?
    =ISBLANK(A1)

    Returns ture or false.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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