Results 1 to 3 of 3

Thread: Countifs with Count blanks with formula
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2018
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Countifs with Count blanks with formula

    Hi All,

    I would like to perform a Countifs where the second criteria is about counting blank cells, including those with a formula but a blank result.
    =COUNTIFS(A2:A100,”*W*”, is my start
    Many thanks



    Last edited by horizonflame; Aug 19th, 2019 at 11:03 AM.

  2. #2
    Board Regular
    Join Date
    Dec 2018
    Location
    Poland
    Posts
    203
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Countifs with Count blanks with formula

    Hi,
    To count empty cells try this.
    Code:
    =COUNTIFS(A2:A100,=&"")

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,326
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Countifs with Count blanks with formula

    You didn't mention which range the blanks are in, but how about
    =COUNTIFS(A:A,"*W*",D:D,"")
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •