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)),"")