=SUMPRODUCT(N(LEFT(A1:A6,3)="027")) =SUMPRODUCT((LEFT(A1:A6,3)="027")*B1:B6)
c1=countif(a:a,"027*")(得到含"027"的行数)求和不好整
