In Excel, with the orders data converted to a Table named Orders, type the formula that totals its amount column by name.

Answer

=SUM(Orders[amount])

Table[column] is a structured reference. It returns 6140 now and keeps covering new rows as they are appended to the table.