Sumif for lowerst value within limited to 2 numbers only

K

ken

A B C D E F G

3 1 2 2 3 4 =i need formula here

What the formula to sum only two numbers that have the lowest value of all
( 1 and 2 ). If I three numbers requires for the sum, it should be (1 , 2
and 2 ).

Please help.
 
D

Domenic

Sum two lowest values...

=SUM(SMALL(A1:F1,{1,2}))

Sum three lowest values...

=SUM(SMALL(A1:F1,{1,2,3}))

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top