I have a huge table with data that I want to query. I can look up individual values using a combination of Index and Match but when I want to sum a range using Index / Match as references, it adds up the tow values defined as the range rather than the range itself.

The top row of the table are Months so if I want to sum 12 months, the formula i developed is: =SUM(INDEX(ELE!$A$1:$AQ$5;MATCH(Report!$A4;ELE!$A$1:$A$5;0);MATCH(Report!B$4;ELE!$A$1:$AM$1;0)-11);INDEX(ELE!$A$1:$AQ$5;MATCH(Report!$A4;ELE!$A$1:$A$5;0);MATCH(Report!B$4;ELE!$A$1:$AM$1;0)))

But this adds up the 1st and 12th month, not the range. Any insight?