Formula is giving me data input of #NUM when a blank cell is in the range

I have 6 columns, each has a number in them. I am looking to put the lowest number in column 7, the next lowest number in column 8 and the total of 7 & 8 in column 9. The problem I am having is when the data that is input into this spreadsheet is a blank field it gives me the error #num and the total in column 9 looks like #####.

This is the formula I have in column 7: =SMALL(F3:G3,1)
This is the formula I have in column 8: =SMALL(F3:G3,2)

The whole worksheet works perfectly until on of the 6 columns has a blank field.

What can I do to fix this?

The link you gave me tells me why the formula is returning that error. My questions is how can I fix my worksheet so that the rows that have blanks will return the lowest number and second lowest number?

The Range is for 6 data values F3:k3.

the formula for column 9 is: =SUM(L3:M3)

How can I fix this so it won't give me the error when there is a blank cell?

The Range is for 6 data values F3:k3.

the formula for column 9 is: =SUM(L3:M3)

How can I fix this so it won't give me the error when there is a blank cell?

=SMALL(IF(F3:K3<>0,F3:K3),$A$4) (CRTL-SHIFT-ENTER)

I fixed the issue of the smallest number going into the column and not counting the zero. This is the formula that I am using for the second lowest number. It works fine until there is only 1 number that is not a zero. then I get an error. I only have data in two columns but in the future I will be adding the other four columns, until then I would like to see the two lowest numbers in each column or if there is only one column with a data value to leave the second lowest blank. Is there a way to do this?

I tried the IFERROR but I could not get it to work, Is there a way to incorporate the IFERROR function with the Small funciton that I am using that is working to insure I will n ot get an error message but still get valid data when available?