19 июн. 2023 г. · I have a Google sheet with 3 columns Date, Customer and Total. I have written a formula that groups each line that has the same date and customer and totals ...

21 дек. 2022 г. · I would like to include a column in my query function that calculates the max value of each row in the query's columns 2-7.

31 авг. 2018 г. · The column a , b are strings and c is a number. How can I include in this query one calculated field, c/sum(c) ? google-sheets ...

6 янв. 2024 г. · I have a Google Sheet with many tabs. I want to add the value in cell AH1 of each sheet tab to the result of the following formula:

15 янв. 2024 г. · I am looking to create a query that has some conditional column selections within it. I need the query to reference and return several fixed columns as well as ...

9 февр. 2019 г. · I understand how to do arithmetic on a column using a query function as long as I'm using a fixed constant. However, if I try to do the same using a cell ...

25 сент. 2021 г. · I would need to obtain all required calculated fields directly from the query and then to order by, or to find a way to sort the result combining the query and ...

15 дек. 2020 г. · I'm trying to count all cells that match a regex patterns. So far I've come up with a solution using a query per column, and then using SUM() to sum the counts ...

15 апр. 2016 г. · Obviously, this is returning columns A and B of the referenced data However, I would like to also return the corresponding cells from column C.

28 сент. 2020 г. · I am trying to select column A, count column A and column B and group by A. But when I do that, count B return the same count as A.