CODEWITHSUNDEEP
excelgoogle-sheets
Marco
Marco

Reputation: 1272

Counting empty cells on a column, where other column have filled cells

Right now I have two columns with data on Google Sheets.

My goal is to count the number of empty cells on column B, where column A has data.

In this example, the result should be the number 5

So far, I've got this:

=COUNTIFS(B3:B3000;"";A3:A3000;"")

But it returns 948, which is the total number of empty cells on both columns.

Thank you all

Upvotes: 2

Views: 141

Answers (1)

Dan
Dan

Reputation: 45762

Assuming nothing else in the columns:

=COUNTA(A:A)-COUNTA(B:B)

otherwise you can use COUNTIFS like so:

=COUNTIFS(A:A,"<>", B:B, "=")

According to google docs count cells that contain any text you use the criterion string "<>" to indicate not equal to blank, and I just guessed (correctly according to empirical evidence) that the criterion for equal to blank would be "=".

Upvotes: 2

Related Questions