If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
My error - yet Outlook does lack HTML editing and variable reply format | Michel Merlin | Outlook Express | 4 | January 28th, 2005 10:37 AM |
Getting into Microsoft Picture Manager (Editing) | [email protected] | General Discussions | 3 | September 3rd, 2004 05:21 PM |
COUNTIF almost does it but... | Stevej | Worksheet Functions | 2 | August 27th, 2004 11:58 PM |
Countif | Doug | Worksheet Functions | 7 | July 1st, 2004 04:35 AM |
2000 vs 97 Formulae | Phani | Worksheet Functions | 5 | January 14th, 2004 11:04 PM |