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