I have a query() that outputs a table with two columns (A and B) of numbers. Pictured in IMAGE #1.
=QUERY(myData!A:G, "Select E,F WHERE D ='Books'")
But I need a function that outputs only three values. Pictured in the green row of IMAGE #2. The number of rows is variable.
- Sum of column A
- Sum of column B
- Sum of column C (column C is the product of A*B)
Thanks for any help you can provide!