SUMPRODUCT & OFFSET for % of price drops

[loudnoiseman]

Hi Everyone,

I'm trying to return the % of times that the prices decrease in a range. I've adapted the formula in D column that does this but I have to make a copy of the range and offset by one. My question is: can't I replace the "B3:B11" with "A3:A11" using the OFFSET feature?

Basically I'm looking for the most efficient way to get this result.

Thanks!

COL-A COL-B COL-C COL-D
10 SUMPRODUCT(--(A3:A11<B3:B11)/ROWS(A3:A11))
9 10
8 9
7 8
6 7
5 6
4 5
3 4
2 3
1 2
0 1
0

 

[loudnoiseman]

sorry, everything got scrambled

the formula is:

SUMPRODUCT(--(A3:A11<B3:B11)/ROWS(A3:A11))

 

[loudnoiseman]

sumproduct
(--(a3:a11
<
b3:b11)
/rows(a3:a11))

 

[loudnoiseman]

not displaying properly
Sorry