Looking for better math

[Cormanthor]

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?

 

[Canapone]

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]

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]

Provided input in A2 is limited to 2 to 30 then maybe..

Excel Workbook
	A	B
1	To access level	Points Required
2	10	41250
Sheet7

Hope that helps.

 

[Cormanthor]

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