=SUMIF($CO$7:$CO$65,LEFT(A68,1) & "G",C7:C65)是什么
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 18:04:24
![=SUMIF($CO$7:$CO$65,LEFT(A68,1) &](/uploads/image/z/15004397-29-7.jpg?t=%3DSUMIF%28%24CO%247%3A%24CO%2465%2CLEFT%28A68%2C1%29+%26+%22G%22%2CC7%3AC65%29%E6%98%AF%E4%BB%80%E4%B9%88)
=SUMIF($CO$7:$CO$65,LEFT(A68,1) & "G",C7:C65)是什么
=SUMIF($CO$7:$CO$65,LEFT(A68,1) & "G",C7:C65)是什么
=SUMIF($CO$7:$CO$65,LEFT(A68,1) & "G",C7:C65)是什么
如果CO7到CO65范围内的值等于A68的左边第1位与G的合并字符,则对应的C7到C65中的行求和.