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 ...

Google Sheets is a powerful tool for data analysis, offering a range of functionalities that cater to both beginners and intermediate users.