<p></p><p>第一题:=DCOUNT(A2:I8,1,A10:A11)</p><p> =DMIN(A2:I8,H2,B10:B11)</p><p> =DMIN(A2:I8,G2,C10:C11)</p><p> =DSUM(A2:I8,H2,D10:D11)</p><p> =DSUM(A2:I8,I2,D10:E11)</p><p> =DCOUNT(A2:I8,A2,F10:F11)</p><p>第二题:=AND(LEFT(A4,1)="A",RIGHT(A4,1)="E")</p><p> =C4>B4</p><p> =C4>300</p><p> </p> |