Excel word ppt officeʹÓü¼ÇÉ´óÈ«(DOC¸ñʽ)-µÚ32ÕÂ

°´¼üÅÌÉÏ·½Ïò¼ü ¡û »ò ¡ú ¿É¿ìËÙÉÏÏ·­Ò³£¬°´¼üÅÌÉ쵀 Enter ¼ü¿É»Øµ½±¾ÊéĿ¼ҳ£¬°´¼üÅÌÉÏ·½Ïò¼ü ¡ü ¿É»Øµ½±¾Ò³¶¥²¿£¡
¡ª¡ª¡ª¡ªÎ´ÔĶÁÍꣿ¼ÓÈëÊéÇ©ÒѱãÏ´μÌÐøÔĶÁ£¡



Summary¡£Range£¨Cells£¨TargetRow£»¡¡13£©£»¡¡Cells£¨TargetRow£»¡¡13£©£©¡£Select¡¡¡¡¡¡

Selection¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=SUMIF£¨'IN1012'£¡C£§¡­2£§£ºC£§¡­1£§£»Period£¡R2C2&¡¨¡¨37¡¨¡¨&RC£§¡­12£§£»'IN1012'£¡C£§¡­1£§£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡14£©£»¡¡Cells£¨TargetRow£»¡¡14£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=RC£§¡­8£§¡­RC£§¡­7£§£«RC£§¡­6£§¡­RC£§¡­5£§¡­RC£§¡­4£§¡­RC£§¡­3£§¡­RC£§¡­2£§¡­RC£§¡­1£§¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡15£©£»¡¡Cells£¨TargetRow£»¡¡15£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=IF£¨RC£§¡­10£§=¡¨¡¨6¡¨¡¨£»0£»IF£¨SUM£¨RC£§¡­8£§£ºRC£§¡­2£§£©=0£»RC£§¡­9£§£»IF£¨RC£§¡­10£§=¡¨¡¨9¡¨¡¨£»0£»VLOOKUP£¨Pe¡¡

riod£¡R6C2&RC£§¡­14£§&¡¨¡¨090¡¨¡¨£»WP1019£¡C£§¡­9£§£ºC£§¡­8£§£»2£»FALSE£©£©£©£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡16£©£»¡¡Cells£¨TargetRow£»¡¡16£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡¡¨=RC£§¡­1£§¡­RC£§¡­2£§¡¨¡¡¡¡¡¡

Range£¨¡¨P2¡¨£©¡£Select¡¡¡¡¡¡

Calculate¡¡¡¡¡¡

Columns£¨¡¨P£ºP¡¨£©¡£Select¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXX¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡131¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



'OPRow¡¡=¡¡2¡¡¡¡¡¡

'While¡¡Not¡¡IsEmpty£¨WP19¡£Cells£¨OPRow£»¡¡1£©£©¡¡¡¡¡¡

'¡¡If¡¡WP19¡£Cells£¨OPRow£»¡¡2£©¡¡=¡¡2¡¡And¡¡WP19¡£Cells£¨OPRow£»¡¡3£©¡¡=¡¡WP19¡£Cells£¨SourceRow£»¡¡3£©¡¡And¡¡¡¡

WP19¡£Cells£¨OPRow£»¡¡8£©¡¡=¡¡¡¨081¡¨¡¡Then¡¡¡¡¡¡

'¡¡Summary¡£Range£¨Cells£¨TargetRow£»¡¡6£©£»¡¡Cells£¨TargetRow£»¡¡6£©£©¡£Select¡¡¡¡¡¡

'¡¡Summary¡£Cells£¨TargetRow£»¡¡6£©¡¡=¡¡WP19¡£Cells£¨OPRow£»¡¡9£©¡¡¡¡¡¡

'¡¡End¡¡If¡¡¡¡¡¡

'¡¡OPRow¡¡=¡¡OPRow¡¡£«¡¡1¡¡¡¡¡¡

'Wend¡¡¡¡¡¡

TargetRow¡¡=¡¡TargetRow¡¡£«¡¡1¡¡¡¡¡¡

End¡¡If¡¡¡¡¡¡

SourceRow¡¡=¡¡SourceRow¡¡£«¡¡1¡¡¡¡¡¡

Wend¡¡¡¡¡¡

