Results 1 to 4 of 4

Thread: Sum range data in current month

  1. #1
    New Member
    Join Date
    Mar 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #2
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    6,089
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    2 Thread(s)

    Default 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())))

    [code]your code[/code]

  3. #3
    New Member
    Join Date
    Mar 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #4
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    6,089
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    2 Thread(s)

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

    [code]your code[/code]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •