Lookup Reference Functions MSOfficeExcel 2007 Tutorial

Input the formula: =SUM(CHOOSE(2,B1:B3,C1:C3)). Press Enter to get the result.