How can i count empty cell using count if?

used the below formula but not taking it:-Here i am trying to count if column 1 has filter 6 and column 2 is blank (other than Yes and No).
1.countIf(column1,column1=6 AND (column2<>‘Yes’ OR column2<>‘No’))
2.countIf(column1,column1=6 AND (column2=’ '))
3.countIf(column1,column1=6 AND (column2=NULL))

Try this:

countIf(column1, column1 = 6 AND isNULL(column2))

2 Likes

Than you soo much, it worked :slight_smile: .