Hallo,

I want to do the following:

=Sum(Index(Array,{1,6,7},8))

This formula only gives me the value in row 1 column 8 and not the sum of all three rows column 8. Please help.