217542/excel-formula-without-table-equivalent-the-math-sum-symbol

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?

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

Hi so basically, create an adjacent column ...READ MORE

Try this: =IF(OR(A3-FLOOR(A3,1)>0.95,A3=CEILING(A3,1)),CEILING ...READ MORE

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

It should look something like this: READ MORE

Hello, yes u can find your birthdate using ...READ MORE

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

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

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

Excel has recently introduced a huge feature ...READ MORE

If the cells in a row have ...READ MORE

OR

At least 1 upper-case and 1 lower-case letter

Minimum 8 characters and Maximum 50 characters

Already have an account? Sign in.