Hi. If you have an array of constant coefficients, would you prefer to use
an equation instead?

r = 1.005
n = 6

?(r*(r^n-1))/(r-1)
6.1058793881469

n=360
?(r*(r^n-1))/(r-1)
1009.53761766488

I hope I got this correct.... :)
--
Dana DeLouis
Win XP & Office 2003


"RK" wrote in message
...
I've been trying to get SERIESSUM to work for a long list of automatically
generated coefficients.

=SERIESSUM(1.005,1,1,{1,1,1,1,1,1}) works very well. I can create the
array of ones using VBA too by creating a function that has the number of
ones desired as the input and the array as type variant output.

My question: Is there a worksheet function that can generate an array of
ones. Normally an array of 6 ones is not a problem but I need to generate
an array consisting of anywhere from 200 - 360 ones that can be done on
the fly without storing the ones in a column.

I've scratched my head for a while but seem to find that the VBA method is
the only way this can be done. Any suggestions for a non-VBA or non-column
method?

Thanks,
RK