I’m working on a Google Sheets project where I need to generate a summary table from a dataset. The dataset includes columns for categories and subcategories, and I want to create a new table where:

I have a Google sheet question. I use a formula to sum all values of a column that contains keywords in an other column. I use this formula :

I’m comparing 2 columns
some values are missing from column b (1st column)
can you please help me how to use query function to return missing values.
I know that I can use filter and match and isna function, but I was told to use query function

text
enter image description here
A food name will be shown on col ‘First meal’ when a checkbox is checked, but it is auto sort if multiple checkbox are checked.