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*"))