Excel formula for ISBLANK

[icetoken]

Hi all. I've been up all night trying to figure this out so there's a strong chance I'm too tired to think.

I have a range of cells that will either be blank or say OPEN. I'm trying to use this formula in cell A3 to either be blank or show how many cells say OPEN in that row. Thoughts? When I use this formula it just either says 0 or how many opens there are. The 0 should be blank.

=IF(ISBLANK(CS3:DJ3),"",COUNTIF(CS3:DJ3,"*open*"))

[sourabhg98]

Hi
According to what I have understood, I think this would suffice your requirement
=IF(COUNTIF(CS3:DJ3,"*open*")=0,"",COUNTIF(CS3:DJ3,"*open*"))

[JohnTopley]

One way

=COUNTIF(CS3:DJ3,"OPEN")

format cell as 0;0;;@ (results of zero will be blank)

or

=IF(COUNTIF(CS3:DJ3,"OPEN"),COUNTIF(CS3:DJ3,"OPEN"),"")

[icetoken]

You rock thanks so much!

[sandy666]

=IF(ISBLANK(CS3:DJ3),"",COUNTIF(CS3:DJ3,"open")) and Control+Shift+Enter (if exact open)
or
=IF(ISBLANK(CS3:DJ3),"",COUNTIF(CS3:DJ3,"*open*")) and Control+Shift+Enter (if abcopenabc)



in most cases I forget to refresh thread