Level up your Google Sheet Fu

So recently I have been doing a heap of spreadsheet work, trying to do some better modelling of costs and getting better insights into data generally.

For my current task I needed to be able to read in a dynamic list of items (which change all the time), and SUM them up over a number of months in another sheet. The ultimate goal was to not have add a new products then update the aggregate sheet.

So to demonstrate this, here is the outcome I was after (obviously this is generalised for this post). Below is the “sheet1” which shows a list of products and…