Forum Discussion

sbhan4's avatar
sbhan4
Copper Contributor
Sep 24, 2020

Sum by Month

Hi,   I am trying Sum by month but no luck. Please see my attached excel data. The first tab has datewise data and 2nd tab is for monthly sum calculations.     Can you please help me...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 24, 2020

sbhan4 

PivotTable for such aggregations is better, but as variant you may use

=SUMPRODUCT((Data!$B$2:$B$14)*(TEXT(Data!$A$2:$A$14,"mmmm")=Sum!A13))

here

  • sbhan4's avatar
    sbhan4
    Copper Contributor
    Sep 24, 2020

    SergeiBaklan 

     

    Thank you for your quick help!. Can you please attach a solution excel sheet.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 24, 2020

      sbhan4 

      It is attached to my previous post, please check at bottom.

      • sbhan4's avatar
        sbhan4
        Copper Contributor
        Oct 04, 2020

        SergeiBaklan . Thanks. How can i do the Sum by Month and Year? For example if there is data for multiple year and i need data for particular year what i need to do?

Resources