![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用COUNTA函数
计算非空单元格个数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用DSUM函数
快速条件求和
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DPRODUCT函数
计算利润乘积
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DCOUNT函数统计
符合条件的数据个数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DGET函数快速
按条件查找个值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
Dcounta函数统计
满足指定条件的个数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DSTDEV函数计算
条件样本估算标准偏差
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用DAVERAGE函数
求平均值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DSTDEVP函数
计算满足条件标准偏差
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DMAX函数筛选
满足条件的最大数值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DVARP函数计算满足
条件样本的总体方差
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DMIN函数筛选
满足条件的最小数值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)