Forum Discussion
how to calculate sum of the previous months by company
Thanks Sergei, the formula works but it calculates the sums as cumulative (for example, months from January to November should be zero, right?), December needs to be calculated as a sum from January to November, January 2018 as a sum from February to December 2017 etc. All that needs to be calculated by company so I added company column as a criteria in the sumifs formula. Should I add more criteria to get 0 for the first eleven months or use another formula different from sumifs? Thanks
Perhaps in your case PivotTable with the measure which calculates sum for previous from row content month eleven months will be more suitable. But that's optional. With SUMIFS you may skip first 11 month if add one more criteria that date shall be out of MIN(dates)+11 months.