Hi,
I'm trying to create a summary sheet where it looks at a data sheet for an item and a period, then sums up the previous 3 quarterly periods plus the current one ie Last twelve months
So here id need to formula in cell B4 to get the total 500.
I have been using sum product and specifying the columns to look at but the columns in the dataset have the potential to move so I want to ensure that the calculation of prior 3 quarters + specified quarter, for that product, always works.
Is there a better way? Maybe offset?
I'm trying to create a summary sheet where it looks at a data sheet for an item and a period, then sums up the previous 3 quarterly periods plus the current one ie Last twelve months
So here id need to formula in cell B4 to get the total 500.
I have been using sum product and specifying the columns to look at but the columns in the dataset have the potential to move so I want to ensure that the calculation of prior 3 quarters + specified quarter, for that product, always works.
Is there a better way? Maybe offset?