excel是办公中最常用的软件之一,有时候需要在一列数字中筛选出综合等于特定的数字,该怎么办呢?下面给大家介绍下方法。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/314e251f95cad1c821dee8b46d3e6709c93d513f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
材料/工具
Excel
方法
1/5
以下面表格为例,在B11单元格内输入“=SUMPRODUCT(A2:A10,B2:B10)”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d6884f67a637b6c27d1ed21b243f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
2/5
在上方的数字选项卡中,选择规划求解。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7fd5266d01609240040b688c60735fae6cd343f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
3/5
以B11为目标单元格,目标值设为20。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a50f4bfbfbedab64c2175953e536afc379311e3f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
4/5
可变单元格为B2:B10,添加可变单元格的约束条件为“B2:B10为整数;B2:B10为二进制”,点击“确定”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cefc1e178a82b9019ac8d7a0618da9773912ef38?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
5/5
在B1列中显示为1的单元格就是总和为20的特定数字。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e824b899a9014c08855e3c36187b02087bf4f438?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述