Problem leaving cell blank with double logic formula

I am guessing I am probably doing this the wrong way but I think what i am doing should work. I am trying to tally some numbers from a group of cells and if that number is greater than 4 another cell will result in 1 point (or the number 1) if it is not greater than 4 than I want the cell in question to remain blank. Easy enough and I have done that here.

=IF(SUM(J8:J10)>4,1,"")

My problems is that I want to add to that formula because if the sum of the cells in question is greater than 9 I want 3 more points added to the results cell resulting with the total 4.

=IF(SUM(J8:J10)>4,1,"")+IF(SUM(J8:J10)>9,3,"")

It works but THE PROBLEM IS when the cells in question are not greater than 4 the results cell is not blank it shows "###"

Why is it not blank like it is in the simple first formula?
How can I create a formula that shows the results of a blank cell if the sum in question is less than 5, results in 1 if the sum is greater than 4, and results in 4 if the sum is greater than 9.


Thanks for any help

Heali

Brilliant!
Thank you DonkeyOte. I spent over two hours trying to fix that.