google-sheets - QUERY：将两列相加并在 Google 表格中按一排序

Question

我有以下数据集：

Country         Points    Bonus_Points
---------------------------------------
United States   1         50
Brazil          3         50
France          7         30
United States   2         25  

现在想查询该数据集并创建一个具有以下结果的列表，其中奖励积分和积分得到总结，并且列表按奖励积分排序。

Country         Points    Bonus_Points
---------------------------------------
United States   3         75
Brazil          3         50
France          7         30

和

=QUERY(A1:C,"select A, B, sum(C) group by A, B order by sum(C) desc", 1)

我能够对一列求和，但不知何故也无法获得 B/点的总和。有任何想法吗？

标签： google-sheetsgoogle-sheets-formula

Answer 1

看看这是否有帮助

=QUERY(A1:C,"select A, sum(B), sum(C) group by A order by sum(C) desc label sum(B) 'Points', sum(C) 'Bonus_Points'", 1)