Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Lookup Reference Functions
=SUM(OFFSET (A3,1,2,50,1))
Input the formula: =SUM(OFFSET (A3,1,2,50,1)). Press Shife+Control+Enter to get the result.