Help to define a Function. Easy for those who know how to do

[Actuariojf]

Hello everybody,

I would like to build a "simple" function, something like MAT(x,y,z), where the values of x and y are single cells addresses and z is an integer, so if I calculate for example MAT(N12,L12,z) the function does the following:

SUMPRODUCT($N$12:INDIRECT(ADDRESS(ROW($N$12)+Z-1,COLUMN($N$12))),N(OFFSET($L$12,ROW($L$12)+ROWS($L$12:INDIRECT(ADDRESS(ROW($L$12)+Z-1,COLUMN($L$12))))-ROW($L$12:INDIRECT(ADDRESS(ROW($L$12)+V12-1,COLUMN($L$12))))-1,0)))

I do not know how to define or dim or setup the variables to do that. Can somebody help me?

Thanks!

Actuariojf
This message was edited by Actuariojf on 2002-09-05 10:05

 

[Actuariojf]

This last function also works great!. Thanks a lot to all of you. I have learned a lot just for asking a few questions. From now on I will be visiting mrexcel.com more often.

Thanks!

Actuariojf