formulate all in one cell

[carrol]

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?

 

[ShaneDevenshire]

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.

 

[T. Valko]

Try this:

=SUMPRODUCT(10-ROW(INDIRECT("1:20")))

 

[Dave Curtis]

Hi,

Try using =SUM(10-ROW(A1:A20)) entered as an array formula using
Contol-Shift-Enter, instead of just Enter.

Dave

url:http://www.ureader.com/msg/104240746.aspx