Sum range data in current month

[adnandmth]

How to sum range only data in current month?

for instance;

[TABLE="width: 300"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]0[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


I want dynamically sum the range A:L but the result should only count from first (A) to the current month (Aug), how do I achieve this goal?

 

[FormR]

Hi, here is one option:

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec		Sum
2	1	0	0	2	4	5	0	0	8	9	0	2		12
Sheet1

Cell Formulas
Range	Formula
N2	=SUM(A2:INDEX(A2:L2,MONTH(TODAY())))

 

[adnandmth]

Hi FormR, thanks for the quick reply,


[TABLE="class: outer_border, width: 300"]
<tbody>[TR]
[TD]A[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD][/TD]
[TD]Sum[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Joined Date[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20/02/2019
[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Actually I have another problems in my case;
1. the sum function should start from the month where the person was joined +1, I mean if a person joined in feb then starts from march and so on
2. and the range should stop in the current month -1, current month is august then range should be between March and Jul

Could you help me to achieve this goal??
[TABLE="width: 85%"]
<tbody></tbody>[/TABLE]

 

[FormR]

Hi, something like this maybe:

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Joined Date	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec		Sum
2	20/02/2019	1	0	2	3	5	0	0	8	7	2	2	2		10
Sheet1

Cell Formulas
Range	Formula
O2	=SUM(INDEX(B2:M2,MONTH(A2)):INDEX(B2:M2,MONTH(TODAY())-1))