formulate all in one cell
 

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?

formulate all in one cell
 

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?

formulate all in one cell
 

Try this:

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

--
Biff
Microsoft Excel MVP


"carrol" wrote in message
...
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?

formulate all in one cell
 

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