计算多条件重复值、求大神帮忙

lian848213

无聊的黑猫

=IF(C7<>"",IF(SUMIFS($E$7:E7,$C$7:C7,C7,$D$7:D7,D7)<VLOOKUP(D7,$A$2:$B$3,2,0)*(1+20%),"正常","重复"),"")下拉 是这意义?

theking_wsz

=IF(E7,IF(OR(SUMIF(C$7:C7,C7,E$7:E7)<=VLOOKUP(D7,$A$2:$B$3,2,),COUNTIF(C$7:C7,C7)=1),"正常","重复"),"")

在八月末里流浪

规定金额是在哪体现呢？   

在八月末里流浪

在八月末里流浪 发表于 2023-3-22 13:31
规定金额是在哪体现呢？

哦哦，看错了，上面还有

lian848213

theking_wsz 发表于 2023-3-22 13:20
=IF(E7,IF(OR(SUMIF(C$7:C7,C7,E$7:E7)

能设置日期条件吗

theking_wsz

lian848213 发表于 2023-3-22 14:10
能设置日期条件吗

=IF(E7,IF(OR(SUMIFS(E$7:E7,C$7:C7,C7,B$7:B7,B7)<=VLOOKUP(D7,$A$2:$B$3,2,),COUNTIFS(B$7:B7,B7,C$7:C7,C7)=1),"正常","重复"),"")   

龙晓慕青

={IFERROR(IF(OR(SUMIFS($E$7:$E$17,$B$7:$B$17,B7,$C$7:$C$17,C7,$D$7:$D$17,D7)<=VLOOKUP(D7,$A$2:$B$3,2,1),MIN(COUNTIF($B$7:D7,B7:D7))<=1),"正常","重复"),"")}