Hi,

I have a spreadsheet with two columns, A and B, with 100 entries. All I want to do is count: for those rows in A that are NOT blank, how many rows in B are blank.

When I try using COUNTIFS, ISBLANK, "", and so on, I keep getting error messages, especially that I have circular references.

Thanks very much!