I have a sumproduct calculation problem.
is there a way to enter the second range backwards
ex. first number is in A1
Row 1= 10 20 30 40
Row 2 1 2 3 4
instead of sumproduct(A1:a4,B1:b4) result=300
I want a result of 200 or 10*4 +20*3 +30*2+40*1 without having to flip the order of row2
thanks
is there a way to enter the second range backwards
ex. first number is in A1
Row 1= 10 20 30 40
Row 2 1 2 3 4
instead of sumproduct(A1:a4,B1:b4) result=300
I want a result of 200 or 10*4 +20*3 +30*2+40*1 without having to flip the order of row2
thanks