ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ­pºâ¹F¦¨¨ä¤@±ø¥óªº¨ç¼Æ©Î¤è¦¡

[µo°Ý] ­pºâ¹F¦¨¨ä¤@±ø¥óªº¨ç¼Æ©Î¤è¦¡

»Ý¦bD1³BÅã¥Ü¬°2¶¡·s«È¤á¡A±ø¥ó¬°²Ä¤@¦¸¾PÃB¹F¦¨2500¥H¤W©Î²Ö¿n¾PÃB¹F¦¨5000¥H¤W¡A¨ä¤¤¤@¶µ¹F¦¨´Nºâ·s«È¤á¡A¤£ª¾¹D¦³¨S¦³¿ìªk§e²{¡H
ÁÂÁ¦^ÂЪº¤j®a
Â^¨ú.PNG
2020-8-6 16:46

=SUMPRODUCT(N((C4:C6>2500)+(D4:D6>5000)>0))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522



ÁÂÁ§A¡A¥i¥H½Ð°Ý=IF(O3="",IF(SUMIF(E:E,E3,J:J)>=2500,IF(D3="","",IF(ISNA(VLOOKUP(D3,Á`ªí!$E$7460:$F$99936,2,0)),"ÄòÁÊ","")),""),"")&IF(O3="",IF(SUMIF(E:E,E3,J:J)<2500,IF(D3="","",IF(ISNA(VLOOKUP(D3,Á`ªí!$E$7460:$F$99936,2,0)),"ª÷ÃB¥¼¹F","")),""),"")
³o¤½¦¡¦pªG­n¥[¶i¶W¹L¥b¦~¡A­n«ç»ò¥[©O¡H§Ú§ó§ï¦¨sumif¼W¥[¤é´Á¦ý¥X²{¿ù»~

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD