Editing countif formulae
 

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

Dean,

Can you post a copy of your formula?

Knightly

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



"sirknightly" wrote:


Dean,

Can you post a copy of your formula?

Knightly

Dean F Wrote:
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


--
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

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

"sirknightly" wrote:


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

Dean F Wrote:
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



"sirknightly" wrote:
-

Dean,

Can you post a copy of your formula?

Knightly

Dean F Wrote:-
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-


--
sirknightly
-


--
sirknightly