I created a sheet that has a primary column for "product type" and additional columns with months listed for the next two years (Dec '20, Jan '21, Feb '21, etc.) which indicates the month in which those products will be implemented. I then have 3 rows for 3 different product types. This data is pulled from a Summary Sheet. It looks something like this:

Product Type Nov '20 Dec '20 Jan '21

Product Type 1 2 1 1

Product Type 2 2

Product Type 3 1 2 5

All Products 3 5 6

I used the following formula to count how many of each product type will be implemented each month for the next two years (with dates adjusted for each month):

Nov '20: =COUNTIFS({Summary Sheet Range 1}, "product type 1", {Summary Sheet Range 2}, >=DATE(2020, 11, 1), {Summary Sheet Range 2}, <=DATE(2020, 11, 30))

I created two columns to roll the data up to count how many (of all product types) will be implemented each month:

I then created two additional columns "Month" and "Implementations", which I used in the attached dashboard view.

Is it possible to create a view of the above chart that will show a rolling 12 months automatically?