Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for cumulative total
Is there a way to write a cumulative formula so when it is copied across a
row it sums the prior data in another row? For example: Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05 100 |
#2
|
|||
|
|||
Dave, Assuming that row 1 is your headers, Oct-04, Nov-04 etc, and that row 2 is a quantity, 100, 120, etc then in cell A3 put =sum($a2:a2) and formula-drag that across the row. Dave Wrote: Is there a way to write a cumulative formula so when it is copied across a row it sums the prior data in another row? For example: Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05 100 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=470083 |
#3
|
|||
|
|||
Hi,
Supposing that the column headers (i.e., months) are in Row 1 (starting at Column A), and the data (e.g., 100 under Oct-04) are in Row 2, enter the following formula in A3, =SUM($A$2:A2) and drag the formula across Row 3 to as many columns as you want. The cumulative totals will show up in Row 3. Regards, B. R. Ramachandran "Dave" wrote: Is there a way to write a cumulative formula so when it is copied across a row it sums the prior data in another row? For example: Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05 100 |
#4
|
|||
|
|||
Could you be more specific about what is in addresses and data that you want to
sum and the address for the sum formula.- --- "Dave" wrote in message ... Is there a way to write a cumulative formula so when it is copied across a row it sums the prior data in another row? For example: Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05 100 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |