Sum funtion by selecting the range from drop down list

[varun.kalra1988]

Hi

I have one tab in which I have net sales amount of all the months i.e. January to December in sheet2.

I have put drop down list in sheet 1 to select period . i.e period from - to -

The user will select the period from in cell G4 & period to I4.

I want the formula which can automatically calculate the Sum of selected period(for say August to November)

I am not sure how to use the sum formula with the dynamic ranges

Please find attached the dummy file for your reference.

Thanks for your help in advance.

[Ace_XL]

Try

=SUM(INDEX(Sheet2!E7:P7,MATCH(G4,Sheet2!E4:P4,0)):INDEX(Sheet2!E7:P7,MATCH(I4,Sheet2!E4:P4,0)))

[varun.kalra1988]

Perfect..

Thanks a Lot

[sktneer]

If that takes care of your original question, please select Thread Tools from the menu link just above your first post and mark this thread as SOLVED.