=SUM(C1:INDEX(C:C,B1))


where B1 holds the variable and C is the column you want to sum based on the
variable


--


Regards,


Peo Sjoblom



"P25_Sys_Arch" wrote in message
...
Does anyone know of an easy way to sum a function over a range of values
such
as from k=0 to k=N, where N is a variable in a cell?

Thanks,
--
P25 System Architect