Sum different multiple columns based on Month Selected

[victoria2207]

Good Morning,

I have a spreadsheet with the months of the year starting from column C with forecast values in the hundreds of rows below.

I am looking for a formula that, if I select the current month in a drop down box, it will sum the next 3, 6 and 9 months totals automatically without having to change the formula every time.

So if I select March 18 - in the 3 month forecast column it will sum April - June and the 6 month forecast column will forecast April to Sept and so on.

Thank you in advance.

Vic2207

 

[Peter_SSs]

Thanks Peter - These are good options and I'm going to try both to see what suit my various projects best. I'm learning so much through this forum! Its brilliant.

You are welcome.

 

[RCBricker]

Sorry about that I was out of pocket and unable to get to Mr. Excel.