Formula to find lowest 2 numbers from range of cells

[jndipworm]

Hello all. I need a formula to look thru a range of cells and find the 2 lowest numbers and add them together. I've attached a file to help show what I'm looking for. Thanks in advance.

[icestationzbra]

for adding smallest 2:

Please Login or Register  to view this content.

for adding largest 2:

Please Login or Register  to view this content.

[zbor]

You showed highest in example and lowest in title.

Here is solution for both:

Highest:

Please Login or Register  to view this content.

Lowest:

Please Login or Register  to view this content.

[jndipworm]

Thanks, that's it.