End¡¡Sub¡¡¡¡¡¡

========¡¡¡¡¡¡

²»¹ØEXCEL¡¡ÈçºÎ¹Ø±ÕÒÑ´ò¿ªµÄ¼ÓÔغꡡ¡¡¡¡

Sub¡¡ttt£¨£©¡¡Dim¡¡inadd¡¡As¡¡AddIn¡¡For¡¡Each¡¡inadd¡¡In¡¡Application¡£AddIns¡¡inadd¡£Installed¡¡=¡¡¡¡

False¡¡Next¡¡End¡¡Sub¡¡¡¡¡¡

£§ÍƼö£§Excel¡¡Êý×éµÄʹÓá¡ÎÒÒ»Ö±¶ÔÊý×éµÄÓ÷¨²»ÊǺÜÇå³þ£»¡¡½ñÌì¼ûµ½Ò»Æª¹ØÓÚÊý×é»ù´¡µÄÎÄ¡¡

Õ£»¡¡¾õµÃÓбØÒªÍƼö¸øÊý×éÐÂÊÖѧϰ²Î¿¼¡£¡¡¡¡¡¡

Êý×é¾ÍÊǵ¥ÔªµÄ¼¯ºÏ»òÊÇÒ»×é´¦ÀíµÄÖµ¼¯ºÏ¡£¿ÉÒÔдһ¸öÊý×鹫ʽ£¬¼´ÊäÈëÒ»¸öµ¥¸öµÄ¹«Ê½£¬¡¡

ËüÖ´Ðжà¸öÊäÈëµÄ²Ù×÷²¢²úÉú¶à¸ö½á¹û¡ª¡ªÃ¿¸ö½á¹ûÏÔʾÔÚÒ»¸öµ¥ÔªÖС£Êý×鹫ʽ¿ÉÒÔ¿´³ÉÊÇ¡¡

ÓжàÖØÊýÖµµÄ¹«Ê½¡£Óëµ¥Öµ¹«Ê½µÄ²»Í¬Ö®´¦ÔÚÓÚËü¿ÉÒÔ²úÉúÒ»¸öÒÔÉϵĽá¹û¡£Ò»¸öÊý×鹫ʽ¿É¡¡

ÒÔÕ¼ÓÃÒ»¸ö»ò¶à¸öµ¥Ôª¡£Êý×éµÄÔªËؿɶà´ï6500¸ö¡£¡¡7¡£12¡£1¡¡Á˽âÊý×é¡¡Ê×ÏÈÎÒÃÇͨ¹ý¼¸¸öÀý¡¡

×ÓÀ´ËµÃ÷Êý×éÊÇÈçºÎ¹¤×÷µÄ¡£ÎÒÃÇ¿ÉÒÔ´Óͼ7¡­35Öп´¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXXI¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡132¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



µ½£¬ÔÚ¨DB¡¬ÁÐÖеÄÊý¾ÝΪÏúÊÛÁ¿£¬ÔÚ¨DC¡¬ÁÐÖеÄÊý¾ÝÊÇÏúÊÛµ¥¼Û£¬ÒªÇó¼ÆËã³öÿÖÖ²úÆ·µÄÏúÊ۶

ºÍ×ܵÄÏúÊÛ½ð¶î£¬Ò»°ãµÄ×ö·¨ÊǼÆËã³öÿÖÖ²úÆ·µÄÏúÊ۶ȻºóÔÙ¼ÆËã³ö×ܵÄÏúÊ۶µ«ÊÇÈç¡¡

¹ûÎÒÃǸÄÓÃÊý×飬¾Í¿ÉÒÔÖ»¼üÈëÒ»¸ö¹«Ê½À´Íê³ÉÕâЩÔËËã¡£¡¡ÊäÈëÊý×鹫ʽµÄ²½ÖèΪ£º¡¡Ñ¡¶¨Òª¡¡

´æÈ빫ʽµÄµ¥Ôª¸ñ£¬ÔÚ±¾ÀýÖÐÎÒÃÇÑ¡Ôñ¨DD4¡¬µ¥Ôª¸ñ¡£ÊäÈ빫ʽ¡¡¡¡¡¡

