# Thread: Sum range data in current month Thanks: 0 Likes:  1 Post #5332438 (1)

1. ## Sum range data in current month

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

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?

2. ## Re: Sum range data in current month

Hi, here is one option:

Excel 2013/2016
ABCDEFGHIJKLMN
1JanFebMarAprMayJunJulAugSepOctNovDecSum
210024500890212

Sheet1

Worksheet Formulas
CellFormula
N2=SUM(A2:INDEX(A2:L2,MONTH(TODAY())))

3. ## Re: Sum range data in current month

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

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

4. ## Re: Sum range data in current month

Hi, something like this maybe:

Excel 2013/2016
ABCDEFGHIJKLMNO
1Joined DateJanFebMarAprMayJunJulAugSepOctNovDecSum
220/02/201910235008722210

Sheet1

Worksheet Formulas
CellFormula
O2=SUM(INDEX(B2:M2,MONTH(A2)):INDEX(B2:M2,MONTH(TODAY())-1))