formula request

[vk3fm]

I am looking for a formula for the following -

I have 49 columns, each with a number within.

I would like the formula to select the twenty (20) lowest numbers from the 49, and sum them, and show the result in column 50 (or whatever).

Can anyone assist, please.

[Bryan Hessey]

I am looking for a formula for the following -

I have 49 columns, each with a number within.

I would like the formula to select the twenty (20) lowest numbers from the 49, and sum them, and show the result in column 50 (or whatever).

Can anyone assist, please.

Hi,

in AX1 try

=SUM(IF(A1:AW1<=SMALL(A1:AW1,20),A1:AW1))

CSE (Control Shift Enter)

hth
---

[Raiby]

I am looking for a formula for the following -

I have 49 columns, each with a number within.

I would like the formula to select the twenty (20) lowest numbers from the 49, and sum them, and show the result in column 50 (or whatever).

Can anyone assist, please.

Hi to you too

You can try this macro:

Please Login or Register  to view this content.