Running Total Not Stopping In Qtr4 But Keep Going

[muhammad susanto]

hi all..

i need your help, how to make running total not stop in Qtr4 but keep running..
here my illustration :

Excel 2007

	A	B	C	D
Sum of Units
Quarters	Date	Product	Total
Qtr1	Jan	Coats
Hats
Shoes
Feb	Coats
Hats
Shoes
Mar	Coats
Hats
Shoes
Okt	Coats
Hats
Shoes
Nop	Coats
Hats
Shoes
Des	Coats
Hats
Shoes

<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=E0E0F0"" target="_blank"></colgroup><colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"] 241 [/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 382 [/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 879 [/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]

[TD="align: right"] 928 [/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 561 [/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1.385 [/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1.270 [/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1.493 [/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1.567 [/TD]

[TD="align: center"]12[/TD]
[TD="bgcolor: <a href="] Qtr4 [/TD]

[TD="bgcolor: <a href=, align: right"] 1.368 [/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 693 [/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 133 [/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1.666 [/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1.431 [/TD]

[TD="align: center"]17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 467 [/TD]

[TD="align: center"]18[/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1.805 [/TD]

[TD="align: center"]19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 3.129 [/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1.142 [/TD]

</tbody>

​

any help, much appreciated..

m.susanto

 

[muhammad susanto]

bump...how do running total in date Oct not stopping but keep running (cumulative)