excel 2010 group and subtotal function

来源:互联网 发布:生物多样性锐减的数据 编辑:程序博客网 时间:2024/05/21 11:12

 选中所有行。

1.Data->Group

对所用行加group。

2.Data->Subtotal

click "ok", choose one column as "group by " column in "At each change in", choose "Use funtion" to statistics, choose one column as statistics column

we can add several group only when we uncheck "Replace current subtotals"