=SUM¡¡£¨B2£ºB4*C2£ºC4£©£¬µ«²»Òª°´Ï£§Enter£§¼ü£¨ÊäÈ빫ʽµÄ·½·¨ºÍÊäÈëÆÕͨµÄ¹«Ê½Ò»Ñù£©¡£°´Ï¡¡

£§Shift£§£«£§Ctrl£§£«£§Enter£§¼ü¡£ÎÒÃǾͻῴµ½ÔÚ¹«Ê½ÍâÃæ¼ÓÉÏÁËÒ»¶Ô´óÀ¨ºÅ¨D¡¡£û£ý¡¬£¬Èçͼ¡¡7¡­36Ëù¡¡

ʾ¡£¡¡ÔÚµ¥Ôª¸ñ¨DD¡¬¡¡ÖеĹ«Ê½¨D=SUM£¨B2£ºB4*C2£ºC4£©¡¬£»¡¡±íʾ¨DB2£º¡¡B4¡¬·¶Î§ÄÚµÄÿһ¸öµ¥Ôª¸ñºÍ¨DC2£º¡¡

C4¡¬¡¡ÄÚÏà¶ÔÓ¦µÄµ¥Ôª¸ñÏà³Ë£¬Ò²¾ÍÊÇ°Ñÿ¸öµØÇøµÄÏúÊÛÁ¿ºÍÏúÊÛµ¥¼ÛÏà³Ë£¬Ïà³ËµÄ½á¹û¹²ÓÐ3¡¡

¸öÊý×Ö£¬Ã¿¸öÊý×Ö´ú±íÒ»¸öµØÇøµÄÏúÊ۶¶ø¨DSUM¡¬º¯Êý½«ÕâЩÏúÊÛ¶îÏà¼Ó£¬¾ÍµÃµ½ÁË×ܵÄÏú¡¡

Ê۶¡¡ÏÂÃæÎÒÃÇÔÙÒÔʹÓÃÊý×é¼ÆËã3ÖÖ²úÆ·µÄÏúÊÛ¶îΪÀý£¬À´ËµÃ÷ÈçºÎ²úÉú¶à¸ö¼ÆËã½á¹û¡£Æä¡¡

²Ù×÷¹ý³ÌÈçÏ£º¡¡¡¡£¨1£©¡¡Ñ¡Ôñ¨DD2£ºD4¡¬µ¥Ôª¸ñÇøÓò£¬¸ÃÇøÓòÖеÄÿ¸öµ¥Ôª¸ñ±£´æµÄÏúÊÛ½ð¶î¡£Èç¡¡

ͼ7¡­37Ëùʾ¡£¡¡¡¡£¨2£©¡¡ÔÚ¨DD2¡¬¡¡µ¥Ôª¸ñÖÐÊäÈ빫ʽ¨D=B2£ºB4*C2£ºC4¡¬¡¡¡¡¡¡¡¡¡¡£¨²»°´£§Enter£§¼ü£©°´Ï¡¡

£§Shift£§£«£§Ctrl£§£«£§Enter£§¡¬¼ü£¬ÎÒÃǾͿÉÒÔ´Óͼ7¡­38Öп´µ½Ö´ÐкóµÄ½á¹û¡£Í¬Ê±ÎÒÃÇ¿ÉÒÔ¿´µ½¡¡

¨DD2¡¬µ½¨DD4¡¬¡¡µÄ¸ñÖж¼»á³öÏÖÓôóÀ¨»¡¨D¡¡£û¡¡£ý¡¬¿òסµÄº¯Êýʽ£¬Õâ±íʾ¨DD2¡¬¡¡µ½¨DD4¡¬±»µ±×÷Ò»¸öµ¥Ôª¡¡

¸ñÀ´´¦Àí£¬ËùÒÔ²»ÄܶԨDD2¡¬µ½¨DD4¡¬¡¡ÖеÄÈÎÒ»¸ñ×÷Èκ奶À´¦Àí£¬±ØÐëÕë¶ÔÕû¸öÊý×éÀ´´¦Àí¡£¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXXII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡133¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



7¡£12¡£2¡¡Ê¹ÓÃÊý×é³£Êý¡¡ÎÒÃÇÒ²¿ÉÒÔÔÚÊý×éÖÐʹÓó£ÊýÖµ¡£ÕâЩֵ¿ÉÒÔ·ÅÔÚÊý×鹫ʽÖÐʹÓÃÇøÓò¡¡

