entering matrix formula

[Christian]

Hi NG,

I have a matrix formula that I would like to enter to several cells at once.
With a normal formula I can enter it to several cells using Ctrl+Enter.

When entering a matrix formula I have to enter it with Ctrl+Shift+Enter.

So my question is:
Is it possible to enter matrix formula to several cells at once?
-Chr

 

[Frank Kabel]

Hi
yes, just select all of them and hit CTRL+SHIFT+ENTER

 

[Christian]

Hi Frank,

yes, just select all of them and hit CTRL+SHIFT+ENTER

I can't get it to work. The formula I have looks like this:
Cell I4:
={(SUM((I$2:I3)*($B$2:$B3=$B3)*($C$2:$C3="SysA"))-SUM((I$2:I3)*($B$2:$B3=$B3
)*($C$2:$C3="SysB")))/SUM((I$2:I3)*($B$2:$B3=$B3)*($C$2:$C3="SysA"))}

I then need to enter the same formula (but with the relevant cell ref in
cell I11 for example and it should look like this

Cell I11:
={(SUM((I$2:I10)*($B$2:$B10=$B10)*($C$2:$C10="SysA"))-SUM((I$2:I10)*($B$2:$B
10=$B10)*($C$2:$C10="SysB")))/SUM((I$2:I10)*($B$2:$B10=$B10)*($C$2:$C10="Sys
A"))}

Or in cell J4:
={(SUM((J$2:J3)*($B$2:$B3=$B3)*($C$2:$C3="SysA"))-SUM((J$2:J3)*($B$2:$B3=$B3
)*($C$2:$C3="SysB")))/SUM((J$2:J3)*($B$2:$B3=$B3)*($C$2:$C3="SysA"))}

What I tought I could do was to use Edit > Goto blanks > enter formula and
then use some key combination to get the formula in to all cells at once.

But it's not possible then I'll make a macro that will copy it around.

- Chr

 

[Frank Kabel]

Hi
I think then you have to copy the formula