Use Hlookup to find then sum column within specific dates

  • I am trying to expand this example to sum the values in the appropriate column between the specified dates.
    The lookup value, start and end dates are changeable


    I am currently using the following formula in the result box, but don't know how to limit the result to the specified date range.


    =SUM(INDEX($A5:$E17,0,MATCH($B$1,$A$5:$E$5,0)))


    I have attached a pic for more clarity.


    [ATTACH=CONFIG]69741[/ATTACH]


    Thanks for your help.


    Lookup Val ab Start Date End Date
    1/1/15 5/1/15
    Result 6419 =SUM(INDEX($A5:$E17,0,MATCH($B$1,$A$5:$E$5,0)))

    a ab abc abcd abcde
    1/1/2015 360 240 407 843
    2/1/2015 955 435 956 312
    3/1/2015 254 364 456 932
    4/1/2015 564 102 372 747
    5/1/2015 592 801 484 127
    6/1/2015 743 43 596 972
    7/1/2015 333 989 536 700
    8/1/2015 393 542 138 617
    9/1/2015 610 275 142 248
    10/1/2015 96 451 339 734
    11/1/2015 938 151 602 360
    12/1/2015 581 787 646 50