Excel_LuyKe_Mau.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	HƯỚNG DẪN LŨY KẾ (ví dụ) — Nếu Excel của bạn dùng dấu phẩy, hãy đổi mọi dấu ';' trong công thức thành ','
2	Ngày	Nhóm	Giá trị	Lũy kế cơ bản	Lũy kế theo Nhóm	Tháng	Lũy kế theo Ngày (<=)	Lũy kế theo Ngày + Nhóm	Lũy kế theo Tháng + Nhóm	Lũy kế khi lọc (chỉ hàng hiển thị)	SCAN (Excel 365) — công thức đặt tại K3, kết quả tràn xuống

3	2025-01-04	A	567,879	567,879	567,879	45,688	1,212,564	567,879	567,879	567,879	567,879
4	2025-01-04	C	644,685	1,212,564	644,685	45,688	1,212,564	644,685	644,685	#VALUE!
5	2025-01-05	A	862,038	2,074,602	1,429,917	45,688	2,074,602	1,429,917	1,429,917	#VALUE!
6	2025-01-17	C	1,087,293	3,161,895	1,731,978	45,688	3,821,774	2,391,857	2,391,857	#VALUE!
7	2025-01-17	C	659,879	3,821,774	2,391,857	45,688	3,821,774	2,391,857	2,391,857	#VALUE!
8	2025-01-23	A	103,247	3,925,021	1,533,164	45,688	5,077,897	2,686,040	2,686,040	#VALUE!
9	2025-01-23	A	1,152,876	5,077,897	2,686,040	45,688	5,077,897	2,686,040	2,686,040	#VALUE!
10	2025-01-24	C	687,086	5,764,983	3,078,943	45,688	6,378,539	3,078,943	3,078,943	#VALUE!
11	2025-01-24	B	613,556	6,378,539	613,556	45,688	6,378,539	613,556	613,556	#VALUE!
12	2025-01-26	A	822,139	7,200,678	3,508,179	45,688	7,200,678	3,508,179	3,508,179	#VALUE!
13	2025-02-01	B	512,315	7,712,993	1,125,871	45,716	7,712,993	1,125,871	512,315	#VALUE!
14	2025-02-04	B	1,006,075	8,719,068	2,131,946	45,716	8,719,068	2,131,946	1,518,390	#VALUE!
15	2025-02-09	B	596,588	9,315,656	2,728,534	45,716	9,315,656	2,728,534	2,114,978	#VALUE!
16	2025-02-13	A	1,058,732	10,374,388	4,566,911	45,716	10,374,388	4,566,911	1,058,732	#VALUE!
17	2025-02-18	B	128,984	10,503,372	2,857,518	45,716	10,503,372	2,857,518	2,243,962	#VALUE!
18	2025-02-20	A	382,918	10,886,290	4,949,829	45,716	10,886,290	4,949,829	1,441,650	#VALUE!
19	2025-02-22	B	344,712	11,231,002	3,202,230	45,716	11,231,002	3,202,230	2,588,674	#VALUE!
20	2025-02-23	C	213,767	11,444,769	3,292,710	45,716	11,444,769	3,292,710	213,767	#VALUE!
21	2025-02-24	C	728,663	12,173,432	4,021,373	45,716	12,173,432	4,021,373	942,430	#VALUE!
22	2025-02-26	A	216,330	12,389,762	5,166,159	45,716	12,389,762	5,166,159	1,657,980	#VALUE!
23	2025-03-01	C	560,754	12,950,516	4,582,127	45,747	12,950,516	4,582,127	560,754	#VALUE!
24	2025-03-02	C	93,986	13,044,502	4,676,113	45,747	13,044,502	4,676,113	654,740	#VALUE!
25	2025-03-03	B	666,146	13,710,648	3,868,376	45,747	13,803,314	3,868,376	666,146	#VALUE!
26	2025-03-03	A	92,666	13,803,314	5,258,825	45,747	13,803,314	5,258,825	92,666	#VALUE!
27	2025-03-04	B	214,633	14,017,947	4,083,009	45,747	14,017,947	4,083,009	880,779	#VALUE!
28	2025-03-05	B	368,998	14,386,945	4,452,007	45,747	16,026,658	6,091,720	2,889,490	#VALUE!
29	2025-03-05	B	930,937	15,317,882	5,382,944	45,747	16,026,658	6,091,720	2,889,490	#VALUE!
30	2025-03-05	B	708,776	16,026,658	6,091,720	45,747	16,026,658	6,091,720	2,889,490	#VALUE!
31	2025-03-07	B	1,159,111	17,185,769	7,250,831	45,747	18,261,876	8,326,938	5,124,708	#VALUE!
32	2025-03-07	B	1,076,107	18,261,876	8,326,938	45,747	18,261,876	8,326,938	5,124,708	#VALUE!
33	2025-03-15	B	918,688	19,180,564	9,245,626	45,747	19,180,564	9,245,626	6,043,396	#VALUE!
34	2025-03-18	A	431,279	19,611,843	5,690,104	45,747	20,605,753	5,690,104	523,945	#VALUE!
35	2025-03-18	C	993,910	20,605,753	5,670,023	45,747	20,605,753	5,670,023	1,648,650	#VALUE!
36	2025-03-19	B	569,570	21,175,323	9,815,196	45,747	21,175,323	9,815,196	6,612,966	#VALUE!
37	2025-03-23	B	104,538	21,279,861	9,919,734	45,747	21,279,861	9,919,734	6,717,504	#VALUE!
38	2025-03-26	B	974,498	22,254,359	10,894,232	45,747	22,254,359	10,894,232	7,692,002	#VALUE!
39	2025-03-30	B	281,664	22,536,023	11,175,896	45,747	22,536,023	11,175,896	7,973,666	#VALUE!
40	2025-03-31	B	571,234	23,107,257	11,747,130	45,747	23,326,439	11,966,312	8,764,082	#VALUE!
41	2025-03-31	B	219,182	23,326,439	11,966,312	45,747	23,326,439	11,966,312	8,764,082	#VALUE!
42	2025-04-01	C	264,064	23,590,503	5,934,087	45,777	23,590,503	5,934,087	264,064	#VALUE!
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100