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