Yip, thats it! Thats Daddy... and Martin for your input.

Daddy your solution works fine, thanks.

For the record I was also able to update my own formula based on your suggestion (in case anyone finds it useful)...

=COUNTIF(INDIRECT("X"&ROW()),"*closed*")+COUNTIF(INDIRECT("X"&ROW()),"*moved*")

However I stuck with your suggestion.

Either way works, so I am happy. Thanks.