sum only preceding cells?

doug firr

Board Regular
Joined
Mar 28, 2011
Messages
140
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?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Willmonbo

Board Regular
Joined
May 16, 2010
Messages
141
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,924
Messages
5,525,654
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top