我有一个看起来像这样的电子表格:
NAME HOURS ESTIMATED FOR TASK
================================
Bob 7
Jim 6
Bob 1
Sue 10
我希望能够做的是将每个工人必须在所有任务上花费的总小时数相加:
NAME HOURS ESTIMATED FOR TASK
================================
Bob 7
Jim 6
Bob 1
Sue 10
TOTALS
Bob 8
Jim 6
Sue 10
我假设我会结合某种HLOOKUP
和SUMIF
来完成 TOTALS 部分,但我不确定。我将如何完成这种求和?
也许:
=query(A2:B5,"select A, sum(B) group by A ")