Sorry if I have caused confusion Eric, I was asking Joel what version of XL
he was using because his instructions do not work for me in XL97.
The { } around your formula,which should be put there by XL when you enter
the formula by pressing and holding the Ctrl and Shift keys whil you press
Enter tell Xl that it is an array formula and to work on each cell in the
ranges in the formula otherwise it will just use the first cell.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk
"offcott" <(E-Mail Removed)> wrote in message
news:AA63895B-F37A-45BD-842A-(E-Mail Removed)...
> 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
>>
>> (E-Mail Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "Joel" <(E-Mail Removed)> wrote in message
>> news:7899936B-0E38-4535-AE7A-(E-Mail Removed)...
>> > 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="Complete",IF($I$2:$I$701="Administrator",$B$2:$B$701,0),0),0))
>> >
>>
>>
>>
>
Similar Threads
