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