ÒýÓõĵط½¡£ÒªÔÚÊý¾Ý¹«Ê½ÖÐʹÓÃÊý×é³£Êý£¬Ö±½Ó½«¸ÃÖµÊäÈëµ½¹«Ê½Öв¢½«ËüÃÇ·ÅÔÚÀ¨ºÅÀï¡£¡¡

ÀýÈ磬ÔÚͼ7¡­39ÖУ¬¾ÍʹÓÃÁËÊý×é³£Êý½øÐмÆËã¡£¡¡³£ÊýÊý×é¿ÉÒÔÊÇһάµÄÒ²¿ÉÒÔÊǶþάµÄ¡£¡¡

һάÊý×é¿ÉÒÔÊÇ´¹Ö±µÄÒ²¿ÉÒÔÊÇˮƽµÄ¡£ÔÚһάˮƽÊý×éÖеÄÔªËØÓöººÅ·Ö¿ª¡£ÏÂÃæÊÇÒ»¸öÒ»¡¡

άÊý×éµÄÀý×Ó¡£ÀýÈçÊý×飺£û10£»20£»30£»40£»50£ý¡£ÔÚһά´¹Ö±Êý×éÖеÄÔªËØÓ÷ֺŷֿª¡£ÔÚÏÂÃæ¡¡

µÄÀý×ÓÊÇÒ»¸ö6¡Á1µÄÊý×飬£û100£»200£»300£»400£»500£»600£ý¡£¡¡¡¡¡¡

¶ÔÓÚ¶þάÊý×飬ÓöººÅ½«Ò»ÐÐÄÚµÄÔªËØ·Ö¿ª£¬Ó÷ֺŽ«¸÷Ðзֿª¡£ÏÂÒ»¸öÀý×ÓÊǨD4¡¡¡Á4¡¬¡¡µÄÊý¡¡

×飨ÓÉ4ÐÐ4ÁÐ×é³É£©£º£û100£»200£»300£»400£»110£»¡¡¡¨¡¡¡¨¡¡¡¡£»130£»230£»330£»440£ý¡£¡¡×¢Ò⣺²»¿ÉÒÔÔÚ¡¡

Êý×鹫ʽÖÐʹÓÃÁгö³£ÊýµÄ·½·¨Áгöµ¥ÔªÒýÓá¢Ãû³Æ»ò¹«Ê½¡£ÀýÈ磺¡¡£û2*3£»3*3£»4*3£ýÒòΪÁгö¡¡

Á˶à¸ö¹«Ê½£¬ÊDz»¿ÉÓõġ££ûA1£»B1£»C1£ýÒòΪÁгö¶à¸öÒýÓã¬Ò²ÊDz»¿ÉÓõġ£²»¹ý¿ÉÒÔʹÓÃÒ»¸ö¡¡

ÇøÓò£¬ÀýÈç£ûA1£ºC1£ý¡£¡¡¶ÔÓÚÊý×é³£Á¿µÄÄÚÈÝ£¬¿ÉÓÉÏÂÁйæÔò¹¹³É£º¡¡Êý×é³£Á¿¿ÉÒÔÊÇÊý×Ö¡¢ÎÄ¡¡

×Ö¡¢Âß¼­Öµ»ò´íÎóÖµ¡£¡¡Êý×é³£Á¿ÖеÄÊý×Ö£¬Ò²¿ÉÒÔʹÓÃÕûÊý¡¢Ð¡Êý»ò¿Æѧ¼ÇÊý¸ñʽ¡£¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXXIII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡134¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



ÎÄ×Ö±ØÐëÒÔË«ÒýºÅÀ¨×¡¡£¡¡Í¬Ò»¸öÊý×é³£Á¿ÖпÉÒÔº¬Óв»Í¬ÀàÐ͵ÄÖµ¡£¡¡Êý×é³£Á¿ÖеÄÖµ±ØÐëÊÇ¡¡

³£Á¿£¬²»¿ÉÒÔÊǹ«Ê½¡£¡¡Êý×é³£Á¿²»Äܺ¬Óлõ±Ò·ûºÅ¡¢À¨ºÅ»ò°Ù·Ö±È·ûºÅ¡£¡¡ËùÊäÈëµÄÊý×é³£Á¿¡¡

