ML089

¦^´_ 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))

home1913

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

home1913

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

ML089

¦^´_ 13# home1913

OFFICE2003¥i¦æ

¥ý´ú¸Õ1~2¸ê®Æ¬Ý¬Ý

home1913

¦^´_ 14# ML089

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

¤U¸ü (45.67 KB)

2013-6-6 13:37

ML089

¦^´_ 15# home1913

½Ðµ¹§ÚGÄ檺­pºâ¤½¦¡¡A¨º¨Ç¼Æ¦r§Ú¬Ý¤£¥X¨Ó¦p¦ó­pºâªº

Hsieh

¦^´_ 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

¤U¸ü (14.94 KB)

2013-6-6 15:34

home1913

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

home1913

¥Ø«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))}

ML089

¦^´_ 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¤½¦¡