Menu
How to hide columns in Google Sheets using keyboard shortcuts. To hide a column using a keyboard shortcut, first click on the column header and then use the following shortcut: Control + ALT + 0 (or Command + Option + 0 on a Mac). This shortcut will hide the column(s) you've selected.
Open the sheet that you want to edit. Click on the number in front of the first row. Click on “Insert.” and select “Row above.” You should now get a new, blank row on the top of the document. Enter the name of each column in the cells of the first row.
You can use the label clause in a Google Sheets query to create specific labels for the results of certain columns. In this example, we select all columns in the range A1:C13 and we label column A as 'Column A' in the resulting output.
Try this:
=QUERY(H4:L35,"select sum(L) where H='First Week' label sum(L) ''")
Hope that Helps!
=QUERY(QUERY(A1:D, "SELECT *", 1), "SELECT * OFFSET 1", 0)
The outer query: "SELECT * OFFSET 1" excludes the first row (the header).
The inner query explicitly specifies one row of headers (via the third argument supplied to QUERY), whilst the outer query specifies none.
=INDEX(QUERY(H4:L35;"select sum(L) where H='First Week'"; -1),2,1)
This just parses the returned array and selects the 2nd record returned in the first column.
You can also do this with the filter function which is less compute intensive.
=SUM(FILTER(L4:L35, H4:H35 = "First Week"))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With