I am utilizing a SUMIFS formula to sum volume from multiple rows based on multiple criteria.
I would like to incorporate another formula into my current SUMIFS formula or create new formula in order to calculate a moving sum, last 3 months instead of total (month indicated in additional column K.)
I would also like to calculate a 3 month moving average based on the criteria from my SUMIFS in column C. (Customer & Region) + Month
Please see attached Spreadsheet, is it a problem that the months are formatted as text?
Revised_Multile vlookup values Then Sum-Example TMS.xlsx
Thank you,
Price
Bookmarks