How do I code to return the lowest 2 number is a list of cells

[rkjudy]

This is a simple question. I have a list of numbers (6 rows) and I want to write a formula or code something to return the lowest two numbers in the list in the seventh row. If there a function or formula I can use or do I need to write some code? If code is needed, can anyone help?

[FDibbins]

Try using =small()

[rkjudy]

I need the two smallest numbers in the list. Is there a way to have something return this value. I actually need the total of the two lowest numbers. For instance, if the list of cells included 3,4,4,3,4,5,6,3, I need the formula or code to return 7. Any suggestions?

[FDibbins]

Did you even try what I suggested?

=SMALL(A1:A8,1)+SMALL(A1:A8,2)

[:) Sixthsense :)]

In addition to FDibbins suggestion, try in this way too..

Please Login or Register  to view this content.

[JapanDave]

How about something like this,

Select your range and bobs your uncle. Or in my case my Dad.

Please Login or Register  to view this content.

BTW, I am not sure that is what he is after guys. I could be wrong though.