²»µÃº¬Óв»Í¬³¤¶ÈµÄÐлòÁС£¡¡7¡£12¡£3¡¡Êý×éµÄ±à¼­¡¡Êý×é°üº¬Êý¸öµ¥Ôª¸ñ£¬ÕâЩµ¥Ôª¸ñÐγÉÒ»¡¡

¸öÕûÌ壬ËùÒÔ£¬Êý×éÀïµÄijһµ¥Ôª¸ñ²»Äܵ¥¶À±à¼­¡£Ôڱ༭Êý×éÇ°£¬±ØÐëÏÈÑ¡È¡Õû¸öÊý×é¡£¡¡Ñ¡¡¡

È¡Êý×éµÄ²½ÖèΪ£º¡¡¡¡£¨1£©¡¡Ñ¡È¡Êý×éÖеÄÈÎÒ»µ¥Ôª¸ñ¡£¡¡¡¡£¨2£©¡¡ÔÚ¨D±à¼­¡¬²Ëµ¥ÖÐÑ¡Ôñ¨D¶¨Î»¡¬ÃüÁî»òÕß¡¡

°´Ï£§F5£§¼ü£¬³öÏÖÒ»¸ö¨D¶¨Î»¡¬¶Ô»°¿ò¡£°´Ï¨D¶¨Î»Ìõ¼þ¡¬°´Å¥£¬³öÏÖÒ»¸ö¶¨Î»Ìõ¼þ¶Ô»°¿ò£¬Èçͼ¡¡

7¡­40Ëùʾ¡£¡¡Ñ¡Ôñ¨Dµ±Ç°Êý×顬ѡÏ×îºó°´Ï¨DÈ·¶¨¡¬°´Å¥£¬¾Í¿ÉÒÔ¿´µ½Êý×鱻ѡ¶¨ÁË¡£¡¡±à¼­Êý¡¡

×éµÄ²½ÖèΪ£º¡¡Ñ¡¶¨Òª±à¼­µÄÊý×飬ÒƵ½Êý¾Ý±à¼­À¸ÉÏ°´£§F2£§¼ü»òµ¥»÷×ó¼ü£¬Ê¹´ú±íÊý×éµÄÀ¨ºÅ¡¡

Ïûʧ£¬Ö®ºó¾Í¿ÉÒԱ༭¹«Ê½ÁË¡£±à¼­Íê³Éºó£¬°´Ï£§Shift£§¡¡£«£§Ctrl£§¡¡£«¡¡£§Enter£§¼ü¡£¡¡ÈôҪɾ³ý¡¡

Êý×飬Æä²½ÖèΪ£ºÑ¡¶¨ÒªÉ¾³ýµÄÊý×飬°´£§Ctrl£§£«£§Delete£§»òÑ¡Ôñ±à¼­²Ëµ¥ÖеĨDÇå³ý¡¬ÃüÁî¡£¡¡¡¡

7¡£12¡£4¡¡Êý×éµÄÀ©³ä¡¡ÔÚ¹«Ê½»òº¯ÊýÖÐʹÓÃÊý×é³£Á¿Ê±£¬ÆäËüÔËËã¶ÔÏó»ò²ÎÊýÓ¦¸ÃºÍµÚÒ»¸öÊý×é¡¡

¾ßÓÐÏàͬµÄάÊý¡£±ØҪʱ£¬Microsoft¡¡Excel¡¡»á½«ÔËËã¶ÔÏóÀ©Õ¹£¬ÒÔ·ûºÏ²Ù×÷ÐèÒªµÄάÊý¡£Ã¿¡¡

Ò»¸öÔËËã¶ÔÏóµÄÐÐÊý±ØÐëºÍº¬ÓÐ×î¶àÐеÄÔËËã¶ÔÏóµÄÐÐÊýÒ»Ñù£¬¶øÁÐÊýÒ²±ØÐëºÍº¬ÓÐ×î¶àÁÐÊý¡¡

¶ÔÏóµÄÁÐÊýÒ»Ñù¡£¡¡ÀýÈ磺¡¡=¡¡SUM£¨£û1£»2£»3£ý£«£û4£»5£»6£ý£©ÄڵĵÚÒ»¸öÊý×éΪ1¡