Google Sheets Query example
Grouping data and calculating total sales by each salesperson.
=QUERY(A1:D11, "SELECT B, C, SUM(D)
WHERE B IS NOT NULL
GROUP BY B, C
LABEL B 'Salesperson', C 'Product', SUM(D) 'Total Sales'")
Grouping data and calculating total sales by each salesperson.
=QUERY(A1:D11, "SELECT B, C, SUM(D)
WHERE B IS NOT NULL
GROUP BY B, C
LABEL B 'Salesperson', C 'Product', SUM(D) 'Total Sales'")