Countifs

[jp_1]

I would like the 3rd criteria of a COUNTIFS formula to count cells that are not blank (with text). I have tried ">0" and it does not work since the information is texts. Can I somehow add COUNTA or use another method to count cells that are not blank?

 

[VoG]

Try

"<>"

 

[BiocideJ]

I would like the 3rd criteria of a COUNTIFS formula to count cells that are not blank (with text). I have tried ">0" and it does not work since the information is texts. Can I somehow add COUNTA or use another method to count cells that are not blank?

"<>" is the search criteria for non blanks...

i.e. =COUNTIFS(A:A, "<>", B:B, "<>")
would return the count of all rows that have text in columns A and B

 

[jp_1]

It worked! Now how do I count blanks?

 

[VoG]

To count blanks

=""