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

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

¦^´_ 9# home1913


    =SUMPRODUCT((B2:B7="Á`¤½¥q")*(INT(C2:C7/VLOOKUP(A2:A7,E2:F8,2,))*10+MOD(C2:C7,VLOOKUP(A2:A7,E2:F8,2,))*2))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

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

¦^´_ 13# home1913

OFFICE2003¥i¦æ

¥ý´ú¸Õ1~2¸ê®Æ¬Ý¬Ý
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 14# ML089

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

TOP

¦^´_ 15# home1913

½Ðµ¹§ÚGÄ檺­pºâ¤½¦¡¡A¨º¨Ç¼Æ¦r§Ú¬Ý¤£¥X¨Ó¦p¦ó­pºâªº
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 15# home1913


    »²§UÄæ­pºâ»P§Aªº®t²§
=INT(C2/VLOOKUP(A2,$E$2:$F$8,2,0))*10+MOD(C2,VLOOKUP(A2,$E$2:$F$8,2,0))*2
¾Ç®üµL²P_¤£®¢¤U°Ý

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

¦^´_ 19# home1913
  1. =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))
½Æ»s¥N½X
¦¹¦¡¿é¤J¤è¦¡¤£¥i¥H¥ÎENTER¿é¤J¡A»Ý¥Î¤TÁä(CTRL+SHIFT+ENTER)»ô«ö¤è¦¡¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD