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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Christian" schrieb im Newsbeitrag
...
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

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

Hi
I think then you have to copy the formula

--
Regards
Frank Kabel
Frankfurt, Germany

"Christian" schrieb im Newsbeitrag
...
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:$B
3=$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:$B
3=$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