count blanks and non blanks same formula

[fastballfreddy]

Needing a formula to count non blanks in 1st column and blanks in the 2nd column. So the example it would count 2. the text is giving me issues trying to do a COUNTIFS formula and using COUNTA formula. I've searched and tested but nothing is working for me. appreciate any help in advance.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]count non blanks[/TD]
[TD]count blanks[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]text2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]text3[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]text5[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

If there are no cells in either column that hold formulas returning "", use COUNTA in the first column and COUNTBLANK in the second column.

 

[fastballfreddy]

Thanks for the reply Joe. I'm wanting to search the first column looking for anything that has text and that also have blanks in the 2nd column.

 

[FuNeS13]

Hi, how about this:

=COUNTIFS(A1:A7, "<>", B14:B17, "") <-- Column A are you Non Blanks and Column B Are your blank...

 

[fastballfreddy]

Thanks, i just figured it out. Appreciate all of the help!

=COUNTIFS(C2:C17,"*",B2:B17,"<>"&"*")