Dynamic cumulative SUM RANGE - different months

I'm opening this thread on the advice from Pepe Le Mokko.
Please, also refer to this thread: Dynamic SUMIF(S) "sum range"

Hi again guys,

Now I'm trying to improve the functionality of the file attached above.
I've attached the file again with another drop-down menu. What I'm trying to do is to have a sum of
all the months between the two months indicated in the drop down menu.
For example by picking two months from the drop down menus, I want to know the sum of the values between Jan-Mar (Jan, Feb and Mar), or for example Jul-Oct (Jul,Aug,Sep and Oct)...

I've tried to combine SUMPRODUCT with INDEX and MATCH but it doesn't work.

I want to build upon this formula:

Formula:

Please Login or Register  to view this content.

Any ideas?...

IMPORTANT: Thanks to Debraj Roy for the quick reply, but I forgot to mention that I have multiple strings (column E) which are NOT unique. Basically "VLOOKUP way" won't help me, rather it should be "SUMIF way".

In the attached file I've added one additional row (r19), which is the same as r18, just to try how the summing will work.

Hi,

try this :

Please Login or Register  to view this content.

Hi,, Me agian..

try this..

Formula:

Please Login or Register  to view this content.

OOPS.. Lets try another one..

=SUMPRODUCT(($E$4:$E$40=S4)*(MONTH($F$2:$Q$2)>=MONTH($T$2))*(MONTH($F$2:$Q$2)<=MONTH($V$2)),$F$4:$Q$40)


PS: with a exception.. start date should be less than end date..

Since you have 1st day of each month in F2:Q2, instead of MONTH in Deb's formula, can use simply to >=T2, <=V2

=SUMPRODUCT((E$4:E$40=S4)*(F$2:Q$2>=T$2)*(F$2:Q$2<=V$2),F$4:Q$40)