æ¨å¥½ï¼å¾é«å
´ä¸ºæ¨è§£çï¼
æ¨å¥½ï¼å¾é«å
´ä¸ºæ¨è§£çï¼
è¿æ ·çé®é¢æ好è½ææ ·è¡¨ææªå¾ï¼æè½è¯´æç½ã
ä¸è¡æ±åï¼ä½¿ç¨sum()å½æ°æ±åãå
³äºå
¶ç¨æ³
um å½æ°æ¯æ±åå½æ°ãå®æ¯excelå½æ°ä¸æ为常ç¨çå½æ°ä¹ä¸ï¼sumå½æ°åå«åºç°å¨æ°å¦å½æ°ãå
¨é¨å½æ°ä¸¤ä¸ªç±»å«ä¸ï¼é»è®¤çâ常ç¨å½æ°âä¸ä¹æã
sumå½æ°çè¯æ³å½¢å¼ä¸ºï¼ sum(number1,number2, ...)
sumå½æ°ç注æäºé¡¹ï¼
1ãå½æ°çè¯æ³ä¸number1ï¼number2çåæ°ï¼æå¤æ30个ï¼
2ãå½æ°çè¯æ³ä¸number1ï¼number2çåæ°ï¼æ¢å¯ä»¥æ¯æ°åï¼ä¾1ï¼ï¼ä¹å¯ä»¥æ¯é»è¾å¼ï¼ä¾3ï¼ï¼ä¹å¯ä»¥æ¯è¡¨è¾¾å¼ï¼ä¾3ï¼ï¼ä¹å¯ä»¥æ¯åå
æ ¼å称ï¼ä¹å¯ä»¥æ¯è¿ç»åå
æ ¼çéåï¼ä¾2ï¼ï¼ä¹å¯ä»¥æ¯åå
æ ¼åºåå称ï¼å¹¶ä¸ä»¥ä¸æåç±»å«å°ä¼è¢«è®¡ç®ï¼
3ãå¦ænumber1çåæ°ä¸ºåå
æ ¼å称ãè¿ç»åå
æ ¼éåãåå
æ ¼åºåå称ååªè®¡ç®å
¶ä¸çæ°å¼åå½æ°å
¬å¼æ°å¼ç»æé¨åï¼ä¸è®¡ç®é»è¾å¼ãè¡¨æ ¼ä¸çæå表达å¼ï¼ä¾4ï¼ï¼
sumå½æ°ç¤ºä¾ï¼
ä¾1ã=sum(1,2,3) ç»æ为6ï¼è®¡ç®1ã2ã3ä¸ä¸ªæ°åçåï¼
ä¾2ã=sum(a1:a2) ç»æ为4ï¼è®¡ç®a1å°a2åå
æ ¼ä¹åï¼
ä¾3ã=sum((1+2=3),(1+2),(a1:a2) ç»æ为8ï¼å 为(1+2=3)表达å¼çç»æ为çï¼å¨çµèä¸çç»æ为1ï¼1+2表达å¼çç»æ3ä¼è¢«è®¡ç®ï¼a1å°a2åå
æ ¼ä¹å4ä¼è¢«è®¡ç®ï¼æ以æåçç»æ为8ï¼
ä¾4ã=sum(a1:a5) ç»æ为4ï¼ä¸è®¡ç®å¼ç¨åå
æ ¼ä¸çæå表达å¼ï¼1+2ï¼ãé»è¾è¡¨è¾¾å¼ï¼(1+2=3)ï¼ãä¸è®¡ç®å符ï¼
æ´å¤WPSåå
¬è½¯ä»¶æç¨ï¼è¯·è®¿é®ï¼
http://bbs.wps.cnå¦æçé®ï¼è¯·ç¹å»æç头åæé®ãç¥æ¨çæ´»æå¿«ï¼
å¦æçé®ï¼è¯·ç¹å»æç头åæé®ãç¥æ¨çæ´»æå¿«ï¼