sumif这个怎么写

a1999zqw · 发表于 2024-3-3 12:06

表2的b列要填写表1中日期符合表2的月份并且表1的用途是ay的数量之和

工作簿1.rar (9.4 KB, 下载次数: 11)

良良 · 发表于 2024-3-3 12:20

=SUMIFS(Sheet1!B:B,Sheet1!A:A,">"&A2/1%,Sheet1!A:A,"<"&A2/1%+100,Sheet1!C:C,"ay")

miaojohn45 · 发表于 2024-3-3 12:22

=SUM(IFERROR(Sheet1!B$2:B$100*(LEFT(Sheet1!A$2:A$100,6)-A2=0)*(Sheet1!C$2:C$100="ay"),0))

复制代码

jisijie630 · 发表于 2024-3-3 12:36

=SUMPRODUCT((LEFT(Sheet1!A$2:A$12,6)/1=A2)*(Sheet1!C$2:C$12="ay")*Sheet1!B$2:B$12)

quqiyuan · 发表于 2024-3-3 12:38

=SUMIFS(Sheet1!B:B,Sheet1!C:C,"ay",Sheet1!A:A,">="&Sheet2!A2&"01",Sheet1!A:A,"<="&Sheet2!A2&"31")

mykitami · 发表于 2024-3-3 16:34

本帖最后由 mykitami 于 2024-3-3 16:40 编辑

=SUMIFS(Sheet1!$B$2:$B$100,Sheet1!$A$2:$A$100,A2&"*",Sheet1!$C$2:$C$100,"ay")

需要将Sheet1表的A列格式设置为文本

		自动登录	找回密码
密码			免费注册

[求助] sumif这个怎么写