EXCEL中如何查找引用符合条件的数据后返回数值并求和

在SHEET2的B2:D2分别输入或复制粘贴下列公式

=COUNTIFS(A:A,G2,B:B,">="&TODAY()-DAY(TODAY())+1,B:B,"<="&EOMONTH(TODAY(),0))

=SUMIFS(D:D,B:B,">="&TODAY()-DAY(TODAY())+1,B:B,"<="&EOMONTH(TODAY(),0))

=SUMIFS(F:F,E:E,">="&TODAY()-DAY(TODAY())+1,E:E,"<="&EOMONTH(TODAY(),0))

选择B2:D2，下拉填充。

for x=2 to 21

  for y = x+1 to 21

    for z = y +1 to 21

      tmp = cells(x,2)+cells(y,2)+cells(z,2)

      if tmp = 350.45 then msgbox x,y,z

    next z

  next y

next x

---