Sorry I am using Excel2002, Managed to copy and edit, but what is the { used
for that I have to put in at the beginnig of the formula, after I use thisit
works, but why?

Eric

"Sandy Mann" wrote:

What version of XL are you using Joel?

changge the cell. Editing formulas can cause problems. first, never use
the
backspace key (it changes the address in the formula)

The Backspace works just fine for me in XL 97. You are not thinking about
the arrow keys in Conditional Formatting where they do enter new cell
references are you? Whereas:

backspace key (it changes the address in the formula). Click on the cell
then do the editing in the F(x) box at the top of the worksheet. Click on
the first character of Complete the press the delete key to delete
character
one at a time. Then enter new characters. Then click on worksheet to end
the
editing of the formula.

In the fx dialog box clicking on the worksheet *will* enter the cell
reference for that cell and does not end the editing of the formula.

--
Puzzled,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Joel" wrote in message
...
If you paste the formula into the cell then you have the permission to
changge the cell. Editing formulas can cause problems. first, never use
the
backspace key (it changes the address in the formula). Click on the cell
then do the editing in the F(x) box at the top of the worksheet. Click on
the first character of Complete the press the delete key to delete
character
one at a time. Then enter new characters. Then click on worksheet to end
the
editing of the formula.

"offcott" wrote:

I have conditionla sum formula in one cell which I wish to :
a) copy across to another sheet in same workboo
b) copy into other cells on same sheet but incremant the values in the
formula, I wsih to change complete to new, butwhen I copy to another cell
I
and change the word I get error, probably because I cannot change the
destination cell.

Cheers

=SUM(IF($C$2:$C$701="Capability",IF($H$2:$H$701="C omplete",IF($I$2:$I$701="Administrator",$B$2:$B$70 1,0),0),0))