Editing countif formulae

[Guest]

Hi - When I finish editing a formula containing a countif calculation, it
changes from a formula to a regular cell, despite the '=' and I get a message
that my formula contains a constant. The formula reads exactly as a working
one below, and I can't seem to get it to work, even retyping the entire
formula. The countif reference is to another sheet in the workboow.

Thx

Dean

 

[Guest]

Sure thing: =COUNTIF('Special Project'!J:J,A5)

I changed the J:J from O:O. I've had the same result when I was doing an
automatic 'replace all' to change all the formulas in the column, as well as
when I did it manually in just one cell. Hoping you've got some insight.

Thx

Dean

 

[Guest]

Great, now I can't replicate the error either. I have had this issue before
and had to delete and re-write all my formulas. There's a ghost in the
machine somewhere. Thanks for your efforts!

Dean