``````Name | Value
A    | 10
B    | 100
A    | 20
B    | 200
C    | 1000
``````

How can I create another table based on a query:

``````select name, sum(value), count(value) from table group by name
``````

so it looks like this:

``````Name | SUM   | COUNT
A    | 30    | 2
B    | 300   | 2
C    | 1000  | 1
``````

By using the `QUERY` function you can achieve your goal.

## Formula

``````=QUERY(Data!A1:B6;"select A, sum(B), count(B) group by A")
``````

## Screenshot

Using other functions, makes it achievable as well.

``````add this formula in A2:
=UNIQUE(Data!A2:A)

add the following formulas in B2 and C2 and copy down to B4 and C4 respectivey
=SUM(FILTER(Data!\$B\$2:B;Data!\$A\$2:A=A2))
=COUNTA(FILTER(Data!\$B\$2:B;Data!\$A\$2:A=A2))
``````

## Example

I've made an example file for you: QUERY vs. FUNCTIONS

• Google sheets docs on query Apr 24 '17 at 2:13
• Thank you! I was looking for info on pivot tables (which I should learn more about), but the QUERY function is amazing. I never even knew it existed in Google Sheets. Jun 16 '20 at 1:33
• Extra points for including an example spreadsheet! Kudos. Apr 19 at 15:13

• Pivot Tables should probably be mentioned in the question comments section instead. It is definitely helpful and related, but not answer the question precisely - only because the question was specifically about a query and the `QUERY` function is the answer.