Excel sum formula without table - Equivalent to the Math Sum Symbol

Question

Is the Math Sum Symbol represented in an Excel formula? (Without a table required)

For example:

Without having to build a table, I would like to enter data into the X and n cells to cause the output of the above formula to appear in the Result cell.

Can it be done? How?

Answer 1

You can use SUMPRODUCT for this.

Assuming X is in cell B1, and n is in cell B2:

=SUMPRODUCT((B1+1)^ROW(INDIRECT("1:"&B2)))

ROW(INDIRECT("1:"&B2)) returns an array of the numbers between 1 and n, which SUMPRODUCT raises each X+1 by before summing.

Output