Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=SUM(CHOOSE(2,B1

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