Invisible until all criteria met formula

[Dan_B]

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

[Pete_UK]

So you only want to show F45 if ALL cells in the range are not blank? You could try this:

=IF(COUNTIF(range,""),"",F45)

Hope this helps.

Pete

[Dan_B]

Pete_UK, that has worked exactly how I wanted

Thanks a lot

[Pete_UK]

Glad to help - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete