Looking to speed up a spreadsheet build

[kameron]

So im building a spreadsheet for a game (to keep track of prices, purchases, item prices day by day, etc) and the table is coming along just fine, there is just one issue i have at the moment, well..its more of a time consuming process i want to kind of avoid if i can.

So i have a "gains to date" column in my table that pulls from 2 columns, sumns them and minuses them to produce the current amount of money i have obtained or lost.
Heres an example:

"gains to date" is at M13. i want to sum everything from E3:E13 and everything from I3:13, then take those two values and subtract them from each other, which will herald a result (essentially 31-30=-1, so it would display a "gains to date" of -1).

Currently i have =SUM(I3:I13)-SUM(E3:E13), which does work, the problem is i need the same thing in M14/15/16/17/18, etc. The problem is when i copy/paste i have to manually update the values (E3:E13 needs to be E3:E14), but if i want 3000 entries for instance, manually updating it all could and would take ages to do. I have heard of a Count/Counta function but im not sure that would work, given what i want the "gains to date" column to show.

What i want is something that constantly updates, so when i go to M235, it automatically updates the "gains to date" formula to =SUM(I3:I235)-SUM(E3:E245) without me having to go and manually update it.

I could update it as needed but i want to have the worksheet done so i only have to input values and wont have to do any further work.

Any ideas how i can do this?

(attached is my worksheet, with some sample data - EDIT: the table I'm working on is on Sheet 1)

[MarvinP]

Hi Kameron and welcome to the forum,

This looks like a job for.. (not Superman) Dynamic Named Ranges (DNR). Read about them and see if you can figure them out.
http://www.ozgrid.com/Excel/DynamicRanges.htm or
http://www.contextures.com/xlNames01.html or
http://www.vertex42.com/ExcelArticle...ed-ranges.html or
http://www.bettersolutions.com/excel...G820716330.htm (start with this one)

[kameron]

Thanks for the quick reply,

Unfortunately i don't quite get how to work those formulas, i never got THAT advanced in my excel class :P I suppose i shall be working with them for a bit until i figure them out. Ill leave this open in case anyone else has some hints/tips that may help

EDIT: that is i have fiddled with them a bit, i just am not sure how to use that, in order to sum up and minus data in order to get the value i want to see.