如题所述
SUMå½æ°ï¼æ¯ä»¥éå·åºåä¸ååºåçï¼ä½ çå
¬å¼å¯ä»¥åæï¼
=SUM(H23:H28,H16:H21,H9:H14)
è¿æ ·å°±æä¸ååºåå åå°ä¸èµ·äºï¼
å ¶å®ä¹å¯ä»¥ç¨ä¸ä¸ªåå å½æä¸ä¸ªåºåï¼æ¯å¦ï¼
=SUM(A1,A3)
è¿æ ·æ±çå¼æ¯A1ä¸A3两个åå æ ¼çåï¼
æ¯å¦ï¼
=SUM(A1:A10,B1)
è¿æ ·æ¯æ±A1ï¼A10ï¼å ä¸B1çåï¼
注æåå·ä¸éå·çä¸åã
=SUM(H23:H28,H16:H21,H9:H14)
è¿æ ·å°±æä¸ååºåå åå°ä¸èµ·äºï¼
å ¶å®ä¹å¯ä»¥ç¨ä¸ä¸ªåå å½æä¸ä¸ªåºåï¼æ¯å¦ï¼
=SUM(A1,A3)
è¿æ ·æ±çå¼æ¯A1ä¸A3两个åå æ ¼çåï¼
æ¯å¦ï¼
=SUM(A1:A10,B1)
è¿æ ·æ¯æ±A1ï¼A10ï¼å ä¸B1çåï¼
注æåå·ä¸éå·çä¸åã
温馨提示:答案为网友推荐,仅供参考
第1个回答 2016-10-08
=SUM(H23:H28,H16:H21,H9:H14)
或者如果仅仅是空格,输入
=SUM(H9:H28)
或者如果仅仅是空格,输入
=SUM(H9:H28)