# Looking for better math

#### Cormanthor

##### New Member
I have a sheet that calculates the different experience points needed to gain levels in a game. I currently have a column of levels (1-30, consecutively) and another column with the formula =250*(A1^2+A1)/2
This formula yields the difference needed to gain the next level (250 to gain level 2, 750 more to gain level 3, and so on).
I would like a way to find the total experience points needed directly, without the aid of these columns (example: level 10 needs 41,250 experience). Currently I have to add B1:B9 to get this info.
Any idea what math / formula I need to use to get here from a cold start? Is this even possible?

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

#### Canapone

##### Active Member
Hi,

level 10:

=SUMPRODUCT(250*(ROW(1:9)^2+ROW(1:9))/2)

level 11:

=SUMPRODUCT(250*(ROW(1:10)^2+ROW(1:10))/2)

and so on.

#### Canapone

##### Active Member
Hi again

you could use C1 to house level reference

 =SUMPRODUCT(250*(ROW(INDIRECT("1:"&C1-1))^2+ROW(INDIRECT("1:"&C1-1)))/2)

<tbody>
</tbody>

Regards

#### Snakehips

##### Well-known Member
Provided input in A2 is limited to 2 to 30 then maybe..
Excel Workbook
AB
1To access levelPoints Required
21041250
Sheet7

Hope that helps.

#### Cormanthor

##### New Member
Hi,

level 10:

=SUMPRODUCT(250*(ROW(1:9)^2+ROW(1:9))/2)

level 11:

=SUMPRODUCT(250*(ROW(1:10)^2+ROW(1:10))/2)

and so on.

Hi again

you could use C1 to house level reference

 =SUMPRODUCT(250*(ROW(INDIRECT("1:"&C1-1))^2+ROW(INDIRECT("1:"&C1-1)))/2)

<tbody>
</tbody>

Regards

Absolutely BEAUTIFUL on both counts! Thank you very much!

Best Regards,
Cormanthor

Replies
1
Views
133
Replies
4
Views
170
Replies
6
Views
301
Replies
2
Views
165
Replies
17
Views
815

1,191,204
Messages
5,985,261
Members
439,953
Latest member
suchitha

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back