Take a look at OFFSET, something like

=OFFSET(Data!$P$3,(n-1)*30,0,13,1)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sylphide" wrote in message
...
Ok, so what is the Excell function that will solve my problem.
I am calculating a temporary life Insurance ( from Life Table) and need to
sum the column of a spreadsheet from 0 to n, n being the lenght (variable)
of
the Temporary Life Insurance.
Any tips?
Ex.:product from p3 to p12 if n=10, p30 to22 if n=20, etc. Thing is i need
to be able tu put any value of n in the input table and that same n valu
affect the lenght of the items I need to multiply.
So far I am he
=B2*(1-PUISSANCE(Data!$B$4,lenght)*PRODUCT(Data!N4:@@@))
It is the part after the * that I am not ure how it should be coded.
With IF?
I donno
Thanks