sum only preceding cells?

[doug firr]

Hello
I have a table with the columns titled January to December.

For each month I'd to show the year to date sum/total at that point in time.

So, for example, March would sum the row from January to March. August would sum the row from January to August.

Is there a formula, or combination of formulas, that I could use to sum only preceding cells? So that, say March would sum only preceding cells Jan and Feb?

 

[Willmonbo]

it sounds simple unless I'm not getting the idea you want get done.

assuming your data to sum is in cell A1 use this

Sum($A$1:$A1) and drag it down to as many rows as needed, presumably to row 12

 

[doug firr]

Thanks a lot, that solves my problem