
Excel¤Ë¤Ï¥Õ¥£¥ë¥¿µ¡Ç½¤È¤¤¤¦¤Î¤¬¤¢¤ê¤Þ¤¹¡£»ØÄꤷ¤¿¥Ç¡¼¥¿¤Î¤ß¤òÃê½Ð¤·É½¼¨¤¹¤ëµ¡Ç½¤Ê¤ó¤Ç¤¹¤¬¡¢¤½¤ÎÃê½Ð¤µ¤ì¤Ê¤«¤Ã¤¿¥Ç¡¼¥¿¤È¤¤¤¦¤Î¤ÏÈóɽ¼¨°·¤¤¤Ç±£¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¤¬¡¢Èóɽ¼¨¤µ¤ì¤ë¤À¤±¤Ç¥Ç¡¼¥¿¼«ÂΤϸºß¤·¤Þ¤¹¤Î¤Ç¡¢¤¿¤È¤¨¤Ð¹ç·×¤ò½Ð¤¹SUM´Ø¿ô¤ò»È¤¦¤È¡¢Èóɽ¼¨Éôʬ¤â¹ç·×¤µ¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¥Õ¥£¥ë¥¿¤Ë³Ý¤«¤Ã¤¿·ë²Ì¤Î¤ß¡¢É½¼¨¤µ¤ì¤Æ¤¤¤ë¥Ç¡¼¥¿¤Î¤ß¤ò¹ç·×¤·¤¿¤¤¾ì¹ç¤Ï¤É¤¦¤·¤¿¤éÎɤ¤¤ó¤Ç¤·¤ç¤¦¤«¡£
¥Õ¥£¥ë¥¿¥ê¥ó¥°¤¹¤ë

¤Þ¤º¤Ï¾å¤Î¥Ç¡¼¥¿¤ò¥Õ¥£¥ë¥¿¥ê¥ó¥°¤·¤Æ¤ß¤Þ¤¹¡£¾ÃÌ×ÉÊÈñ¡¦½¤Á¶Èñ¤Î¤ß¤òÃê½Ð¤·¤¿¤¤¤È»×¤¤¤Þ¤¹¡£
| ¡£Á£³¤«¤é£Ã£±£°¤Þ¤Ç¤òÁªÂò¤·¤Þ¤¹ | ¢ª | ¢¥Õ¥£¥ë¥¿¥Ü¥¿¥ó¤ò²¡¤·¤Þ¤¹ | ¢ª | £²ÊÌÜ¥Õ¥£¥ë¥¿¤Î¾ÃÌס¦½¤Á¶°Ê³°¥Á¥§¥Ã¥¯¤ò³°¤·¤Þ¤¹¡£ |
 |  |  |
¤¹¤ë¤È¤³¤Î¤è¤¦¤Ê·ë²Ì¤Ë¤Ê¤ê¤Þ¤¹¡£
¤·¤«¤·¤Ç¤¹¡ª¶â³ÛÍó¤ò¸«¤Æ¤¯¤À¤µ¤¤¡£6,500+120,000+800¤Î¹ç·×¤Ï
127,300¤Ë¤Ê¤é¤Ê¤¤¤È¤¤¤±¤Þ¤»¤ó¡£

¤³¤ì¤¬SUM´Ø¿ô¡£±£¤ì¤Æ¤¤¤ë¸üÀ¸Èñ¡¢¸òÄÌÈñ¡¢Î¹Èñ¤â¹ç·×¤·¤Æ¤·¤Þ¤¦¤ó¤Ç¤¹¡£
¤Ç¤Ï¤É¤¦¤¹¤ì¤Ð¤¤¤¤¤Î¡©
¤³¤³¤Ç»È¤¦¤Î¤¬SUBTOTAL´Ø¿ô¤Ç¤¹¡£
¤¢¤Þ¤êʹ¤´·¤ì¤Ê¤¤´Ø¿ô¤Ç¤¹¤¬¡¢¹ç·×¡ÊSUM)¤À¤±¤Ç¤Ê¤¯¡¢COUNT¤äAVERAGE¡¢ºÇÂçÃÍ¡ÊMAX¡Ë¡¢ºÇ¾®ÃÍ¡ÊMIN¡Ë¤â¤³¤Î´Ø¿ô°ì¤Ä¤Ç°·¤¨¤Þ¤¹¡£
º£²ó¤Î¥Ñ¥¿¡¼¥ó¤À¤È°Ê²¼¤Î¼°¤Ë¤Ê¤ê¤Þ¤¹¡£

SUBTOTAL´Ø¿ô¤Î°ú¿ô¤Ï£²¤Ä¡£
¡áSUBTOTAL¡Ê¡¡½¸·×ÊýË¡¡¡¡¤¡¡Èϰϡ¡¡Ë¡¡¤Ç¤¹¡£
¤³¤Î½¸·×ÊýË¡¤È¤¤¤¦¤Î¤Ïͽ¤á·è¤á¤é¤ì¤¿Èֹ椬¤¢¤ê¡¢ÈÖ¹æËè¤Ë½¸·×ÊýË¡¤¬·è¤Þ¤Ã¤Æ¤¤¤Þ¤¹¡£SUM¤À¤È9¤Ç¤¹¡£²¼µ¤Îɽ¤ò»²¹Í¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£
| ÈÖ¹æ | ½¸·×ÊýË¡ |
| 1 | AVERAGE |
| 2 | COUNT |
| 3 | COUNTA |
| 4 | MAX |
| 5 | MIN |
| 6 | PRODUCT |
| 7 | STDEV |
| 8 | STDEVP |
| 9 | SUM |
| 10 | VAR |
| 11 | VARP |
¾¤ÎÎã¤ò½Ð¤¹¤È¡¢
¡áCOUNT(C4:C10¡Ë¡¡¤Î·ë²Ì¤Ï¡¡7¡¡¤Ç¤¹¤¬
¡áSUBTOTAL(2,C4:C10¡Ë¡¡¤Î·ë²Ì¤À¤È¡¡3¡¡¤Ë¤Ê¤ê¤Þ¤¹¡£
¥³¥á¥ó¥È°ìÍ÷