Editing countif formulae

D

Dean F

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
 
D

Dean F

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
 
S

sirknightly

Dean,

Very strange. I replicated the scenario and didn't have any problems.
Try setting it up again in a new file (just cut and paste the values you
need) and see if that works. I wonder if some settings got screwy in
your current file.

Knightly
 
D

Dean F

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
 
Top