Sum for specific month

[sachin483]

I have data from which i would like sum the sales column from the month 202204 to 202302 & 202204 to 202303 for the code

			result	result
MONTH	code	SALES	ytd feb	ytd mar
202204​	XXX047	7117271​	73259860​	79218678​
202204​	XXX053	2828876​	29408031​	32476995​
202204​	XXX076	2024273​	22511160​	25096332​
202205​	XXX047	4689776​	73259860​	79218678​
202205​	XXX053	2253672​	29408031​	32476995​
202205​	XXX076	1982671​	22511160​	25096332​
202206​	XXX047	6127362​	73259860​	79218678​
202206​	XXX053	2629121​	29408031​	32476995​
202206​	XXX076	1988150​	22511160​	25096332​
202207​	XXX047	6729839​	73259860​	79218678​
202207​	XXX053	2781318​	29408031​	32476995​
202207​	XXX076	1876402​	22511160​	25096332​
202208​	XXX047	6840406​	73259860​	79218678​
202208​	XXX053	2512318​	29408031​	32476995​
202208​	XXX076	1626990​	22511160​	25096332​
202209​	XXX047	7238547​	73259860​	79218678​
202209​	XXX053	2571109​	29408031​	32476995​
202209​	XXX076	2390532​	22511160​	25096332​
202210​	XXX047	6742770​	73259860​	79218678​
202210​	XXX053	2663412​	29408031​	32476995​
202210​	XXX076	1883259​	22511160​	25096332​
202211​	XXX047	6550329​	73259860​	79218678​
202211​	XXX053	2413417​	29408031​	32476995​
202211​	XXX076	2058613​	22511160​	25096332​
202212​	XXX047	7144123​	73259860​	79218678​
202212​	XXX053	3076389​	29408031​	32476995​
202212​	XXX076	2205149​	22511160​	25096332​
202301​	XXX047	7470260​	73259860​	79218678​
202301​	XXX053	2947495​	29408031​	32476995​
202301​	XXX076	2123584​	22511160​	25096332​
202302​	XXX047	6609177​	73259860​	79218678​
202302​	XXX053	2730904​	29408031​	32476995​
202302​	XXX076	2351537​	22511160​	25096332​
202303​	XXX047	5958818​	0​	79218678​
202303​	XXX053	3068964​	0​	32476995​
202303​	XXX076	2585172​	0​	25096332​
202304​	XXX047	9116659​	0​	0​
202304​	XXX053	3577718​	0​	0​
202304​	XXX076	3164970​	0​	0​
202305​	XXX047	7871403​	0​	0​
202305​	XXX053	2970228​	0​	0​
202305​	XXX076	3288483​	0​	0​
202306​	XXX047	1067500​	0​	0​
202306​	XXX053	1117500​	0​	0​
202306​	XXX076	1167500​	0​	0​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C			F
1
2	MONTH	code	SALES
3	202204	XXX047	7117271			73259860
4	202204	XXX053	2828876			29408031
5	202204	XXX076	2024273			22511160
6	202205	XXX047	4689776			73259860
7	202205	XXX053	2253672			29408031
8	202205	XXX076	1982671			22511160
9	202206	XXX047	6127362			73259860
10	202206	XXX053	2629121			29408031
11	202206	XXX076	1988150			22511160
12	202207	XXX047	6729839			73259860
13	202207	XXX053	2781318			29408031
14	202207	XXX076	1876402			22511160
15	202208	XXX047	6840406			73259860
16	202208	XXX053	2512318			29408031
17	202208	XXX076	1626990			22511160
18	202209	XXX047	7238547			73259860
19	202209	XXX053	2571109			29408031
20	202209	XXX076	2390532			22511160
21	202210	XXX047	6742770			73259860
22	202210	XXX053	2663412			29408031
23	202210	XXX076	1883259			22511160
24	202211	XXX047	6550329			73259860
25	202211	XXX053	2413417			29408031
26	202211	XXX076	2058613			22511160
27	202212	XXX047	7144123			73259860
28	202212	XXX053	3076389			29408031
29	202212	XXX076	2205149			22511160
30	202301	XXX047	7470260			73259860
31	202301	XXX053	2947495			29408031
32	202301	XXX076	2123584			22511160
33	202302	XXX047	6609177			73259860
34	202302	XXX053	2730904			29408031
35	202302	XXX076	2351537			22511160
36	202303	XXX047	5958818			0
37	202303	XXX053	3068964			0
38	202303	XXX076	2585172			0
39	202304	XXX047	9116659			0
40	202304	XXX053	3577718			0
41	202304	XXX076	3164970			0
42	202305	XXX047	7871403			0
43	202305	XXX053	2970228			0
44	202305	XXX076	3288483			0
45	202306	XXX047	1067500			0
46	202306	XXX053	1117500			0
47	202306	XXX076	1167500			0
Main

Cell Formulas
Range	Formula
F3:F47	F3	=IF(A3<=202302,SUMIFS(C:C,A:A,"<="&202302,B:B,B3),0)

 

[sachin483]

Thanks a lot working fine

 

[Fluff]

You're welcome & thanks for the feedback.