apply formula to other rows ...

B

berti

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:S
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 eac
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.

Bert
 
Top