I have a range of five numbers, say A1:A5.
I want to identify the three lowest numbers in that range,
and then return the sum of those three numbers.
Was trying to use sumif, but could not figure it out.

I then set up a simple (follow me) macro which copied the range, pasted the
values,
then sorted, and then I just added the bottom three cells. That works fine,
except I have 30 such ranges, and cannot now figure out how to step the macro
to the next range (it keeps returning to the original range), hence why I am
trying to do this through a formula.

Any help would be appreciated.

-b