Sep 24 2020 01:25 PM
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 with ... put the formula in my attached file. Thanks much!
Sep 24 2020 01:33 PM
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
Sep 24 2020 01:49 PM
Sep 24 2020 02:27 PM
It is attached to my previous post, please check at bottom.
Oct 04 2020 10:21 AM
@Sergei Baklan . 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?
Oct 04 2020 12:01 PM
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.