Countif conditionally?

[spacely]

Hi,

I have 2 columns of text. There may or may not be empties in either column. And some rows may be hidden. So, I need to count up the number of times when there IS an entry in the 1st column (A) but NO entry in the next column over (B).

Thanks in advance...

Dave

 

[Aladin Akyurek]

Yes, but now use excel's filters to filter out row 4 with dave3. What's the answer? And then use the filters to filter out row 6 with dave5. What's the answer then? Answer should depend on the filter...so it works only on what's visible....

Try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET($A$2,ROW$A$2:$A$7)-ROW($A$2),0)),1-($A$2:$A$7=""),--($B$2:$B$7=""))

 

[spacely]

Yep! Perfect. After I put in the missing parentheses . Thank you.

 

[Aladin Akyurek]

Yep! Perfect. After I put in the missing parentheses . Thank you.

You are welcome. Yes there is one...

=SUMPRODUCT(SUBTOTAL(3,OFFSET($A$2,ROW($A$2:$A$7)-ROW($A$2),0)),1-($A$2:$A$7=""),--($B$2:$B$7=""))