countif + blank

[kylefoley76]

=IF(COUNTIF(books!$A$1:$AT$300,K1497),"",1)

I want to rewrite the above formula so that if one of the cells in column k is blank then the value returned will also be blank, otherwise everything else continues as normal.

 

[kylefoley76]

help

 

[texasalynn]

try this

=IF(COUNTBLANK(books!$K:$K)>0,"",1)

 

[T. Valko]

=IF(COUNTIF(books!$A$1:$AT$300,K1497),"",1)

I want to rewrite the above formula so that if one of the cells in column k is blank then the value returned will also be blank, otherwise everything else continues as normal.

Maybe this...

=IF(K1497="","",IF(COUNTIF(books!$A$1:$AT$300,K1497),"",1))

 

[kylefoley76]

got it, thanks

 

[T. Valko]

got it, thanks

You're welcome!