{"id":362,"date":"2014-12-11T01:15:16","date_gmt":"2014-12-10T16:15:16","guid":{"rendered":"http:\/\/excelwork.info\/excel\/?p=362"},"modified":"2014-12-11T01:15:16","modified_gmt":"2014-12-10T16:15:16","slug":"reference","status":"publish","type":"post","link":"https:\/\/excelwork.info\/excel\/reference\/","title":{"rendered":"\u7d76\u5bfe\u53c2\u7167\u30fb\u76f8\u5bfe\u53c2\u7167\u30fb\u8907\u5408\u53c2\u7167\u306e\u5207\u308a\u66ff\u3048"},"content":{"rendered":"

\u30bb\u30eb\u53c2\u7167<\/h2>\n

\u300c\u30bb\u30eb\u53c2\u7167\u300d\u3068\u306f\u3001\u6570\u5f0f\u306b\u300c\u30bb\u30eb\u756a\u5730\u300d\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u6570\u5f0f\u3092\u5225\u306e\u30bb\u30eb\u306b\u30b3\u30d4\u30fc\u3057\u305f\u6642\u306b\u300c\u30bb\u30eb\u756a\u5730\u300d\u3092\u3069\u306e\u3088\u3046\u306b\u5909\u5316\u3055\u305b\u308b\u304b\u306b\u3088\u308a\u300c\u76f8\u5bfe\u53c2\u7167\u300d\u300c\u7d76\u5bfe\u53c2\u7167\u300d\u300c\u8907\u5408\u53c2\u7167\u300d3\u7a2e\u985e\u306b\u308f\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002
\n\u203b\u300c\u30bb\u30eb\u756a\u5730\u300d\u3068\u306f\u3001\u300cA2\u300d\u300cB3\u300d\u300cC8\u300d\u306a\u3069\u306e\u3088\u3046\u306b\u300c\u5217\u540d\u300d\u3068\u300c\u884c\u756a\u53f7\u300d\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u793a\u3059\u30bb\u30eb\u306e\u4f4d\u7f6e\u306e\u3053\u3068\u3002<\/p>\n

\"\u30bb\u30eb\u53c2\u7167\u5207\u308a\u66ff\u3048\"<\/a><\/p>\n

\u76f8\u5bfe\u53c2\u7167<\/h3>\n

\u76f8\u5bfe\u53c2\u7167\u3068\u306f\u3001\u30bb\u30eb\u3092\u30b3\u30d4\u30fc\u3057\u305f\u6642\u3001\u30da\u30fc\u30b9\u30c8\u3057\u305f\u30bb\u30eb\u304c\u3001\u305d\u306e\u30bb\u30eb\u7bc4\u56f2\u306b\u5408\u308f\u305b\u3066\u30bb\u30eb\u756a\u5730\u304c\u5909\u5316\u3059\u308b\u53c2\u7167\u306e\u4ed5\u65b9\u306e\u3053\u3068\u3002
\n\u4e0b\u56f3\u306f\u3001\u300cE4\u300d\u30bb\u30eb\u306b\u300c=C4*D4\u300d\u3068\u3044\u3046\u6570\u5f0f\u3092\u5165\u529b\u3001\u305d\u308c\u3092\u30b3\u30d4\u30fc\u3057\u3066\u30bb\u30eb\u300cE5\u300d\uff5e\u300cE8\u300d\u306b\u6570\u5f0f\u3092\u30da\u30fc\u30b9\u30c8\u3057\u305f\u3082\u306e\u3002\u56f3\u306e\u901a\u308a\u300cE5\u300d\uff5e\u300cE8\u300d\u306f\u3001\u305d\u308c\u305e\u308c\u306e\u30bb\u30eb\u306b\u5408\u308f\u305b\u3066\u6570\u5f0f\u306e\u30bb\u30eb\u756a\u5730\u304c\u5909\u5316\u3057\u3066\u3044\u308b\u3002
\n\u3053\u306e\u6642\u306e\u30bb\u30eb\u756a\u5730\u306f\u300cE4\u300d\u306e\u3088\u3046\u306b\u5358\u306b\u300c\u5217\u540d\u300d\u3068\u300c\u884c\u756a\u53f7\u300d\u306e\u307f\u306e\u7d44\u307f\u5408\u308f\u305b\u3068\u306a\u308b\u3002<\/p>\n

\"\u76f8\u5bfe\u53c2\u7167\"<\/a><\/p>\n

\u7d76\u5bfe\u53c2\u7167<\/h3>\n

\u7d76\u5bfe\u53c2\u7167\u306e\u5834\u5408\u306f\u3001\u300c\u5217\u540d\u300d\u300c\u884c\u756a\u53f7\u300d\u3092\u56fa\u5b9a\u3067\u53c2\u7167\u3059\u308b\u3002
\n\u4e0b\u56f3\u306e\u3088\u3046\u306a\u5834\u5408\u3001\u76f8\u5bfe\u53c2\u7167\u3092\u5229\u7528\u3057\u305f\u5834\u5408\u3001\u30b3\u30d4\u30fc\u3057\u305f\u6642\u6d88\u8cbb\u7a0e\u306e\u30bb\u30eb\u304c\u3046\u307e\u304f\u53c2\u7167\u3055\u308c\u306a\u304f\u306a\u308b\u306e\u3067\u3001\u3053\u306e\u30bb\u30eb\u3092\u7d76\u5bfe\u53c2\u7167\u306b\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3046\u307e\u304f\u8a08\u7b97\u3067\u304d\u308b\u3002
\n\u30bb\u30eb\u756a\u5730\u306f\u300c$C$10\u300d\u306e\u3088\u3046\u306b\u300c\u5217\u540d\u300d\u300c\u884c\u756a\u53f7\u300d\u306e\u524d\u306b\u300c$\u300d\u30de\u30fc\u30af\u3092\u3064\u3051\u3066\u8868\u8a18\u3059\u308b\u3002<\/p>\n

\"\u7d76\u5bfe\u53c2\u7167\"<\/a><\/p>\n

\u8907\u5408\u53c2\u7167<\/h3>\n

\u8907\u5408\u53c2\u7167\u3068\u306f\u3001\u300c\u5217\u540d\u300d\u304c\u76f8\u5bfe\u53c2\u7167\u300c\u884c\u756a\u53f7\u300d\u304c\u7d76\u5bfe\u53c2\u7167\u3001\u307e\u305f\u306f\u300c\u5217\u540d\u300d\u304c\u7d76\u5bfe\u53c2\u7167\u300d\u300c\u884c\u756a\u53f7\u300d\u304c\u76f8\u5bfe\u53c2\u7167\u306e\u3044\u305a\u308c\u304b\u3002
\n\u4e0b\u56f3\u306e\u3088\u3046\u306a\u5834\u5408\u3067\u4f7f\u7528\u3059\u308b\u3002\u300cD4\u300d\u30bb\u30eb\u306b\u306f\u3001\u300c=SUM(C4:C$4\uff09\u300d\u306e\u6570\u5f0f\u3092\u5165\u529b\u3002
\n\u300cD4\u300d\u3092\u30b3\u30d4\u30fc\u3057\u3001\u300cD5\u300d\uff5e\u300cD13\u300d\u306b\u30da\u30fc\u30b9\u30c8\u3059\u308b\u3068\u300cC$4\u300d\u306e\u300c$4\u300d\u306e\u90e8\u5206\u306f\u56fa\u5b9a\u3055\u308c\u308b\u3002
\n\uff08\u203b\u3053\u306e\u5834\u5408\u306f\u3001\u300c=SUM(C4:$C$4)\u300d\u3068\u3057\u3066\u3082\u7d50\u679c\u306f\u540c\u3058\uff09<\/p>\n

\"\u8907\u5408\u53c2\u7167\"<\/a>
\n

<\/p>\n

\u30bb\u30eb\u53c2\u7167\u65b9\u6cd5\u306e\u5207\u308a\u66ff\u3048<\/h2>\n

\u300c\u7de8\u96c6\u72b6\u614b\u300d\u307e\u305f\u306f\u300c\u6570\u5f0f\u30d0\u30fc\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u79fb\u52d5\u3057\u305f\u72b6\u614b\u300d\u3067\u300cF4\u300d\u30ad\u30fc\u3092\u62bc\u3059\u3053\u3068\u3067\u5207\u308a\u66ff\u308f\u308b\u3002<\/p>\n\n\n\n\n\n
\u300cF4\u300d\u30ad\u30fc\u3092\uff11\u56de\u62bc\u3059<\/td>\n\u7d76\u5bfe\u53c2\u7167\uff08\u30bb\u30eb\u756a\u5730\u306f\u56fa\u5b9a\uff1a\u4f8b\u3000$A$5\uff09<\/td>\n<\/tr>\n
\u300cF4\u300d\u30ad\u30fc\u3092\uff12\u56de\u62bc\u3059<\/td>\n\u8907\u5408\u53c2\u7167\uff1c\u884c\uff1a\u76f8\u5bfe\uff0f\u5217\uff1a\u7d76\u5bfe\uff1e\uff08\u30bb\u30eb\u756a\u5730\u306f\u884c\u306e\u307f\u56fa\u5b9a\u3055\u308c\u308b\uff1a\u4f8b\u3000A$5\uff09<\/td>\n<\/tr>\n
\u300cF4\u300d\u30ad\u30fc\u3092\uff13\u56de\u62bc\u3059<\/td>\n\u8907\u5408\u53c2\u7167\uff1c\u884c\uff1a\u7d76\u5bfe\uff0f\u5217\uff1a\u76f8\u5bfe\uff1e\uff08\u30bb\u30eb\u756a\u5730\u306f\u5217\u306e\u307f\u56fa\u5b9a\u3055\u308c\u308b\uff1a\u4f8b\u3000$A5\uff09<\/td>\n<\/tr>\n
\u300cF4\u300d\u30ad\u30fc\u3092\uff14\u56de\u62bc\u3059<\/td>\n\u76f8\u5bfe\u53c2\u7167\uff08\u30bb\u30eb\u756a\u5730\u306f\u5909\u5316\u3059\u308b\uff1a\u4f8b\u3000A5\uff09<\/td>\n<\/tr>\n<\/table>\n

\n","protected":false},"excerpt":{"rendered":"

\u30bb\u30eb\u53c2\u7167 \u300c\u30bb\u30eb\u53c2\u7167\u300d\u3068\u306f\u3001\u6570\u5f0f\u306b\u300c\u30bb\u30eb\u756a\u5730\u300d\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u6570\u5f0f\u3092\u5225\u306e\u30bb\u30eb\u306b … <\/p>\n","protected":false},"author":1,"featured_media":384,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"amp_status":"","spay_email":"","jetpack_publicize_message":""},"categories":[2],"tags":[17,18,19],"jetpack_featured_media_url":"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2014\/12\/reference01a-400x2051.jpg?fit=400%2C205&ssl=1","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4Ye9i-5Q","_links":{"self":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/362"}],"collection":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/comments?post=362"}],"version-history":[{"count":17,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/362\/revisions"}],"predecessor-version":[{"id":383,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/362\/revisions\/383"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media\/384"}],"wp:attachment":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media?parent=362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/categories?post=362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/tags?post=362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}