Problem: Sum a list of values, the number of values determined by cell B1.

Solution: Type SUM(OFFSET(A1,0,0,B1,1)) or SUM(INDIRECT("A1:A"&B1) )

SUM(number1;[number2];