No. | ¼ÁÌ䡦²óÅú | ¤ª¤ì¤¤ |
|
[81083] ɽ·×»»¤Ë¤Ä¤¤¤Æ |
|
|
OS: Windows XP
¥½¥Õ¥È¥¦¥§¥¢Ì¾/¥Ð¡¼¥¸¥ç¥ó:¥¨¥¯¥»¥ë2003
¥Ï¡¼¥Éµ¡¼ï̾/·¿ÈÖ:
¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤Ê¤É:
¤½¤Î¾:¡¡¥Ç¡¼¥¿¤ò·×»»¤¹¤ë»þ¡¢¿ô»ú¤ß¤Î¥Ç¡¼¥¿¤¬²Ã»»¤µ¤ì¤Ê¤¤¤Î¤Ç¤¹¤¬¤É¤¦¤·¤¿¤éÎɤ¤¤Î¤Ç¤·¤ç¤¦¤«¡©¤Þ¤¿¡¢¾®·×¤¬¤¤¤¯¤Ä¤«¤¢¤ëɽ¤Ç¹ç·×¤ò½Ð¤¹¤¿¤á¤Ë¤Ï¤É¤Î¤è¤¦¤Ë¤·¤¿¤éÎɤ¤¤Ç¤¹¤«¡©
¡¡¡¡¡¡¡¡418¡¥12¡¡¡¡¡
¡¡¡¡¡¡¡¡¡¡¡¡0¡¥00¡¡¢
¡¡¡¡¡¡¡¡256¡¥13¡¡£
¡¡¡¡¡¡¡¡¡¡¡¡1¡¥25¡¡¤¡Ê¡¡Á¤¤Ï²£·×»»¤·¤Æ¤¤¤Þ¤¹¡Ë
¡¡¡¡¡¡¡¡123¡¥67¡Ê¿ô»ú¤Î¤ßÆþÎÏ¡Ë
¾®·×¤ò¥ª¡¼¥ÈSUM¤Ç·×»»¤¹¤ë¤È123¡¥67¤¬²Ã»»¤µ¤ì¤Þ¤»¤ó¡¡¡¡
µ¹¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£
¤ß¤ó¤³ (̤ÅÐÏ¿) 2006ǯ5·î23Æü10:17
|
|
|
|
[81084] |
¡Ö²£·×»»¡×¤Î°ÕÌ£¤¬Ê¬¤«¤ê¤Þ¤»¤ó¤¬¡¢¤â¤·½ÅÍפʤé¤â¤¦¾¯¤·ÀâÌÀ¤·¤Æ¤¯¤À¤µ¤¤¡£
¥ª¡¼¥È¥µ¥à¤ò¤¹¤ë¤È¥»¥ë¤Ë =SUM(??:??) ¤È¤¤¤¦¼°¤¬Æþ¤ê¤Þ¤¹¡£¤³¤Î ??:?? ¤¬¹ç·×¤¹¤ëÈϰϤò»Ø¤·¤Æ¤¤¤Þ¤¹¡£¥Þ¥¦¥¹¤Çɽ¤ò¥¯¥ê¥Ã¥¯¤·¤¿¤ê¥É¥é¥Ã¥°(¥Ü¥¿¥ó¤ò²¡¤·¤¿¤Þ¤Þ¥«¡¼¥½¥ë°ÜÆ°)¤¹¤ë¤È¹ç·×¤¹¤ë¤ÎÈϰϤò¹¤²¤¿¤êÊѤ¨¤¿¤ê¤Ç¤¤Þ¤¹¡£ ??:?? ¤ò¥¡¼¥Ü¡¼¥É¤Ç½ñ¤´¹¤¨¤Æ¤âOK¤Ç¤¹¡£
¾®·×¤ò¤¹¤Ê¤É¡¢Èô¤ÓÈô¤Ó¤Î¥»¥ë¤ò¤¹¾ì¹ç¤Ï¡¢¹ç·×¤òÆþ¤ì¤ë¥»¥ë¤òÁª¤Ó¡¢¥¤¥³¡¼¥ë¡Ö=¡×¤òÆþÎϤ·¤Þ¤¹¡£¼¡¤Ë¤¹¥»¥ë¤ò¥¯¥ê¥Ã¥¯¡¢¡Ö+¡×¤òÆþÎÏ¡¢¼¡¤Ë¤¹¥»¥ë¤ò¥¯¥ê¥Ã¥¯¡¢¡¢¡¢¤È·«¤êÊÖ¤¹¤È¤·»»¤Î¼°¤ò½ñ¤¯¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
¥»¥ë¤Ë¡Ö=¡×¤ÇÆþÎϤò»Ï¤á¤ë¤È¼°¤ÎÆþÎϤˤʤê¤Þ¤¹¡£¥»¥ë¤Ï A5 ¤Î¤è¤¦¤Ë²£½Ä¤Î°ÌÃÖ¤Çɽ¤·¤Þ¤¹¡£¤³¤ì¤Ç¼°¤ò½ñ¤¯¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
¤ªÌò¤Ë¤¿¤Á¤Þ¤·¤¿¤Ç¤·¤ç¤¦¤«¡£
¥·¥ç¥¦¥³ (̤ÅÐÏ¿) 2006ǯ5·î23Æü12:10
|
|
|
|
[81090] |
>¾®·×¤¬¤¤¤¯¤Ä¤«¤¢¤ëɽ¤Ç¹ç·×¤ò½Ð¤¹
=SUM¤ËÂؤ¨¤Æ¾®·×¤ÎÉôʬ¤È¡¢¹ç·×¤ÎÉôʬ¤ÎξÊý¤Ë
=SUBTOTAL(9,??:??)¤ò»È¤¤¤Þ¤¹¡£
¤³¤ì¤ÇÆó½Å¤Î²Ã»»¤¬Ëɻߤµ¤ì¤Þ¤¹¡£
>¾®·×¤ò¥ª¡¼¥ÈSUM¤Ç·×»»¤¹¤ë¤È123¡¥67¤¬²Ã»»¤µ¤ì¤Þ¤»¤ó
¾õ¶·¤¬²ò¤ê¤Þ¤»¤ó¡£¼°¤òµºÜ¤·¤Æ¤¯¤ì¤¿¤é²ò¤ë¤«¤â¤Ç¤¹
mit56 (̤ÅÐÏ¿) 2006ǯ5·î23Æü16:20
|
|
|
|
[81093] |
¤´²óÅúÍÆñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
¡áA1*B1¡¡418¡¥12
¡áA2*B2¡¡¡¡¡¡0¡¥00
¡áA3*B3¡¡256¡¥13
¡áA4*B4¡¡¡¡¡¡1¡¥25
¡¡¡¡¡¡¡¡ 123¡¥67¡¡¡Ê¼°ÆþÎϤϤʤ¯¿ô»ú¤Î¤ßÆþÎÏ¡Ë¡¡
¾®·×¡¡¡¡799¡¥17¤Ë¤Ê¤ë¤È»×¤¤¤Þ¤¹¤¬¡¢¡áSUM¤Ç¾®·×¤ò½Ð¤¹¤È675¡¥5¤·¤«½Ð¤º123¡¥67¤¬²Ã»»¤µ¤ì¤Ê¤¤¤Î¤Ç¤¹¡£¡¡
¤¦¤Þ¤¯¤´ÀâÌÀ¤Ç¤¤Ê¤¯¤ÆºÑ¤ß¤Þ¤»¤ó¡£
¤ß¤ó¤³ (̤ÅÐÏ¿) 2006ǯ5·î23Æü20:01
|
|
|
|
[81100] |
CÎó¤È¤·¤Æ¡¢
=SUM(C1:C5)¤Ë¤¹¤ì¤ÐOK¤È»×¤¦¤Î¤Ç¤¹¤¬¡¢¤Ê¤Ã¤Æ¤¤¤Þ¤¹¤«¡©
¾åµ¤ÎÄ̤ê¤Ë¤Ê¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ï¡¢C5¥»¥ë¤Î½ñ¼°¤¬Ê¸»úÎó¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤«¤â¤Ç¤¹¡£
½ñ¼°¤¬¡Öɸ½à¡×¤ä¡Ö¿ôÃÍ¡×Åù¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤«³Îǧ¤·¤Æ²¼¤µ¤¤¡£
mit56 (̤ÅÐÏ¿) 2006ǯ5·î24Æü00:16
|
|
|
|
[81118] |
¤Á¤Ê¤ß¤Ë
=SUM(C1:C4)+C5
¤ÇÀµ¤·¤¯½Ð¤ë¤Ê¤é¤Ð
>¾åµ¤ÎÄ̤ê¤Ë¤Ê¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ï¡¢C5¥»¥ë¤Î½ñ¼°¤¬Ê¸»úÎó¤Ë¤Ê¤Ã¤Æ¤¤¤ë
¤Ç¤¹¡£
½ñ¼°¤ò¿ôÃͤޤ¿¤ÏG/ɸ½à¤Ëľ¤·¤¿¤é C5¥»¥ë¤ò¤â¤¦°ìÅÙÆþÎϤ·¤Ê¤ª¤¹¤«
C5¥»¥ë¤Ç [F2] ¡ä [Enter] ¤È¥¡¼Áàºî¤ò¤·¤Æ¤¯¤À¤µ¤¤
C5¥»¥ë°Ê³°¤Ë¤âÊ£¿ô¤¢¤ë¤è¤¦¤Ç¤·¤¿¤é¾¤ÎÊýË¡¤Ç¿ôÃͤËÊÑ´¹¤·¤Þ¤¹¡£
¿ô»ú¡§Ê¸»úÎ󡣤½¤Î¤Þ¤Þ¤Ç¤Ï·×»»¤Ç¤¤Ê¤¤¤Î¤Ç·×»»²áÄø¤Ç¿ôÃͤËÊÑ´¹¤¹¤ëɬÍפ¬¤¢¤ë
¿ôÃÍ¡§ÃͤʤΤǤ½¤Î¤Þ¤Þ·×»»²Äǽ
auslese (234) 2006ǯ5·î24Æü17:23
|
|
|
|
[81122] |
¥·¥ç¥¦¥³ÍÍ¡¢mit56ÍÍ¡¢auslese(129) ÍÍÍÆñ¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
ÌäÂê²ò·èÃפ·¤Þ¤·¤¿¡£ËÜÅö¤ËÍê¤ê¤Ë¤Ê¤ë³§ÍͤǤ¹¡£¤Þ¤¿¡¢¼ÁÌ䤬¤¢¤ê¤Þ¤·¤¿¤éµ¹¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£
¤ß¤ó¤³ (̤ÅÐÏ¿) 2006ǯ5·î24Æü18:47
|
|
|
|
( »²¾È¿ô:1484 ÆüÊ¿¶Ñ:0.2 ) |
|
¡Á¡¡²óÅú¤Î¼õÉÕ¤ò½ªÎ»¤·¤Þ¤·¤¿¡¡¡Á |