apply formula to other rows ...
 

Hi,
how can I apply the following formula:
=SUM(LARGE(F1:S1;1);LARGE(F1:S1;2);LARGE(F1:S1;3))
to all other rows in the table,
where array F1:S1 in the k-th row should change to Fk:Sk
automatically?

This formula represents the sum of the highest 3 numbers from the row.
Is there any better (shorter) formula for this?

What if I would like to have the sum of the highest 4 numbers for each
row?
Like

=SUM(LARGE(F1:S1;1);LARGE(F1:S1;2);LARGE(F1:S1;3); LARGE(F1:S1;4))
How could I apply this change to all rows in one step?
Is it possible at all?

Thanks.

Berti


--
berti
------------------------------------------------------------------------
berti's Profile: http://www.excelforum.com/member.php...o&userid=29597
View this thread: http://www.excelforum.com/showthread...hreadid=493716

apply formula to other rows ...
 

Ok, it is too easy. Just copy/paste ... :(


--
berti
------------------------------------------------------------------------
berti's Profile: http://www.excelforum.com/member.php...o&userid=29597
View this thread: http://www.excelforum.com/showthread...hreadid=493716