这个函数公式是什么意思的?=IF(SUMPRODUCT((Sheet1!B$2:B$312=B2)*(Sheet1!C$2:C$312=C2)*(Sheet1!L$2:L$312=L2)*(Sheet1!M$2:M$312=M2)*(Sheet1!P$2:P$312=P2))=1,"","不同")我是函数公式门外汉,
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 02:21:13
![这个函数公式是什么意思的?=IF(SUMPRODUCT((Sheet1!B$2:B$312=B2)*(Sheet1!C$2:C$312=C2)*(Sheet1!L$2:L$312=L2)*(Sheet1!M$2:M$312=M2)*(Sheet1!P$2:P$312=P2))=1,](/uploads/image/z/12682509-69-9.jpg?t=%E8%BF%99%E4%B8%AA%E5%87%BD%E6%95%B0%E5%85%AC%E5%BC%8F%E6%98%AF%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D%E7%9A%84%3F%3DIF%28SUMPRODUCT%28%28Sheet1%21B%242%3AB%24312%3DB2%29%2A%28Sheet1%21C%242%3AC%24312%3DC2%29%2A%28Sheet1%21L%242%3AL%24312%3DL2%29%2A%28Sheet1%21M%242%3AM%24312%3DM2%29%2A%28Sheet1%21P%242%3AP%24312%3DP2%29%29%3D1%2C%22%22%2C%22%E4%B8%8D%E5%90%8C%22%29%E6%88%91%E6%98%AF%E5%87%BD%E6%95%B0%E5%85%AC%E5%BC%8F%E9%97%A8%E5%A4%96%E6%B1%89%2C)
这个函数公式是什么意思的?=IF(SUMPRODUCT((Sheet1!B$2:B$312=B2)*(Sheet1!C$2:C$312=C2)*(Sheet1!L$2:L$312=L2)*(Sheet1!M$2:M$312=M2)*(Sheet1!P$2:P$312=P2))=1,"","不同")我是函数公式门外汉,
这个函数公式是什么意思的?
=IF(SUMPRODUCT((Sheet1!B$2:B$312=B2)*(Sheet1!C$2:C$312=C2)*(Sheet1!L$2:L$312=L2)*(Sheet1!M$2:M$312=M2)*(Sheet1!P$2:P$312=P2))=1,"","不同")我是函数公式门外汉,
这个函数公式是什么意思的?=IF(SUMPRODUCT((Sheet1!B$2:B$312=B2)*(Sheet1!C$2:C$312=C2)*(Sheet1!L$2:L$312=L2)*(Sheet1!M$2:M$312=M2)*(Sheet1!P$2:P$312=P2))=1,"","不同")我是函数公式门外汉,
=SUMPRODUCT((条件1)*(条件2)*……(条件n))——多条件计数
每个“条件”都是一个判断语句,比如(Sheet1!B$2:B$312=B2)这样的判断,得到的是逻辑值TRUE或FALSE;逻辑值相乘即可转换为数值1或0.
这个公式是用来判断sheet1中的B、C、L、M、P列的数据是否完全相同,即B2到B132是否相同,C2到C132是否相同……;如果相同返回空白值,如果某一列(或几列)中有不相同的值,则返回“不同”,以作提醒.