Google Sheets: How to replace text in column header?
=QUERY(B2:C9;”select (C*100/B)-100 label (C*100/B)-100 ‘Value'”) https://developers.google.com/chart/interactive/docs/querylanguage#Label
google-sheets-query
QUERY syntax using cell reference
Copied from Web Applications: =QUERY(Responses!B1:I, “Select B where G contains ‘”&$B1&”‘”)
Google SpreadSheet Query: Can I remove column header?
Try this: =QUERY(H4:L35,”select sum(L) where H=’First Week’ label sum(L) ””)