Google Docs¤ÎSpreadsheet¤¬¤ª¤â¤·¤í¤¤¤Ç¤¹¡£
¤¢¡¢¡Ö¥ä¥Ð¥¤¡×¤Ï¤Û¤á¸ÀÍդȤ·¤Æ¤Î°ÕÌ£¤Ç¤¹¡£
Ìܻؤ¹Êý¸þÀ¤¬°ã¤¤¤Þ¤¹¤«¤é¡¢¸½ºß¤ÎExcel¤ÈÈæ³Ó¤¹¤ë¤³¤È¤Ï¤¢¤Þ¤ê°ÕÌ£¤¬¤¢¤ê¤Þ¤»¤ó¤¬¡¢¤È¤ê¤¢¤¨¤º¡¢¼ÂÁõ¤·¤Æ¤¤¤ë¥ï¡¼¥¯¥·¡¼¥È´Ø¿ô¤òÈæ³Ó¤·¤Æ¤ß¤Þ¤·¤¿¡£
¤Þ¤º¡¢Excel 2007¤Ë¤Ï¤¢¤ë¤±¤É¡¢Google Spreadsheet¤Ë¤Ï¤Ê¤¤´Ø¿ô¤Ç¤¹¡£
| AMORDEGRC | CUBESETCOUNT | GAMMALN | NUMBERSTRING | | AMORLINC | CUBEVALUE | GESTEP | ODDFPRICE | | AREAS | DATEDIF | GETPIVOTDATA | ODDFYIELD | | ASC | DAVERAGE | IMABS | ODDLPRICE | | AVERAGEIF | DBCS | IMAGINARY | ODDLYIELD | | AVERAGEIFS | DCOUNT | IMARGUMENT | PHONETIC | | BAHTTEXT | DCOUNTA | IMCONJUGATE | REGISTER.ID | | BESSELI | DELTA | IMCOS | REPLACEB | | BESSELJ | DGET | IMDIV | RIGHTB | | BESSELK | DMAX | IMEXP | ROMAN | | BESSELY | DMIN | IMLN | RTD | | BETADIST | DPRODUCT | IMLOG10 | SEARCHB | | BETAINV | DSTDEV | IMLOG2 | SQL.REQUEST | | CALL | DSTDEVP | IMPOWER | SUBTOTAL | | CELL | DSUM | IMPRODUCT | SUMIFS | | CHIDIST | DVAR | IMREAL | TDIST | | CHIINV | DVARP | IMSIN | TIMEVALUE | | CHITEST | ERF | IMSQRT | TINV | | CLEAN | ERFC | IMSUB | TTEST | | COMPLEX | EUROCONVERT | IMSUM | TYPE | | CONVERT | EVALUATE | INFO | VDB | | COUNTIFS | FDIST | ISPMT | WEEKNUM | | CUBEKPIMEMBER | FINDB | JIS | YEN | | CUBEMEMBER | FINV | LEFTB | YIELDMAT | | CUBEMEMBERPROPERTY | FTEST | LENB | | | CUBERANKEDMEMBER | GAMMADIST | LOOKUP | | | CUBESET | GAMMAINV | MIDB | |
|
ï¤â»È¤ï¤Ê¤¤¤è¤¦¤Ê´Ø¿ô¤Ï¤È¤â¤«¤¯¡¢¤è¤¯»È¤¦´Ø¿ô¤Ç¤Ï
¡¦Á´³Ñ¤Îʸ»úÎó¤òȾ³Ñ¤Ë¤¹¤ëASC´Ø¿ô¤ä¡¢È¾³Ñ¢ªÁ´³Ñ¤Ë¤¹¤ëJIS´Ø¿ô¤Ï¤Ê¤¤
¡¦Excel 2007¤ÇÄɲ䵤줿¼¡¤Î´Ø¿ô¤Ï¤Ê¤¤
¡¡¡¡AVERAGEIF
¡¡¡¡AVERAGEIFS
¡¡¡¡COUNTIFS
¡¡¡¡SUMIFS
¡¡¡¡¤¿¤À¤·¡¢IFERROR´Ø¿ô¤Ï¤¢¤ë
¡¦¤Á¤ç¤Ã¤ÈÆÃ¼ì¤ÊCELL´Ø¿ô¡¢EVALUATE´Ø¿ô¡¢INFO´Ø¿ô¡¢TYPE´Ø¿ô¤Ï¤Ê¤¤
¡¦Excel¤Î±£¤·´Ø¿ô
¡¡¡¡DATEDIF
¡¡¡¡NUMBERSTRING
¡¡¡¡¤Ï¤Ê¤¤
¡¦DSUM´Ø¿ô¤äDAVERAGE´Ø¿ô¤Ê¤É¡¢¤¤¤ï¤æ¤ëD´Ø¿ô(¥Ç¡¼¥¿¥Ù¡¼¥¹´Ø¿ô)¤Ï¤Ê¤¤
¡¦FINDB´Ø¿ô¤Ê¤É¡¢¥Ð¥¤¥Ê¥ê¤ò°·¤¦¡Ö¡ÁB´Ø¿ô¡×¤Ï¤Ê¤¤
¡¦¥Ô¥Ü¥Ã¥È¥Æ¡¼¥Ö¥ë¤¬¤Ê¤¤¤Î¤À¤«¤é¡¢ÅöÁ³GETPIVOTDATA´Ø¿ô¤â¤Ê¤¤
¡¦¤Õ¤ê¤¬¤Êµ¡Ç½¤¬¤Ê¤¤¤Î¤À¤«¤é¡¢ÅöÁ³PHONETIC´Ø¿ô¤â¤Ê¤¤
¡¦LOOKUP´Ø¿ô¤¬¤Ê¤¤¤Î¤Ï¡¢¤Á¤ç¤Ã¤ÈÈᤷ¤¤
¡¦SUBTOTAL´Ø¿ô¤â¤Ê¤¤¤Î¤«
¡¦DATEVALUE´Ø¿ô¤Ï¤¢¤ë¤±¤É¡¢TIMEVALUE´Ø¿ô¤Ï¤Ê¤¤
¡¦WEEKNUM´Ø¿ô¤Ï¤Ê¤¤
¡¦YEN´Ø¿ô¤â¤Ê¤¤¡£¤Ê¤¯¤Æ¤¤¤¤¤±¤É
¼Â³²¤Ï¤¢¤ê¤Þ¤»¤ó¤Í¡£ÉáÄ̤˻Ȥ¦Ê¬¤Ë¤Ï¡Ö´Ø¿ô¤¬¤Ê¤¯¤Æº¤¤ë¡×¤È¤¤¤¦¤³¤È¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¡£¤Ç¤¤ì¤Ð¡¢LOOKUP´Ø¿ô¤ÏÍߤ·¤«¤Ã¤¿¤±¤É¡£
µÕ¤Ë¡¢Google Spreadsheet¤Ë¤Ï¤¢¤ë¤±¤É¡¢Excel¤Ë¤Ï¤Ê¤¤´Ø¿ô¤Ï¼¡¤ÎÄ̤ꡣ
| ADD | FILTER | | CONCAT | SORT | | DIVIDE | SPLIT | | EQ | UNIQUE | | GT | GoogleFinance | | GTE | GoogleLookup | | LT | ImportData | | LTE | ImportFeed | | MINUS | ImportHtml | | MULTIPLY | ImportRange | | NE | ImportXML | | POW | |
|
ɽ¤Îº¸Îó¤Ë¤¢¤ë¤Î¤Ï¡¢¡Ü¤ä¡¿¤Ê¤É¤Î±é»»»Ò¤ÈƱ¤¸Æ¯¤¤ò¤¹¤ë´Ø¿ô¤Ç¤¹¡£
±é»»»Ò¤¬¤¢¤ë¤«¤é¡¢ÉáÄ̤ϻȤï¤Ê¤¤¤Ç¤·¤ç¤¦¡£
±¦Îó¤Ë¤¢¤ë´Ø¿ô¤ËÃíÌܤ·¤¿¤¤¤Ç¤¹¤Í¡£
¡ÖGoogle¡Á¡×¤ä¡ÖImport¡Á¡×¤Ï¡¢¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Ê¤é¤Ç¤Ï¤ÎÆÃ¼ì¤Ê´Ø¿ô¤Ç¤¹¡£
¤³¤ì¤Ë¤Ä¤¤¤Æ¤Ï¡¢¤¢¤é¤¿¤á¤Æ¤¸¤Ã¤¯¤ê¾Ò²ð¤·¤Þ¤¹¤¬¡¢¤Þ¤º¤Ï
FILTER´Ø¿ô
SORT´Ø¿ô
SPLIT´Ø¿ô
UNIQUE´Ø¿ô
¤Ç¤¹¡£¤³¤¤¤Ä¤é¤¬¡¢¼Â¤Ë¤ª¤â¤·¤í¤¤¤Ç¤¹¡£ÀµÄ¾¡¢¼¡¤ÎExcel¤Ë¤â¼ÂÁõ¤·¤ÆÍߤ·¤¤¤Ç¤¹¤Í¡£
¤Þ¤º¡¢FILTER´Ø¿ô¤«¤é¡£
¤³¤¤¤Ä¤Ï¡¢¥ê¥¹¥È¤ò¾ò·ï¤Ç¹Ê¤ê¹þ¤ó¤À·ë²Ì¤òÊÖ¤¹´Ø¿ô¤Ç¤¹¡£¹Ê¤ê¹þ¤ó¤À·ï¿ô¤¸¤ã¤¢¤ê¤Þ¤»¤ó¡£¹Ê¤ê¹þ¤ó¤À·ë²Ì¤Î¥ê¥¹¥È¤òÊÖ¤·¤Þ¤¹¡£
¤¿¤È¤¨¤Ð¡¢²¼¿Þ¤Î¤è¤¦¤Ê¥ê¥¹¥È¤¬¤¢¤Ã¤¿¤È¤·¤Þ¤¹¡£
¤³¤Î¥ê¥¹¥È¤ò¡Ö¿ôÃͤ¬10¤è¤êÂ礤¤¡×¤È¤¤¤¦¾ò·ï¤Ç¹Ê¤ê¹þ¤ó¤Ç¤ß¤Þ¤¹¡£¥»¥ëD3¤Ë¡Ö=FILTER(A2:A13,B2:B13>19)¡×¤È¤¤¤¦¼°¤òÆþÎϤ·¤Þ¤¹¡£
Enter¥¡¼¤ò²¡¤·¤Æ³ÎÄꤹ¤ë¤È
¤È¡¢¤Ê¤ê¤Þ¤¹¡£¤Ê¤ó¤È¡¢¼°¤òÆþ¤ì¤Ê¤«¤Ã¤¿¥»¥ëÈϰÏD3:D7¤Ë¤â¥Ç¡¼¥¿¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£Excel¤Ç¤âÇÛÎó¤òÊÖ¤¹´Ø¿ô¤Ê¤É¤ò»È¤Ã¤¿¤È¤»÷¤¿¤è¤¦¤Ê·ë²Ì¤òÆÀ¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¤¬¡¢¤½¤ì¤Ë¤·¤Æ¤âÆþÎÏ»þ¤Ë¤Ï¤¢¤é¤«¤¸¤á¥»¥ëÈϰϤòÁªÂò¤·¤Æ¤ª¤«¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£¤Ç¤â¡¢FILTER´Ø¿ô¤Ï·ë²Ì¤¬²¿·ï¤Ë¤Ê¤ë¤«Æþ¤ì¤Æ¤ß¤Ê¤±¤ì¤Ð¤ï¤«¤ê¤Þ¤»¤ó¤Î¤Ç¡¢¤½¤ì¤Ï̵Íý¤Ç¤¹¤Í¡£
¤Ç¡¢¤ª¤â¤·¤í¤¤¤Î¤¬¡¢¾¡¼ê¤Ë¥Ç¡¼¥¿¤¬É½¼¨¤µ¤ì¤¿¥»¥ëÈϰÏD3:D7¤Ç¤¹¡£¼Â¤Ï¡¢¤³¤ì¤é¤Î¥»¥ë¤Ë¤Ï¼«Æ°Åª¤ËÊ̤δؿô¤¬ÆþÎϤµ¤ì¤Æ¤¤¤Þ¤¹¡£
¡ÖCONTINUE(D2,6,1)¡×¤È¤¤¤¦¤è¤¦¤Ê´Ø¿ô¤Ç¤¹¡£Spreadsheet¤Î´Ø¿ô°ìÍ÷¤Ë¤ÏµºÜ¤µ¤ì¤Æ¤¤¤Ê¤¤´Ø¿ô¤Ç¤¹¤«¤é¡¢¤ª¤½¤é¤¯Spreadsheet¤¬¾¡¼ê¤ËÆþ¤ì¤Æ¤¯¤ì¤ë´Ø¿ô¤Ç¤·¤ç¤¦¡£¤â¤Á¤í¤ó¡¢¥æ¡¼¥¶¡¼¤¬¼êÆþÎϤ·¤Æ»È¤¦¤³¤È¤â²Äǽ¤Ç¤¹¡£Excel¤Ç¤¤¤¦¤ÈSUBTOTAL´Ø¿ô¤ß¤¿¤¤¤Ê¤â¤Î¤«¤Ê¡£
CONTINUE¤È¤¤¤¦Ì¾Á°¤È°ú¿ô¤«¤éÁÛÁü¤¹¤ë¤È¡Ö¥»¥ëD2¤ËÆþÎϤ·¤¿¿ô¼°¤Î·ë²Ì¤ò6¹Ô¡ß1Îó¤Ë³ÈÄ¥¤·¤ÆÉ½¼¨¤»¤è¡×Ū¤Ê´Ø¿ô¤Ê¤ó¤Ç¤·¤ç¤¦¤Í¡£¤³¤Î¾õÂ֤ǡ¢¤¿¤È¤¨¤Ð¡¢BÎó¤Î¥Ç¡¼¥¿¤òÊÔ½¸¤·¤¿¤È¤·¤Þ¤¹¡£¥»¥ëB3¤òºï½ü¤¹¤ë¤È¡¢
¤³¤Î¤è¤¦¤Ë¡¢¤Á¤ã¤ó¤ÈÈ¿±Ç¤µ¤ì¤Þ¤¹¡£¤â¤Ã¤È¤âCONTINUE´Ø¿ô¤¬¡ÖCONTINUE(D2,6,1)¡×¤È¡¢·ë²Ì¤òÊÖ¤¹¥»¥ë¿ô¤ò¸ÇÄꤷ¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢ºÇ¸å¤Î¡Ö³ºÅö¤Ê¤·¡×¤Î¥»¥ë¤Ï¡Ö--¡×¤È¤Ê¤ê¤Þ¤¹¡£¤Ç¤Ï¡¢FILTER´Ø¿ô¤Î¾ò·ï¤ËÀßÄꤷ¤¿¡ÖB2:B13>19¡×¤Ë°ìÃפ¹¤ë¥Ç¡¼¥¿¤¬Áý¤¨¤¿¾ì¹ç¤Ï¤É¤¦¤Ç¤·¤ç¤¦¡£

