1、将自己的数据输入至excel表格中。我们此例以下图表为演示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/faf2b2119313b07e094bf6741cd7912396dd8cdc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在单元格数据的末尾先求和,B15单元格插入subtotal函数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9a504fc2d56285350116745d80ef76c6a6ef63dc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、将subtotal函数的第一个条件选择数字9 ,即sum 进行求和。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8d5494eef01f3a29de3e73b28925bc315d607cdc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、第二个条件求和区域选择B3到B14,既选择了求和这一整列的数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9e3df8dcd100baa1ecdde1c75710b912c9fc2edc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、按下“Enter”键后,就可以计算出B3到B14所有数据的和了,把公式往右拉填充,求出其他列的和。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3812b31bb051f819eed4a536cab44aed2f73e7dd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、这时对该表格进行筛选时,例如对月份进行筛选,就会看到合计一行的数都是只对筛选的数据进行求和而已,隐藏的数据没一起求和。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a08b87d6277f9e2f73c4bb740f30e924b999f3dd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)