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

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

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?

2. ## Re: How do I code to return the lowest 2 number is a list of cells

Try using =small()

3. ## Re: How do I code to return the lowest 2 number is a list of cells

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?

4. ## Re: How do I code to return the lowest 2 number is a list of cells

Did you even try what I suggested?

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

5. ## Re: How do I code to return the lowest 2 number is a list of cells

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

Formula:
`Please Login or Register  to view this content.`

6. ## Re: How do I code to return the lowest 2 number is a list of cells

``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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1