formulate all in one cell

  • Thread starter Thread starter carrol
  • Start date Start date
C

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?
 
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.
 
Back
Top