Hi All

Me again

Is there a formula to work with COUNTIF that will ignore if a cell contains a formula but that formula shows that cell as empty

I've tried =IF(ISBLANK(range), "",F45) but I still get a value even if there is a blank in the range as I assume that COUNTIF includes anything in the cell even if it's a formula that returns an empty cell

Any ideas?


Thanks

Dan_B