dynamic formula to blanket cells in table with different periods and durations.

Interesting question, tommyd717. Thank you for asking!

The OFFSET function, I believe, can be used to return a reference to a range of cells in a table that is a specified number of rows and columns away from the starting cell. Additionally, use the SUM function to add up the values in a series of cells. This means you can create a formula that spans multiple cells and has different periods and durations.

The formula I am describing above is:

=SUM(OFFSET(A1,0,0,B1,1))

Please let me know if you require further information on how the formula works.