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?

Dec 11, 2022 in Others 266 views

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

• 63,420 points

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE