以下是引用willin2000在2008-8-4 14:11:00的发言:呵呵,我觉得那也是个不错的思路,所以再稍微优化一下. 其实流水帐用直接计数判断也是比较方便的: =COUNT(0/((COUNTIF(OFFSET(A2,ROW(1:26),,26),A3:A28)=1)*MATCH(B3:B28&D3:D28,{"A","B","C"}&"香水",))) 用方兄的0^: =COUNT(0^(COUNTIF(OFFSET(A2,ROW(1:26),,26),A3:A28)=1)*MATCH(B3:B28&D3:D28,{"A","B","C"}&"香水",)) 还可以更简单些: =COUNT(MATCH(B3:B28&D3:D28,{"A","B","C"}&"香水",)/(COUNTIF(OFFSET(A2,ROW(1:26),,26),A3:A28)=1)) 同样道理,我前面那个适合乱序排列的公式也可以这么做: =COUNT(MATCH(B3:B28&D3:D28,{"A","B","C"}&"香水",)/(MMULT((A3:A28=TRANSPOSE(A3:A28))*(C3:C28<=TRANSPOSE(C3:C28)),ROW(A3:A28)^0)=1)) |