Help with drop down menu and auto calculation as month changes

[zamal264]

Hi,

Please help with the attached sample... I would like to create a drop down menu that will automatically change the 5 year sum and division formula when the month changes.

Thank you

[teylyn]

You can't change the formula based on the dropdown, but you can tell the formula to find the value of the dropdown and add up that cell and the next 59.

try

=SUM(INDEX(E:E,MATCH(B91,C:C,0)):INDEX(E:E,MATCH(B91,C:C,0)+59))/SUM(INDEX(H:H,MATCH(B91,C:C,0)):INDEX(H:H,MATCH(B91,C:C,0)+59))

[zamal264]

Thank you so much..It worked