关于SUMIF函数多条件的公式编写A\x05B \x05C1大\x051小\x05102大\x051大\x05202小\x051小\x05101大\x052小\x0552大\x052大\x0591大\x051大\x05552大\x052小\x05661小\x051小\x0512如果只是求A列值为"大",=SUMIF(A:A,"*大",C:C),
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/02 02:01:05
![关于SUMIF函数多条件的公式编写A\x05B \x05C1大\x051小\x05102大\x051大\x05202小\x051小\x05101大\x052小\x0552大\x052大\x0591大\x051大\x05552大\x052小\x05661小\x051小\x0512如果只是求A列值为](/uploads/image/z/7074367-7-7.jpg?t=%E5%85%B3%E4%BA%8ESUMIF%E5%87%BD%E6%95%B0%E5%A4%9A%E6%9D%A1%E4%BB%B6%E7%9A%84%E5%85%AC%E5%BC%8F%E7%BC%96%E5%86%99A%5Cx05B+%5Cx05C1%E5%A4%A7%5Cx051%E5%B0%8F%5Cx05102%E5%A4%A7%5Cx051%E5%A4%A7%5Cx05202%E5%B0%8F%5Cx051%E5%B0%8F%5Cx05101%E5%A4%A7%5Cx052%E5%B0%8F%5Cx0552%E5%A4%A7%5Cx052%E5%A4%A7%5Cx0591%E5%A4%A7%5Cx051%E5%A4%A7%5Cx05552%E5%A4%A7%5Cx052%E5%B0%8F%5Cx05661%E5%B0%8F%5Cx051%E5%B0%8F%5Cx0512%E5%A6%82%E6%9E%9C%E5%8F%AA%E6%98%AF%E6%B1%82A%E5%88%97%E5%80%BC%E4%B8%BA%22%E5%A4%A7%22%2C%3DSUMIF%28A%3AA%2C%22%2A%E5%A4%A7%22%2CC%3AC%29%2C)
关于SUMIF函数多条件的公式编写A\x05B \x05C1大\x051小\x05102大\x051大\x05202小\x051小\x05101大\x052小\x0552大\x052大\x0591大\x051大\x05552大\x052小\x05661小\x051小\x0512如果只是求A列值为"大",=SUMIF(A:A,"*大",C:C),
关于SUMIF函数多条件的公式编写
A\x05B \x05C
1大\x051小\x0510
2大\x051大\x0520
2小\x051小\x0510
1大\x052小\x055
2大\x052大\x059
1大\x051大\x0555
2大\x052小\x0566
1小\x051小\x0512
如果只是求A列值为"大",=SUMIF(A:A,"*大",C:C),这个我知道怎么写.
现在我想求 A列满足"大"同时B列满足"小"的情况,C:C列的和,公式应该怎么编写呢?
=sumproduct((a1:a100="*大")*(b1:b100="*小"),c1:c100)
这个公式不行,就是不能加"*",帮助里面也没说明.
能耽误你点时间帮忙看下么
大小前面的数字没有任何规律,只是说前面可能会有各种不确定前缀.
关于SUMIF函数多条件的公式编写A\x05B \x05C1大\x051小\x05102大\x051大\x05202小\x051小\x05101大\x052小\x0552大\x052大\x0591大\x051大\x05552大\x052小\x05661小\x051小\x0512如果只是求A列值为"大",=SUMIF(A:A,"*大",C:C),
=sumproduct((right(a1:a100)="大")*(right(b1:b100)="小"),c1:c100)