Searching for the lowest 3 numbers

[RobMcKee]

I have 5 columns of non-sequential numbers and I would like to be able to pull out the lowest three numbers and sum them in one cell.

Can this be done?

 

[Mark W.]

=SUM(SMALL(range,{1,2,3})

 

[Dave Patton]

=SUM(SMALL(E2:I6,{1,2,3}))

or just

=SMALL(E2:I5,1)+SMALL(E2:I5,2)+SMALL(E2:I5,3)

Revise the references as necessary.

 

[RobMcKee]

Thanks very much to both of you!!