If you're attempting to sum a column of numbers and avoid summing the subtotals, then you might avoid the need for complex arrays by using the SUBTOTAL function.