Sum of 1st 3 minimum in a row

[lehainam]

Dear all,

I have one row that have around 100 numbers and I would like to sum only the first 3 minimum numbers.

Could anyone can help me?

Thanks a lot!

Nam

[Mallycat]

try this =SMALL(A1:F1,1)+SMALL(A1:F1,2)+SMALL(A1:F1,3)

[VBA Noob]

or

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

Easier to modify if you want 4th or 5th as well

e.g

=SUMPRODUCT(--(SMALL(A1:F1,{1,2,3,4,5})))

VBA Noob