CODEWITHSUNDEEP
excel
Tornado168
Tornado168

Reputation: 465

Check if a range corresponding to another range is blank or not

I need to check if a range corresponding to another range is blank or not. enter image description here

e.g. I need to check if range (B1:B3) which is corresponding to range (A1:A3) (Criteria: ="A") contains blank cells or not.

I tried Sumproduct but no luck as it it dosn't distinguish between blank and 0.

Thank u in advance.

Upvotes: 0

Views: 36

Answers (2)

d--b
d--b

Reputation: 5779

What you're looking for is

=Countifs(A1:A13,"=A",B1:B13,"<>")

Upvotes: 2

wardk
wardk

Reputation: 1143

Use COUNTBLANK(B1:B3)

Check out http://www.excel-easy.com/examples/count-blank-nonblank-cells.html

Upvotes: 0

Related Questions