Dear All,

I was trying to add certain values of corresponding text , i used the index function but it only return the first value only don't add , And i can't use the sum as i want to apply this in more than table whit different length , so every time i want it to search for correspond values of an exact text

Formula I use

=(INDEX($C$1:$C$99,MATCH("LTD Result",$B$1:$B$99,0)))

and as seen it only return only the first value not the sum

excel iss2.png

Kindly advice.