Hi,

I can't say as I understand your question but here is the formula you asked
for:

=SUM(10-ROW(A1:A20))

array entered.

--
Thanks,
Shane Devenshire


"carrol" wrote:

how to sum an equation that subjected to array of number in one cell? Let
formula be "10-a" and the "a" required from 1 to 20, and all this to be done
in one single cell, is it possible?