Try this:

=SUMPRODUCT(1+ROW(INDIRECT("1:20")))

--
Biff
Microsoft Excel MVP


"carrol" wrote in message
...
what if i have a formula, lets say 1+a , whereby i need to get the sum of
this "1+a" for a = 1 to 20??