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