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
1	Sum of Units
2	Quarters	Date	Product	Total
3	Qtr1	Jan	Coats	241
4			Hats	382
5			Shoes	879
6		Feb	Coats	928
7			Hats	561
8			Shoes	1.385
9		Mar	Coats	1.270
10			Hats	1.493
11			Shoes	1.567
12	Qtr4	Okt	Coats	1.368
13			Hats	693
14			Shoes	133
15		Nop	Coats	1.666
16			Hats	1.431
17			Shoes	467
18		Des	Coats	1.805
19			Hats	3.129
20			Shoes	1.142

<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>
</tbody>

​

any help, much appreciated..

m.susanto

 

[muhammad susanto]

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