Setting a dynamic range in a formula

P

Phillycheese5

Hi,
I have a column of numbers and I always want the following arra
formula to use the last 12 entries:
=(PRODUCT(1+D1:D12/100)-1)*100
Any suggestions?
Thanks,
Phillycheese
 
D

Domenic

Assuming that Column D contains no blanks, try...

=(PRODUCT(1+OFFSET(D1,MAX(0,COUNTA(D:D)-12),0,12,1)/100)-1)*100

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
 
J

JE McGimpsey

One way:

=(PRODUCT(1+OFFSET($D$1,COUNTA(D:D)-12,0,12,1)/100)-1)*100

Phillycheese5
 
Top