Ask Your Question 0 Conditional Counting Using Multiple Columns where one condition is Not Blank and the other is Blank

I have a Calc spreadsheet where two columns may or may not contain a value. If the first column contains a value, I want to count the second column if it is blank. I have been working with the COUNTIFS function, but I can’t seem to get it to work. I tried =COUNTIFS(C2:C203,<>"",D2:D203,"") but I get an Err:510. I tried something like =COUNTIFS(C2:C203,COUNTA(C2:C203),D2:D203,"") but this gives 0 which is not correct. Finally, I tried =COUNTIFS(C2:C203,<>ISBLANK,D2:D203,ISBLANK) with a result of Err:510. The answer for this sheet should be 43. That is column C has 43 non blank entries where the corresponding row entry in column D is blank.

Not possible to put the comparators out of the quotes.

image description

Edited 20160316

With strings:

image description

If I use =COUNTIFS(C2:C203;"<>";D2:D203;""), I get 0 for an answer. My data is not numeric, it is alphanumeric. Does that make a difference?

Thanks, that took care of it. I’m going to have to think about the function name and how it relates to the issue.