Hi, does anybody know how to rotate/shift a vector/array in excel without VBA ? Say that I have in the range A1:C1 the value 8, 9 and 10. Then I would like to rotate the value in the range one position to the right so that the result of =SUMPRODUCT(TRICK(A1:C1);A2:C2) would be 9 when A2:C2 values are 0, 0 and 1. Of course TRICK() is the question of this post ...

I hope I have made myself understood