I need this excel formula urgently

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
Hello,
I have the values 2,3, 2, 4, 5, 7,5,1.
I want a formula that will select the first five lowest values and add them
thanks

1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
486
Hi Blumun,

You need to be a more specific.

Are these values all in one cell, spread accros the sheet or found in a range?

What do you mean by add them? Do you mean like:
2, 3, 2, 4, 5, 7, 5, 1, 1, 2, 2, 3, 4
or like
=2+3+2+4+5+7+5+1+1+2+2+3+4

Best regards,
Trowa