TIL how to make SQL-like queries on data in Google Sheets, which is making my anxiety-driven finance-reviewing much weirder.

Give your chart a "NamedRange" name (Data | Named Ranges), then you can call QUERY() which takes 2 arguments: the NamedRange (in my case "Spending") and the query you want (in my case this is selecting the dollar amount in column F from any row where the store name @ column B is my liquor store).

I'm SUMming that QUERY and dividing by a certain number of days (@ B24) to get a "$AMOUNT spent at $STORE per-day" value.

=SUM(QUERY(Spending, "select F where B = 'ABC Liquors'"))/B24

(It's not good.)