½Ð°Ý¦p¦ó¥Î¤½¦¡¼g¥X°ÊºA¦Xp³Ì«á´Xµ§¸ê®Æ
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
½Ð°Ý¦p¦ó¥Î¤½¦¡¼g¥X°ÊºA¦Xp³Ì«á´Xµ§¸ê®Æ
SHEET1 A B C D .................
1 23 24 25 30
2 12 15 23 25
3 22 25 32 25
4 22 32 22 68
¸ê®Æµ²ªG¦s©ñ¦bD1, D2, D3, D4
¸ê®Æ¨C¤Ñ©¹¥k¼W¥[ ¬Gn°ÊºA¦Xp³Ì«á5µ§
§Úª¾¥ÎCOUNT pºâ¥Ø«e¦³´Xµ§.µM«á´î5 ,¦ý·Q¨ì¥ÎCOLUMN¦ý·Q¤£³q¦p¦ó©¹«á¦Xp,½Ð¨D«e½ú«üÂI
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif)
|
¥»©«³Ì«á¥Ñ owen06 ©ó 2014-3-14 20:37 ½s¿è
¦^´_ 1# abba9817
§A¬Ond1¬°¥[Á`¡AµM«á±qe1¤@ª½©¹«á±·s¼W¼Æ¦r¶Ü¡H
¦pªG¬Oªº¸Ü¡A¦bd1¿é¤J=SUM(OFFSET(D1,0,IF(COUNT(E1:IV1)<6,1,COUNT(E1:IV1)-4),1,5))
µM«á©¹¤U©Ô¡AÀ³¸Ó´N¥i¥H¤F¡C
¨Ò¦p¡A¤½¦¡ SUM(OFFSET(C2,1,2,3,1)) ·|§â C2 ¤U¤@¦C¥k¤GÄ檺¤@Ó¤T¦C¤@Ä檺½d³ò¥[Á`¡C |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
¦^´_ 2# owen06
ÁÂÁ OWEN06¤jªºÀ°¦£
§Ú¥i¯à¨S¼g²M·¡.«Ü©êºp.¥H¦¹¨Ò¦A»¡©ú¤@¦¸
A B C D .................
1 23 24 25 30
¨C¤Ñ³£·|©¹¥k¼W¥[1µ§¸ê®Æ(¦p¤W¨Ò30,±µµÛ¬°45,25,60,100........,¦ý¥H³Ì·s5µ§¬°¥D¥[Á`
¦p
²Ä1¤Ñ D1=23+24+25+30+45
²Ä2¤Ñ D1= 24+25+30+45+25
²Ä3¤Ñ D1= 25+30+45+25+60
²Ä4¤Ñ D1= 30+40+25+60+100
¨C·í¦³·s¸ê®Æ¥[¤J®É D1·|§ì³Ì«á5µ§¸ê®Æ¦Xp...............¤£ª¾³o¼Ë¤F¸Ñ¶Ü
PS.Y¦³®É·í¤éµL¸ê®Æ·|¯dªÅ¥Õ
¦p 23 24 25 35 45 25 60 80 25 32
ÁÂÁÂÀ°¦£ |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
¦^´_ 4# Hsieh
Hsieh¤j.ª½±µ¼g¤W¥h´ú¸Õ¤Fµ²ªG§¹¥þ¥¿½T¥i¹ê¦æ.¤Ó·PÁ¤F
ÁöµMÁ٬ݤ£À´¬°¦ó¦p¦¹.¦ý·|§Q¥Î¶g¤»ªÅÀɬã¨s¤@¤Uì²z.Y¦³¤£À´¦A½Ð±Ð...ÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
¦^´_ 5# abba9817
¤]·PÁÂOWEN06¤jªºÀ°¦£.¦A¦¹¨¥Á |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
¦^´_ 4# Hsieh
¥Ø«eÁÙ¬O¨S§ËÀ´.¦ý¥i§_¥ý½Ð±Ð¤@¤U
Y¬O§ï¬°³Ì«ánµ§(¨Ò¦p7)ªº¸Ü.n×¥¿¨ºÓ°Ñ¼ÆÈ©O
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
¦^´_ 7# abba9817
§Ú¤w¸g§ËÀ´¤F...ÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
¦^´_ 4# Hsieh
½Ð±ÐHsieh¤j
D1=SUM(OFFSET(INDIRECT("RC"&LOOKUP(9.9E+307,$E$1:$IV$1,COLUMN($E:$IV))-4,0),,,,5)) ¤½¦¡¤¤
¥Ø«e§Ú¤F¸Ñì²z¬O¥ý¿ï¨ì³Ì«á¤@¦ì.µM«á©¹«e¥[N ¤é
¦ý
$E$1:$IV$1 ¦¹½d³òªº³]©w¬°¦ó¿ï¨ì$IV$1 ªºì¦]¤£¸Ñ
¥i§_§ï¬°³Ì¥½¦ì$DXF$1...ÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
¦^´_ 9# abba9817
½Ð±ÐHsieh¤j
D1=SUM(OFFSET(INDIRECT("RC"&LOOKUP(9.9E+307,$E$1:$IV$1,COLUMN($E:$IV))-4,0),,,,5)) ¤½¦¡¤¤
¥Ø«e§Ú¤F¸Ñì²z¬O¥ý¿ï¨ì³Ì«á¤@¦ì.µM«á©¹«e¥[N ¤é
¦ý
$E$1:$IV$1 ¦¹½d³òªº³]©w¬°¦ó¿ï¨ì$IV$1 ªºì¦]¤£¸Ñ
¥i§_§ï¬°³Ì¥½¦ì$XFD$1...ÁÂÁ |
|
|
|
|
|
|