Summing YTD and Last 12 months

[ptmuldoon]

I may be may be over thinking this more than is necessary, but can't get my head around the formula to sum up a dynamic range of columns.

Essentially, I am placing a date into a cell. And have a table of data that shows the last 24 months of data.

I am trying that when the user enters a date, it would return the following information

the current month vs the prior year month
The sum of last 12 months (TTM) vs the prior year last 12
the year to date (Jan is first month, vs the prior year YTD

And I would restrict the user input to only allow a date in the last 12 months. Thus, including 24 months of data should cover the time frame.

I'm not sure if some type Sum function with an Index/Match or Offset is the way to go or not?

Little sample attached with 24 months of data for a row of the data.

[ptmuldoon]

I think I got it figured out with a SumIf function like such:

[code
=SUMIFS(G7:AE7, G6:AE6, ">"&EDATE(A2,-12), G6:AE6, "<="&A2)
[/code]