Excel spilled range ... on—you need to add a hash sign after the criteria reference. Instead of typing the formula manually, if you use your mouse to select the cells for each argument, the ...

If you select a cell ... out. Select F13 and press tab to insert a new record into TableSales (the Table object). Tab over to D14 and enter Alice. Immediately, the lists in columns J and K update ...