来晚了,测试过啦select * from [Sheet1$] a where (select sum(金额) from [Sheet1$] where 序号<=a.序号 and 姓名=a.姓名 and abs(金额)=a.金额)>0and(select sum(金额) from [Sheet1$] where 姓名=a.姓名 and abs(金额)=a.金额)>0 and 金额>0