Excel 2007/2010 Table Object Running Total

Question

How do I calculate a running total in an Excel 2007/2010 table object? If you don't know what a table object in Excel is please DO NOT respond with a "=[the cell above] + [the cell adjacent]" type formula as I have found no way to actually do this in a table.

Answer 1

Figured it out. Here is what I did.

1. Added a column called "Row Number" which had the formula "=ROW(1:1)" and it auto copied down.
2. Created a new column called "Number Attrited YTD" and set formula to "=SUMIF([Row Number],"<="&ROW([@[Number Attrited]])-1,[Number Attrited])"

This worked as expected. If the data gets resorted it will throw off a YTD count but my data stays sorted by month so this is not an issue.