Countifs with Count blanks with formula

[horizonflame]

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

 

[Mentor82]

Hi,
To count empty cells try this.

=COUNTIFS(A2:A100,”=”&"")

 

[Fluff]

You didn't mention which range the blanks are in, but how about
=COUNTIFS(A:A,"*W*",D:D,"")