I do not want to have to tell the user just insert SUMABOVE. Dim docNew as Document Dim tableNew as Table Set docNew DocumentsAdd Set tableNew docNewTablesAdd SelectionRange 3 3 With tableNew Cell 1 1RangeInsertAfter 10 Cell 2 1RangeInsertAfter 15 Cell 3 1AutoSum End With. SUM Calculates the sum of items identified inside the parentheses.
Likewise if you want to sum a column of numbers the formula will display as SUM ABOVE.
SUM Calculates the sum of items identified inside the parentheses. This will bring up the Formula dialog with a default of SUM LEFT. Sum an Entire Direction. To sum the numbers in the Amount column put the cursor in the last cell in that column.