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

[µo°Ý] ±ø¥ó¥[Á`­p­«¶q

[µo°Ý] ±ø¥ó¥[Á`­p­«¶q

·Q°Ý°Ý¦³¨S¦³¿ìªk¥i¥H¥Îexcel ¤½¦¡©ÎªÌVBA­pºâ?

¦pªG¦P¤@­ÓTruck no,Á`©MKGS ¤Ö©ó1000,´N·|±N1000­¼¨C¤@­Óbacth no¦Ê¤À¤ñ¥h

Â^¨ú.JPG (102.5 KB)

Â^¨ú.JPG

test (2).zip (7.33 KB)

¬Ý¤£À´­pºâ³W«h~~

TOP

¦^´_ 2# ­ã´£³¡ªL


    ­×¥¿:¦pªG¦P¤@­ÓTruck no PP0003,Á`©M­«¶q ¤Ö©ó1000,´N¤£­pºâ

Â^¨ú.JPG (62.44 KB)

Â^¨ú.JPG

test (3).zip (7.04 KB)

TOP

E2//
=SUMPRODUCT((SUMIF(F$8:F$15,F$8:F$15,D$8:D$15)>=1000)*(C$8:C$15=C2),D$8:D$15)

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2020-1-23 10:46 ½s¿è
·Q°Ý°Ý¦³¨S¦³¿ìªk¥i¥H¥Îexcel ¤½¦¡©ÎªÌVBA­pºâ?

¦pªG¦P¤@­ÓTruck no,Á`©MKGS ¤Ö©ó1000,´N·|±N1000­¼¨C¤@ ...
john2006168 µoªí©ó 2020-1-14 13:02



    ½Ð°Ý¬°¬Æ»ò CC0002 µ²ªG¬O 571.43 ¦Ó¬O 835.71 ©O ? ¬Ý¤FªþÀÉ·í¤¤¨S¦³¶W¥X 1000§r ?


¦pªG²z¸Ñ¤è¦V¥¿½T,¤½¦¡¬O³o¼Ë
¸Ñ¤@¼Óªº¤èªk
E3 °}¦C¤½¦¡

  {=MAX(($C$8:$C$15=C2)*($D$8:$D$15>=1000)*$D$8:$D$15)+SUM((SUMIF(F$8:F$15,F$8:F$15,D$8)<1000)*(C$8:C$15=C2)*D$8:D$15/560)*1000}

¸Ñ¤T¼Óªº¤èªk
E2 ¤½¦¡°}¦C¤U©ì
{=MAX(($C$8:$C$15=C2)*($D$8:$D$15>=1000)*$D$8:$D$15)}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD