Sum by Month

Question

Hi,&nbsp;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.&nbsp;&nbsp;Can you please help me with ... put the formula in my attached file. Thanks much!&nbsp;

sergeibaklan · Answer

sbhan4&nbsp;
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 · Answer

SergeiBaklan&nbsp;&nbsp;Thank you for your quick help!. Can you please attach a solution excel sheet.

sergeibaklan · Answer

sbhan4&nbsp;
It is attached to my previous post, please check at bottom.

sbhan4 · Answer

SergeiBaklan&nbsp;. 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?

sergeibaklan · Answer

sbhan4&nbsp;
In general it's better to use PivotTable with grouping dates on months and years.&nbsp;
You may use SUMPRODUCT or SUMIFS as well with MONTH() and YEAR() inside to filter periods.&nbsp;
&nbsp;
It depends on your source data structuring and in which form you'd like to have the result.

Forum Discussion

Sum by Month

5 Replies

Resources