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!

Perhaps Adapt the ranges to your needs

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks for the suggestion. However, I still get an error message that there is a circular reference - that doesn't make sense to me, but that's what I get.

Quick update - your suggestion worked! I have a lot of blank rows at the top of the two columns and I realized that I placed the formula in one of those rows.

Glad it helped

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post