Editing countif formulae

[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

[sirknightly]

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



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

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

[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

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