SUM(B2:B11) You might prefer to use Excel's built-in Total Row function to force Excel to calculate the total automatically.