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