Here is the generic formula to get sum by month in Excel=SUMPRODUCT(sum_range,–( TEXT(date_range,”MMM”)=month_text)) Manytimes, we want to calculate some values by month. Like, how much sales was done in a perticular month. Well this can be done easily using pivot tables, but if you are trying to have a dynamic report than we can use a Read More