CHOOSECOLS is the function you need to use to extract data from the Shop and Tot columns, Sales is the name of the table containing the array, and [#ALL] tells Google Sheets that you want the ...