Exclude blanks from formula

I have applied this function to a single column with two observations: =SUMPRODUCT(A1:A2;LOG(A1:A2;2)) and it works.

Now I want to calculte several columns that don´t have the same number of observations but with results displayed on the same row (A$11). I tried to use this formula but it doesn´t seem to work.

IF(A1:A10>"",SUMPRODUCT(A1:A10;LOG(A1:A10;2)),"")

Hm, it doesn´t seem to work. To clarify: I can use this formula and drag it to other columns if each column contains 10 observations:

=SUMPRODUCT(A1:A10;LOG(A1:A10;2)).

However it doesn´t work if each column has different noobs (10 or less).