Forum Discussion
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...
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
It is attached to my previous post, please check at bottom.
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?
In general it's better to use PivotTable with grouping dates on months and years.
You may use SUMPRODUCT or SUMIFS as well with MONTH() and YEAR() inside to filter periods.
It depends on your source data structuring and in which form you'd like to have the result.