Reputation: 1272
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
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