How do you make a Google sheets "=QUERY" with formulas

0

I have the following Query.

=QUERY(ThisSheet!A2:V, "SELECT F, SUM(G),SUM("&ARRAYFORMULA(N("I")*24)&") SUM(J), AVG(K) Where F IS NOT NULL GROUP BY F")

The values in Column I is a type "Duration" and I need to Use the "QUERY" function to SUM the values in Column 'I'.

Could anybody please help me fix this query?

Bernard Walters

Posted 2019-11-06T05:01:29.620

Reputation: 121

Are you sure that arrayformula may be used in? Share the example file (or post sample data screenshot at least) and show desured result for that data with its logic explaination. – Akina – 2019-11-06T05:50:13.563

No answers

Asked: 2019-11-06T05:01:29.620

Viewed: 13 times

Active: 2019-11-06T06:27:48.393