Sum range data in current month

[adnandmth]

How to sum range only data in current month?

for instance;

A	B	C	D	E	F	G	H	I	J	K	L
Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
1	0	0	2	4	5	0	0	8	9	0	2

<tbody>
</tbody>

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,

A

C

D

E

F

G

H

I

J

K

L

M

N

Sum

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Joined Date

20/02/2019

1

0

2

3

5

0

0

8

7

2

2

2

<tbody>
</tbody>

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??

<tbody></tbody>

 

[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))