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 365 views

## 1 answer to this question.

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,720 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