Lookup Reference Functions MSOfficeExcel 2007 Tutorial

Input the formula: =SUM(B2:INDEX(A2:C6,5,2)). Press Enter to get the result.