Rolling sum of 12 months against each month based on two criteria

your example is not very clear - you should provide some expected results. for e.g., is 'rolling 3 month' current month minus 2 or minus 3? should rolling months' calculations filter by 'sales' / 'stock' or include both?

anyway, here is a simple and extensible formula. you should be able to adapt the components of this formula to your needs fairly easily.

this one is for Rolling 3 Month and goes into Sheet1!D4:

Please Login or Register  to view this content.

change the highlighted -2 to -11 to get Rolling 12 Month values and put the formula in Sheet1!E4.

then, highlight both and drag-fill down.

you will need Analysis Toolpak Add-in installed for this to work.

UPDATE:

another version using MMULT - applicable to Rolling 3 Month,

Please Login or Register  to view this content.