Need help fixing SMALL Function that gives error with a blank data field

[Sharonits]

I have a worksheet that is looking at 6 columns with numbers in them and delivering the lowest number, then second lowest number then adding the two numbers. It works great until I have a blank cell. Is there a way to incorporate and if statement with the SMALL Function?

What will work with the SMALL function to get rid of the error message?

[Moo the Dog]

You could try this:

=IFERROR(SMALL(A1:F1,1),0)+IFERROR(SMALL(A1:F1,2),0)

Assuming A1:F1 is the range you are trying to add the lowest 2 values from.

If there are at least 2 numbers in the range A1:F1, it will add the smallest 2 numbers. If there is only one number in the range, it will add that number + 0. And if there are no numbers in the range, the result will be 0.

- Moo