¼Æ¦r+³æ¦ì ¦³¿ìªk¨ú¥§¡È¶Ü?
- ©«¤l
- 106
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 141
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-10-27
- ³Ì«áµn¿ý
- 2016-4-10
|
¼Æ¦r+³æ¦ì ¦³¿ìªk¨ú¥§¡È¶Ü?
§Ú©Ò¥H¥Îªº³nÅé·|±N¼ÆÈ¿é¥X¦¨EXCEL
¦ý¬O¥L¿é¥X«áªºµ²ªG³£·|¦³³æ¦ì
¦p
A B
1 1k£[ 5k£[
2 2k£[ 7k£[
3 3k£[ 9k£[
¦pªG§Ú¥´
A4=(A1+A2+A3)/3
³£·|¥X¿ù
½Ð°Ý¦b¤£¯}Ãa³æ¦ìªº±¡ªp¤U
¦³¸Ñ¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¥»©«³Ì«á¥Ñ ANGELA ©ó 2012-9-13 21:47 ½s¿è
¦pªG¥i¥H¥h±¼³æ¦ì,¨º¥Î´À¥N§Y¥i.
©Î
=AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2)) |
|
|
|
|
|
|
- ©«¤l
- 23
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- 20xx
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-8-11
- ³Ì«áµn¿ý
- 2012-8-28
|
¦^´_ 1# v60i
|
|
|
|
|
|
|
- ©«¤l
- 106
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 141
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-10-27
- ³Ì«áµn¿ý
- 2016-4-10
|
|
|
|
|
|
|
- ©«¤l
- 106
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 141
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-10-27
- ³Ì«áµn¿ý
- 2016-4-10
|
¦^´_ 2# ANGELA
¦^´_ 3# white945
½Ð°Ý¨â¦ì¤j¤j
¤½¦¡ªº -- ¬O¥Nªí¤°»ò·N«ä©O? |
|
|
|
|
|
|
- ©«¤l
- 161
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-9-16
- ³Ì«áµn¿ý
- 2017-2-19
|
¥»©«³Ì«á¥Ñ JBY ©ó 2012-9-16 21:24 ½s¿è
©Î
{=AVERAGE(--SUBSTITUTE(A1:A10,"k£[",))} |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¦^´_ 5# v60i
--±N¥Nªí¬Y¼ÆȪº¤å¦r¦r¦êÂà´«¦¨¼Æ¦r¸ê®Æ,¥¿³Wªº¥Îªk¬OVALUE(), ¨ä¥¦ÁÙ¦³*1©Î+0³£¥i¥H |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 68
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- «n§ë¿¤
- µù¥U®É¶¡
- 2010-9-28
- ³Ì«áµn¿ý
- 2019-10-4
|
¦^´_ 7# ANGELA
·Q½Ð±Ð¦U¦ì¤j¤j¡AY«öANGELAª©¥Dªº¤½¦¡°µ®É·|²£¥Í#VALUE!¡A¤@©wn¦pJBY¤j¤jªº¤½¦¡¿é¤J¦¨°}¦C¤½¦¡¦p¥k{=AVERAGE(--SUBSTITUTE(A1:A10,"k£[",))}¤~¯à±o¨ìµ²ªG¡A³o¬O¬°¤°»ò©O¡H§Æ±æ¦U¦ì«e½ú¸Ñ´b¡CÁÂÁ¡I |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
©êºp¡A¨Sª`©ú¬O°}¦C¤½¦¡¡C
¨ä¹ê³o¨âÓ¤½¦¡«ä¸ô¤£¦P¡Cµ²ªG¬O¤@¼Ëªº¡C
=AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2))¬O¨úA1¨ìA10¤£§t³æ¦ìªºÈ
=AVERAGE(--SUBSTITUTE(A1:A10,"k£[",)) ¬O´À´«³æ¦ìªº¦r¤¸¬°ªÅ¦r¦ê¡C |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 68
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- «n§ë¿¤
- µù¥U®É¶¡
- 2010-9-28
- ³Ì«áµn¿ý
- 2019-10-4
|
¦^´_ 9# ANGELA
ANGELAª©¥D½Ð±z¤£»¡©êºp¡A§Ú¨Ã¨S¦³¥ô¦ó§äâíªº·N«ä¡C¦pªG§Úµ¹±z¦³¦p¦¹ªº·Pı¬O¦X¸Ó§Úµ¹±z»¡©êºp¤~¹ï¡C¨ä¹ê¤µ¤Ñ¹ï³oijÃD§Ú·P¨ì¤£¸Ñªº¬O¤£ºÞ¬O²Ä1өάO²Ä2Ó¤½¦¡
1. =AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2))
2. =AVERAGE(--SUBSTITUTE(A1:A10,"k£[",))
±qÅÞ¿è¤W¨Ó§PÂ_À³¸Ó´N¥i¥H¹F¦¨ÃD¥Øªºn¨D¡A¦ý¦b¹ê»Ú°õ¦æ¤§«á«oµo¥Í»P©Ò·Qªºµ²ªG¤£¦P¡A¥i¯à¬O¦]¬°¦Û¤v¹ï°}¦C¤½¦¡ªº¨Ï¥Îºâ¬O¤ñ¸ûÆZ¯¥ÍªºÃö«Y¡A¦pªG¤µ¤Ñ¬O§Ú¹J¤W¦pÃDªºª¬ªp«ç»ò¼Ë¤]¤£·|·Q¨ì¡A¥un±N¤½¦¡¿é¤J¦¨°}¦C¤½¦¡§Y¥i¹F°}¡C¤]´N¬O»¡§Ú¸Ó¦b¬Æ»òª¬ªp¤U´Nn¨Ï¥Î°}¦C¤½¦¡¡A´«¥y¸Ü»¡¨Ï¥Î°}¦C¤½¦¡ªº¥¿½T®É¾÷¬O¬Æ»ò±¡ªp¡AY¬O¤è«K½Ð§iª¾¡C³Ì«á¯¬ºÖ±z¦N²»¦p·N¡AÁÂÁ¡C |
|
|
|
|
|
|