![\"ha_173.jpg\u306e\u30b5\u30e0\u30cd\u30fc\u30eb\u753b\u50cf\"](\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2014\/07\/ha_173-thumb-200x150-2101.jpg\")
<\/span><\/p>\n\u3044\u308d\u3093\u306a\u5922\u3092\u63cf\u3044\u3066\u3001\u3053\u308c\u304b\u3089\u3044\u308d\u3093\u306a\u7d4c\u9a13\u3092\u3057\u3066\u3044\u304f\u306f\u305a\u3060\u3063\u305f\u547d\u3002
\n\u30bb\u30a6\u30a9\u30eb\u53f7\u306e\u4e8b\u6545\u306e\u3068\u304d\u3082\u305d\u3046\u3067\u3057\u305f\u3002<\/p>\n
\u4e00\u4eba\u306e\u5927\u4eba\u3068\u3057\u3066\u3001\u672c\u5f53\u306b\u7533\u3057\u8a33\u306a\u3044\u6c17\u6301\u3061\u3067\u3059\u3002
\n\u540c\u3058\u904e\u3061\u304c\u7e70\u308a\u8fd4\u3055\u308c\u306a\u3044\u3088\u3046\u306b\u3001\u5f37\u304f\u9858\u3044\u307e\u3059\u3002<\/p>\n
\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606<\/p>\n
\u7d2f\u8a08\u3092\u6c42\u3081\u308b\u7c21\u5358\u306a\u65b9\u6cd5<\/span><\/h2>\nExcel\u3067\u306f\u3001\u7d2f\u8a08\u3092\u6c42\u3081\u308b\u5834\u5408\u304c\u3088\u304f\u3042\u308a\u307e\u3059\u3088\u306d\u3002<\/p>\n
\u901a\u5e38\u306f\u3001\u7d2f\u8a08\u3092\u51fa\u3057\u305f\u3044\u5834\u5408\u3001\u8db3\u3057\u7b97\u3057\u3066\u308b\u3068\u601d\u3044\u307e\u3059\u3002\u3000
\n=D6\uff08\u524d\u306e\u7d2f\u8a08\uff09\uff0bC7\uff08\u6b21\u56de\u306e\u53d7\u8b1b\u8005\u6570\uff09<\/b><\/span>
\n\u4eca\u56de\u306f\u3001\u7d2f\u8a08\u3092\u7c21\u5358\u306b\u52b9\u7387\u3088\u304f\u6c42\u3081\u308b\u5225\u306e\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n![\"ruikei2.jpg\"](\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2014\/07\/ruikei2-thumb-400x219-2085.jpg\")
<\/a><\/span><\/p>\n\uff11\uff0e\u7d2f\u8a08\u3092\u6c42\u3081\u308b\u6700\u521d\u306e\u30bb\u30eb<\/b>\u3092\u9078\u3093\u3067\u3001\u03a3\uff08\u30aa\u30fc\u30c8\u30b5\u30e0\uff09\u30dc\u30bf\u30f3<\/b>\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n
![\"ruikei1.jpg\"](\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2014\/07\/ruikei1-thumb-500x412-2088.jpg\")
<\/a><\/span><\/p>\n\uff12\uff0eC6<\/b>\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001F4<\/b>\u3000\u3092\u62bc\u3057\u3001\u7d76\u5bfe\u53c2\u7167\uff08\u56fa\u5b9a\u30fb\u5e38\u306b\u53c2\u7167\u3059\u308b\u3088\u3046\uff09\u306b\u3057\u307e\u3059\u3002<\/p>\n
![\"ruikei3.jpg\"](\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2014\/07\/ruikei3-thumb-400x233-2090.jpg\")
<\/a><\/span><\/p>\n\uff13\uff0e\u7d9a\u3044\u3066\u3001\u300c\uff1aC6\u300d<\/b><\/span>\u3068\u5165\u529b\u3057\u3001Enter<\/b>\u3000\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n![\"ruikei4.jpg\"](\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2014\/07\/ruikei4-thumb-400x215-2092.jpg\")
<\/a><\/span><\/p>\n\uff14\uff0e\u4e0b\u306e\u884c\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002
\n![\"ruikei5.jpg\"](\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2014\/07\/ruikei5-thumb-400x250-2094.jpg\")
<\/a><\/span>\uff15\uff0e\u7d2f\u8a08\u304c\u6c42\u3081\u3089\u308c\u307e\u3057\u305f\u3002
\n![\"ruikei5.jpg\"](\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2014\/07\/ruikei5-thumb-400x372-2094.jpg\")
<\/a><\/span>\uff16\uff0e\u6700\u4e0b\u884c\u306e\u30bb\u30eb\u306e\u5f0f\u3092\u898b\u3066\u307f\u308b\u3068\u3001=SUM($C$6:C21\uff09<\/b><\/span>\u203b\u9752\u67a0\u306e\u7bc4\u56f2
\n\u3068\u306a\u3063\u3066\u3044\u3066\u3001C6\u3092\u7d76\u5bfe\u53c2\u7167\uff08F4\uff09\u3060\u3051\u56fa\u5b9a\u3057\u3066\u308b\u306e\u3067\u3001\u7bc4\u56f2\u304c\u4e00\u3064\u305a\u3064\u5e83\u304c\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002
\n![\"ruikei7.jpg\"](\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2014\/07\/ruikei7-thumb-400x378-2099.jpg\")
<\/a><\/span><\/p>\n\u3044\u304b\u304c\u3067\u3057\u305f\u304b\uff1f<\/p>\n
Excel\u306e\u7d76\u5bfe\u53c2\u7167\uff08\u30bb\u30eb\u56fa\u5b9a\uff09\u3068\u76f8\u5bfe\u53c2\u7167\uff08\u4e00\u3064\u305a\u3064\u53c2\u7167\u3059\u308b\u30bb\u30eb\u3092\u79fb\u52d5\uff09\u3092\u4f7f\u3046\u3068
\n\u3059\u3054\u304f\u4fbf\u5229\u3067\u3059\u3088\u306d\u3002<\/p>\n
\u305c\u3072\u3001\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\u3002<\/p>\n
\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606 \u524d\u306e\u8a18\u4e8b<\/a><\/b> \u2606\u2606<\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"\u307f\u306a\u3055\u307e\u3001\u3053\u3093\u306b\u3061\u306f\uff01 \u30e2\u30ab\u3067\u3059\u3002 \u304a\u5143\u6c17\u3067\u3059\u304b\uff1f \u6885\u96e8\u660e\u3051\u3001\u897f\u306e\u307b\u3046\u304b\u3089\u3057\u3066\u6765\u3066\u3044\u307e\u3059\u306d\u3002 \u590f\u672c\u756a\u3067\u3059\uff01 \u3044\u308d\u3093\u306a\u3053\u3068\u304c\u8d77\u3053\u3063\u3066\u3044\u308b\u306e\u3067\u3001 \u5fc3\u304c\u75db\u307f\u307e\u3059\u3002\u3068\u304f\u306b\u30de\u30ec\u30fc\u30b7\u30a2\u822a\u7a7a\u6a5f\u306e\u4e8b\u6545\u3002 \u3042\u3063\u3066\u306f\u306a\u3089\u306a\u3044\u3053\u3068\u3060\u3001\u3068\u6700\u521d\u306f […]<\/p>\n","protected":false},"author":2,"featured_media":2533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-370","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/comments?post=370"}],"version-history":[{"count":2,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/370\/revisions"}],"predecessor-version":[{"id":2993,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/370\/revisions\/2993"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media\/2533"}],"wp:attachment":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media?parent=370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/categories?post=370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/tags?post=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n=D6\uff08\u524d\u306e\u7d2f\u8a08\uff09\uff0bC7\uff08\u6b21\u56de\u306e\u53d7\u8b1b\u8005\u6570\uff09<\/b><\/span>
\n\u4eca\u56de\u306f\u3001\u7d2f\u8a08\u3092\u7c21\u5358\u306b\u52b9\u7387\u3088\u304f\u6c42\u3081\u308b\u5225\u306e\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n
\uff11\uff0e\u7d2f\u8a08\u3092\u6c42\u3081\u308b\u6700\u521d\u306e\u30bb\u30eb<\/b>\u3092\u9078\u3093\u3067\u3001\u03a3\uff08\u30aa\u30fc\u30c8\u30b5\u30e0\uff09\u30dc\u30bf\u30f3<\/b>\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n \uff12\uff0eC6<\/b>\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001F4<\/b>\u3000\u3092\u62bc\u3057\u3001\u7d76\u5bfe\u53c2\u7167\uff08\u56fa\u5b9a\u30fb\u5e38\u306b\u53c2\u7167\u3059\u308b\u3088\u3046\uff09\u306b\u3057\u307e\u3059\u3002<\/p>\n \uff13\uff0e\u7d9a\u3044\u3066\u3001\u300c\uff1aC6\u300d<\/b><\/span>\u3068\u5165\u529b\u3057\u3001Enter<\/b>\u3000\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n \u3044\u304b\u304c\u3067\u3057\u305f\u304b\uff1f<\/p>\n Excel\u306e\u7d76\u5bfe\u53c2\u7167\uff08\u30bb\u30eb\u56fa\u5b9a\uff09\u3068\u76f8\u5bfe\u53c2\u7167\uff08\u4e00\u3064\u305a\u3064\u53c2\u7167\u3059\u308b\u30bb\u30eb\u3092\u79fb\u52d5\uff09\u3092\u4f7f\u3046\u3068 \u305c\u3072\u3001\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\u3002<\/p>\n \u307f\u306a\u3055\u307e\u3001\u3053\u3093\u306b\u3061\u306f\uff01 \u30e2\u30ab\u3067\u3059\u3002 \u304a\u5143\u6c17\u3067\u3059\u304b\uff1f \u6885\u96e8\u660e\u3051\u3001\u897f\u306e\u307b\u3046\u304b\u3089\u3057\u3066\u6765\u3066\u3044\u307e\u3059\u306d\u3002 \u590f\u672c\u756a\u3067\u3059\uff01 \u3044\u308d\u3093\u306a\u3053\u3068\u304c\u8d77\u3053\u3063\u3066\u3044\u308b\u306e\u3067\u3001 \u5fc3\u304c\u75db\u307f\u307e\u3059\u3002\u3068\u304f\u306b\u30de\u30ec\u30fc\u30b7\u30a2\u822a\u7a7a\u6a5f\u306e\u4e8b\u6545\u3002 \u3042\u3063\u3066\u306f\u306a\u3089\u306a\u3044\u3053\u3068\u3060\u3001\u3068\u6700\u521d\u306f […]<\/p>\n","protected":false},"author":2,"featured_media":2533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-370","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/comments?post=370"}],"version-history":[{"count":2,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/370\/revisions"}],"predecessor-version":[{"id":2993,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/370\/revisions\/2993"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media\/2533"}],"wp:attachment":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media?parent=370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/categories?post=370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/tags?post=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/a><\/span><\/p>\n<\/a><\/span><\/p>\n<\/a><\/span><\/p>\n<\/a><\/span><\/p>\n
\n<\/a><\/span>\uff15\uff0e\u7d2f\u8a08\u304c\u6c42\u3081\u3089\u308c\u307e\u3057\u305f\u3002
\n<\/a><\/span>\uff16\uff0e\u6700\u4e0b\u884c\u306e\u30bb\u30eb\u306e\u5f0f\u3092\u898b\u3066\u307f\u308b\u3068\u3001=SUM($C$6:C21\uff09<\/b><\/span>\u203b\u9752\u67a0\u306e\u7bc4\u56f2
\n\u3068\u306a\u3063\u3066\u3044\u3066\u3001C6\u3092\u7d76\u5bfe\u53c2\u7167\uff08F4\uff09\u3060\u3051\u56fa\u5b9a\u3057\u3066\u308b\u306e\u3067\u3001\u7bc4\u56f2\u304c\u4e00\u3064\u305a\u3064\u5e83\u304c\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002
\n<\/a><\/span><\/p>\n
\n\u3059\u3054\u304f\u4fbf\u5229\u3067\u3059\u3088\u306d\u3002<\/p>\n\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606 \u524d\u306e\u8a18\u4e8b<\/a><\/b> \u2606\u2606<\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"