I need this excel formula urgently

Closed
blumun - Nov 24, 2011 at 09:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 24, 2011 at 10:19 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 24, 2011 at 10:19 AM
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
0