COUNTIFS on blank cells

[Exceldontknow]

Hi! Could someone help me with this?

I have two columns, in first column "Description" a have different categorizations, in second column "Name" i have names and also i have blank cells among them.

I want to count all categories from column "Description" with blank cells in column "Name". In another words, i want to count rows that contains any text in column"Description" and blank cells in column "Name" ( rows that meet both criteria)

I tryed with COUNTIFS function, but it doesnt working. I signed BLANK cell as "" under function criteria.

Is it possible do this with COUNTIFS function??

 

[Joe4]

Say your data is in range A2:B100. Try:

=COUNTIFS(A2:A100,"<>",B2:B100,"=")

 

[Exceldontknow]

Thanks a lot guys. It was helpful.