¡¡¡¡¢
¤È¡¢º£Å٤ϤÁ¤ã¤ó¤ÈCONTINUE´Ø¿ô¤¬³ÈÄ¥¤µ¤ì¤Þ¤¹¡£¤¦¡Á¤ó¡¢Excel¤Ç¤Ï·Ð¸³¤·¤¿¤³¤È¤Î¤Ê¤¤·ë²Ì¤Ê¤Î¤Ç¾¯¤·°ãÏ´¶¤â¤¢¤ê¤Þ¤¹¤¬¡¢¤Ê¤«¤Ê¤«¸¤¤¤Ç¤¹¡£
¤â¤Á¤í¤ó¡¢Ê£¿ô¤Î¾ò·ï¤ò»ØÄꤹ¤ë¤³¤È¤â¤Ç¤¤Þ¤¹¡£
º£Å٤ϡֿôÃÍ(BÎó)¤¬10¤è¤êÂ礤¤¡×¤«¤Ä¡Ö¥Õ¥é¥°(CÎó)¤¬"OK"¡×¤È¤¤¤¦¾ò·ï¤Ç¤¹¡£¤¹¤ë¤È¡¢
¤Á¤ã¤ó¤È¹Ê¤ê¹þ¤ó¤Ç¤¯¤ì¤Þ¤¹¡£¥Ø¥ë¥×¤Ë¤è¤ë¤È¾ò·ï¤Ï30¸Ä¤Þ¤Ç»ØÄê¤Ç¤¤ë¤è¤¦¤Ç¤¹¤Í¡£¿ôŪ¤Ë¤ÏÌäÂê¤Ê¤¤¤Ç¤·¤ç¤¦¡£
>If there are multiple conditions, then all must be true for the corresponding values in the source array to be returned.
¤È¤¤¤¦¤³¤È¤Ç¤¹¤«¤é¡¢»ØÄꤷ¤¿Ê£¿ô¤Î¾ò·ï¤ÏAND(¤«¤Ä)¤ÇȽÄꤵ¤ì¤ë¤è¤¦¤Ç¤¹¡£¤Ê¤ª¡¢Âè1°ú¿ô¤ËÊ£¿ôÎó¤ò»ØÄꤹ¤ì¤ÐÊ£¿ôÎó¤òÊÖ¤·¤Æ¤¯¤ì¤Þ¤¹¡£
Excel¤Ç¤â¹©Éפ¹¤ì¤ÐƱ¤¸¤³¤È¤ò¼Â¸½¤Ç¤¤Þ¤¹¤¬¡¢¤½¤ì¤Ë¤·¤Æ¤â¤¢¤é¤«¤¸¤á·ë²Ì¤¬É½¼¨¤µ¤ì¤ë¤Ç¤¢¤í¤¦¥»¥ë¤Ë¿ô¼°¤òÆþ¤ì¤Æ¤ª¤«¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£
¾¤Ë¤â¤«¤Ê¤êÊØÍø¤Ê´Ø¿ô¤¬¼ÂÁõ¤µ¤ì¤Æ¤¤¤Þ¤¹¤¬¡¢Ä¹¤¯¤Ê¤Ã¤¿¤Î¤Çº£²ó¤Ï¤³¤³¤Þ¤Ç¡£¼¡²ó¤Ë³¤¤Þ¤¹¡¦¡¦¡¦