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

[µo°Ý] ­pºâÃþ§O±ø¥ó¥[Á`

[µo°Ý] ­pºâÃþ§O±ø¥ó¥[Á`

¦U¦ì¤j­ô¡A¤p§Ì·Q±qªþ¥ó ªí®æ¤¤ «ö·Ó¦³"Á`¤½¥q"¦r¼Ë­pºâ¥X©Ò»Ýª÷ÃB¡AÀµ½Ð¤j¤j«üÂI¡C Book2.rar (1.8 KB)

Book2.rar (1.8 KB)

F¦C¬°½c¤J¼Æ¡A¬G³f¸¹­n¹ïÀ³¨ì¬Û¦Pªº½c¤J¼Æ°µ¬Û°£¤~¦³¿ìªk­¼¤Wª÷ÃB¡A¥Ø«e¥d¦b³oÃä
·PÁ±z~

TOP

¦^´_ 7# Bodhidharma

¬Oªº~¨S¿ù!

TOP

¦^´_ 6# ML089

½Ð°Ý SUMPRODUCT¦³¿ìªk¼g¦b¤@°_¶Ü?

TOP

¦^´_ 10# Bodhidharma
½Ð°Ý³o¦bOFFICE2003¬O§_¥i¦æ¡A
¦]¬°¤½¦¡±a¤J¥X¨Óªº­È©M°Oºâªº¤£¦P

TOP

¦^´_ 11# ML089
½Ð°Ý³o¦bOFFICE2003¬O§_¥i¦æ¡A
¦]¬°¤½¦¡±a¤J¥X¨Óªº­È©M°Oºâªº¤£¦P

TOP

¦^´_ 14# ML089

¥H¤U¬°¨Ï¥Î­pºâ¤Î¤½¦¡±a¥Xªºµ²ªG¡A­pºâ¥X­È¬°210¤½¦¡ºâ¥X¬°80
   

TOP

¦^´_ 16# ML089
  ¦pHsiehªº¤½¦¡¡A¥u¬O§Ú¥Î¤âºâªº¡A Hsieh¨º¼Ë¤~¹ï

TOP

¥»©«³Ì«á¥Ñ home1913 ©ó 2013-6-6 17:46 ½s¿è

¥Ø«e¥Î³o3­Ó¤½¦¡¥X¨Óªº­È³£¬O80
={SUMPRODUCT((B2:B7="Á`¤½¥q")*(INT(C2:C7/VLOOKUP(A2:A7,E2:F8,2,))*10+MOD(C2:C7,VLOOKUP(A2:A7,E2:F8,2,))*2))}
={SUM(IF(B2:B7="Á`¤½¥q",INT(C2:C7/VLOOKUP(A2:A7,E2:F8,2,))*10+MOD(C2:C7,VLOOKUP(A2:A7,E2:F8,2,))*2))}
={SUMPRODUCT(ISNUMBER(FIND("Á`¤½¥q",$B$2:$B$7))*(INT($C$2:$C$7/VLOOKUP($A$2:$A$7,$E$2:$F$8,2,0))*10+MOD($C$2:$C$7,VLOOKUP($A$2:$A$7,$E$2:$F$8,2,0))*2))}

TOP

·PÁÂ2¦ìªºÀ°¦£~
=SUM((B2:B7="Á`¤½¥q")*(INT(C2:C7/VLOOKUP(T(IF({1},A2:A7)),E2:F8,2,))*10+MOD(C2:C7,VLOOKUP(T(IF({1},A2:A7)),E2:F8,2,))*2))
³o­Ó¤½¦¡ºâ¥Xªº¬O¥¿½T¤F~
¦ý¬O¤£À´¦p¦ó­pºâ¥Xªº~

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD