=SUMPRODUCT(SMALL(A1:B4,{1,2}))


Regards,

Peo Sjoblom

"golfer18" wrote:

What formula is used to autosum the two lowest numbers in a group of 4 cells?

a) 2 a) 5
b) 3 b) 4
c) 4 c) 2
d) 5 d) 3
e) e)
I need the cell in row "e" to pick-up automatically and autosum the two
lowest numbers in rows a,b,c,d. ( 2+3=5)