Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=SUM(B2

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