Rank With Array

Dear All,

Plaese take a look and see if you can help.

I have 2 arrays A1:E1 and A2:E2 with numbers 1,2,3,4,5 and 5,4,3,2,1

The third array in A3:E3 is the product of the above 2 arrays or 1*5, 2*4, 3*3, 4*2, 5*1 or 5,8,9,8,5

Rank(5, A3:E3,1) works fine.

I need a formula however, that multiplies 2 arrays as follows rank(5, A1:E1*A2:E2,1) ?

The aforementined does not let me enter the formula in excel, any ideas?

The same problem happens when A1:E1 and A2:E2 are in offset formulas.

Thanks and regards john