{"id":5481,"date":"2024-11-11T10:56:16","date_gmt":"2024-11-11T10:56:16","guid":{"rendered":"https:\/\/howtogeek.blog\/ja\/?p=5481"},"modified":"2024-11-11T10:56:16","modified_gmt":"2024-11-11T10:56:16","slug":"a-comprehensive-guide-on-utilizing-the-array-formula-in-google-sheets","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/ja\/a-comprehensive-guide-on-utilizing-the-array-formula-in-google-sheets\/","title":{"rendered":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u914d\u5217\u6570\u5f0f\u3092\u6d3b\u7528\u3059\u308b\u305f\u3081\u306e\u5305\u62ec\u7684\u306a\u30ac\u30a4\u30c9"},"content":{"rendered":"<h1>Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067 ARRAYFORMULA \u306e\u30d1\u30ef\u30fc\u3092\u89e3\u304d\u653e\u3064<\/h1>\n<p>Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eARRAYFORMULA\u95a2\u6570\u306f\u753b\u671f\u7684\u306a\u6a5f\u80fd\u3067\u3001\u30e6\u30fc\u30b6\u30fc\u306f 1 \u3064\u306e\u6570\u5f0f\u3092\u5217\u5168\u4f53\u306b\u7c21\u5358\u306b\u9069\u7528\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u5f37\u529b\u306a\u6a5f\u80fd\u306b\u3088\u308a\u3001\u9762\u5012\u306a\u30b3\u30d4\u30fc \u30a2\u30f3\u30c9 \u30da\u30fc\u30b9\u30c8\u3084\u8907\u6570\u306e\u30bb\u30eb\u9593\u3067\u306e\u6570\u5f0f\u30c9\u30e9\u30c3\u30b0\u304c\u4e0d\u8981\u306b\u306a\u308a\u3001\u30c7\u30fc\u30bf\u64cd\u4f5c\u304c\u3088\u308a\u8fc5\u901f\u304b\u3064\u52b9\u7387\u7684\u306b\u306a\u308a\u307e\u3059\u3002\u5408\u8a08\u3092\u8a08\u7b97\u3059\u308b\u5834\u5408\u3067\u3082\u3001\u8907\u96d1\u306a\u64cd\u4f5c\u3092\u5b9f\u884c\u3059\u308b\u5834\u5408\u3067\u3082\u3001ARRAYFORMULA \u3092 IF \u3001SUM \u3001SUMIF \u306a\u3069\u306e\u4ed6\u306e\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u3066<strong>\u3001<\/strong><strong>\u8a08\u7b97<\/strong>\u3092<strong>\u52b9\u679c<\/strong>\u7684<strong>\u306b<\/strong>\u81ea\u52d5\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n<h2 id=\"using-the-array-formula\">ARRAYFORMULA\u306e\u4f7f\u3044\u65b9<\/h2>\n<p>\u3053\u306e\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u306e\u69cb\u6587\u306f \u3067<code>ARRAYFORMULA(array_formula)<\/code>\u3001\u5358\u4e00\u306e\u5f15\u6570\u304c\u5fc5\u8981\u306a\u5834\u5408\u306b\u9069\u7528\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u306b\u306f\u3001\u540c\u3058\u30b5\u30a4\u30ba\u306e\u8907\u6570\u306e\u914d\u5217\u3001\u5f0f\u3001\u307e\u305f\u306f\u6307\u5b9a\u3055\u308c\u305f\u30bb\u30eb\u7bc4\u56f2\u3067\u6a5f\u80fd\u3059\u308b\u95a2\u6570\u304c\u542b\u307e\u308c\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002ARRAYFORMULA \u95a2\u6570\u306f\u3001\u6570\u5f0f\u3092\u6700\u521d\u306b\u5165\u529b\u3057\u305f\u5f8c\u3001\u307e\u305f\u306f\u6570\u5f0f\u4f5c\u6210\u30d7\u30ed\u30bb\u30b9\u306e\u4e00\u90e8\u3068\u3057\u3066\u5c0e\u5165\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3>\u4f8b: \u7dcf\u58f2\u4e0a\u306e\u8a08\u7b97<\/h3>\n<p><em>\u8ca9\u58f2\u6570\u91cf<\/em>\u3068<em>\u5358\u4fa1<\/em>\u3092\u639b\u3051\u3066\u7dcf\u58f2\u4e0a\u3092\u8a08\u7b97\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u30b7\u30ca\u30ea\u30aa\u3092\u8003\u3048\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<ol>\n<li>\u6b21\u306e\u5f0f\u3092\u4f7f\u7528\u3057\u3066\u3001<code>=ARRAYFORMULA(B2:B6*C2:C6)<\/code>\u7bc4\u56f2 B2 \uff5e B6 \u3068 C2 \uff5e C6 \u3092\u4e57\u7b97\u3057\u307e\u3059\u3002<\/li>\n<li>Enter \u30ad\u30fc\u3092\u62bc\u3059\u3068\u3001\u5bfe\u5fdc\u3059\u308b\u5024\u306e\u7a4d\u304c\u5408\u8a08\u5217\u306b\u81ea\u52d5\u7684\u306b\u5165\u529b\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt=\"\u7dcf\u58f2\u4e0a\u8a08\u7b97\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/11\/image-190-1.webp\" title=\"\u7dcf\u58f2\u4e0a\u8a08\u7b97\" width=\"831\"\/><\/figure>\n<h2 id=\"using-the-if-function\">ARRAYFORMULA \u3068 IF \u95a2\u6570\u306e\u7d71\u5408<\/h2>\n<p>ARRAYFORMULA \u306f<strong>IF<\/strong>\u95a2\u6570\u3068\u30b7\u30fc\u30e0\u30ec\u30b9\u306b\u9023\u643a\u3057\u3001\u7bc4\u56f2\u5168\u4f53\u306b\u308f\u305f\u3063\u3066\u6761\u4ef6\u3092\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3>\u4f8b: \u30dc\u30fc\u30ca\u30b9\u306e\u53d7\u7d66\u8cc7\u683c\u306e\u6c7a\u5b9a<\/h3>\n<p>\u305f\u3068\u3048\u3070\u300120,000 \u3092\u8d85\u3048\u308b\u91d1\u984d\u306b\u306f\u300c\u30dc\u30fc\u30ca\u30b9\u3042\u308a\u300d\u3068\u8868\u793a\u3057\u3001\u305d\u308c\u4ee5\u5916\u306e\u5834\u5408\u306f\u300c\u30dc\u30fc\u30ca\u30b9\u306a\u3057\u300d\u3068\u8868\u793a\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u6b21\u306e\u3088\u3046\u306b\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002<\/p>\n<ol>\n<li><code>=ARRAYFORMULA(IF(B2:B6&gt;20000, \"Bonus\", \"No Bonus\"))<\/code>\u6307\u5b9a\u3055\u308c\u305f\u7bc4\u56f2\u5168\u4f53\u3092\u8a55\u4fa1\u3059\u308b\u305f\u3081\u306b\u3001\u6b21\u306e\u6570\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/li>\n<li>Enter \u30ad\u30fc\u3092\u62bc\u3059\u3068\u3001\u7d50\u679c\u304c\u30dc\u30fc\u30ca\u30b9 \u30bb\u30af\u30b7\u30e7\u30f3\u306b\u53cd\u6620\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt=\"\u30dc\u30fc\u30ca\u30b9\u8a08\u7b97\u4f8b\" class=\"wp-image\" decoding=\"async\" height=\"485\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/11\/image-193-1.webp\" title=\"\u30dc\u30fc\u30ca\u30b9\u8a08\u7b97\u4f8b\" width=\"863\"\/><\/figure>\n<h2 id=\"using-the-sumif-function\">SUMIF \u3067 ARRAYFORMULA \u3092\u4f7f\u7528\u3059\u308b<\/h2>\n<p>ARRAYFORMULA \u3092<strong>SUMIF<\/strong>\u95a2\u6570\u3068\u52b9\u679c\u7684\u306b\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u9ad8\u5ea6\u306a\u30c7\u30fc\u30bf\u5206\u6790\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<h3>\u4f8b: \u6ce8\u6587\u3055\u308c\u305f\u6587\u623f\u5177\u306e\u6570\u3092\u6570\u3048\u308b<\/h3>\n<p>\u5206\u985e\u3055\u308c\u305f\u6587\u623f\u5177\u306e\u6ce8\u6587\u6570\u3092\u8a08\u7b97\u3059\u308b\u5834\u5408\u306f\u3001\u6b21\u306e\u624b\u9806\u306b\u5f93\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<ol>\n<li>\u6b21\u306e\u5f0f\u304b\u3089\u59cb\u3081\u307e\u3059: <code>SUMIF(F2:F, H2:H, D2:D)<\/code>\u3002<\/li>\n<li>Enter \u30ad\u30fc\u3092\u62bc\u3059\u3068\u3001\u30bb\u30eb I2 \u306e 32 \u306a\u3069\u306e\u5408\u8a08\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n<li>\u3053\u308c\u3092\u3059\u3079\u3066\u306e\u30ab\u30c6\u30b4\u30ea\u306b\u62e1\u5f35\u3059\u308b\u306b\u306f\u3001\u6b21\u3092\u4f7f\u7528\u3057\u307e\u3059<code>=ARRAYFORMULA(SUMIF(F2:F, H2:H, D2:D))<\/code>\u3002<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt=\"ARRAYFORMULA \u3067 SUMIF \u3092\u4f7f\u7528\u3059\u308b\" class=\"wp-image\" decoding=\"async\" height=\"584\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/11\/image-199-1.webp\" title=\"ARRAYFORMULA \u3067 SUMIF \u3092\u4f7f\u7528\u3059\u308b\" width=\"1038\"\/><\/figure>\n<h2 id=\"things-to-know\">\u91cd\u8981\u306a\u8003\u616e\u4e8b\u9805<\/h2>\n<ul>\n<li>\u30a8\u30e9\u30fc\u3092\u56de\u907f\u3059\u308b\u305f\u3081\u306b\u3001\u4f7f\u7528\u3059\u308b\u3059\u3079\u3066\u306e\u914d\u5217\u304c\u540c\u3058\u30b5\u30a4\u30ba\u3067\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<li>\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3092\u5229\u7528\u3057\u3066<code>Ctrl + Shift + Enter<\/code>\u3001\u6570\u5f0f\u306b\u300cARRAYFORMULA\u300d\u3092\u81ea\u52d5\u7684\u306b\u633f\u5165\u3067\u304d\u307e\u3059\u3002<\/li>\n<li>ARRAYFORMULA \u5185\u306e\u500b\u3005\u306e\u30bb\u30eb\u306b\u52a0\u3048\u3089\u308c\u305f\u5909\u66f4\u306f\u3001\u6307\u5b9a\u3055\u308c\u305f\u7bc4\u56f2\u5185\u306e\u3059\u3079\u3066\u306e\u30bb\u30eb\u306b\u5f71\u97ff\u3057\u307e\u3059\u3002<\/li>\n<li>ARRAYFORMULA \u306f\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\u3067\u52d5\u4f5c\u3057\u307e\u3059\u304c\u3001<strong>\u30af\u30a8\u30ea\u95a2\u6570<\/strong>\u3084<strong>\u30d5\u30a3\u30eb\u30bf\u30fc<\/strong>\u95a2\u6570\u306f\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u306a\u3044\u3053\u3068\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<\/ul>\n<p>Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067 ARRAYFORMULA \u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u306e\u8a73\u7d30\u306a\u30ac\u30a4\u30c0\u30f3\u30b9\u306b\u3064\u3044\u3066\u306f\u3001<a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-the-array-formula-in-google-sheets\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">\u3053\u3061\u3089\u306e\u30bd\u30fc\u30b9<\/a>\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067 ARRAYFORMULA \u306e\u30d1\u30ef\u30fc\u3092\u89e3\u304d\u653e\u3064 Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eARRAYFORMULA\u95a2\u6570\u306f\u753b\u671f\u7684\u306a\u6a5f\u80fd\u3067\u3001\u30e6\u30fc\u30b6\u30fc\u306f 1 \u3064\u306e\u6570\u5f0f\u3092\u5217\u5168\u4f53\u306b\u7c21\u5358\u306b\u9069\u7528\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u5f37\u529b\u306a\u6a5f\u80fd\u306b\u3088\u308a\u3001\u9762\u5012\u306a\u30b3\u30d4\u30fc \u30a2\u30f3\u30c9 \u30da\u30fc\u30b9\u30c8\u3084\u8907\u6570\u306e\u30bb\u30eb\u9593\u3067\u306e\u6570\u5f0f\u30c9\u30e9\u30c3\u30b0\u304c\u4e0d\u8981\u306b\u306a\u308a\u3001\u30c7\u30fc\u30bf\u64cd\u4f5c\u304c\u3088\u308a\u8fc5\u901f\u304b\u3064\u52b9\u7387\u7684\u306b\u306a\u308a\u307e\u3059\u3002\u5408\u8a08\u3092\u8a08\u7b97\u3059\u308b\u5834\u5408\u3067\u3082\u3001\u8907\u96d1\u306a\u64cd\u4f5c\u3092\u5b9f\u884c\u3059\u308b\u5834\u5408\u3067\u3082\u3001ARRAYFORMULA \u3092 IF \u3001SUM \u3001SUMIF \u306a\u3069\u306e\u4ed6\u306e\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u3066\u3001\u8a08\u7b97\u3092\u52b9\u679c\u7684\u306b\u81ea\u52d5\u5316\u3067\u304d\u307e\u3059\u3002 ARRAYFORMULA\u306e\u4f7f\u3044\u65b9 \u3053\u306e\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u306e\u69cb\u6587\u306f \u3067ARRAYFORMULA(array_formula)\u3001\u5358\u4e00\u306e\u5f15\u6570\u304c\u5fc5\u8981\u306a\u5834\u5408\u306b\u9069\u7528\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u306b\u306f\u3001\u540c\u3058\u30b5\u30a4\u30ba\u306e\u8907\u6570\u306e\u914d\u5217\u3001\u5f0f\u3001\u307e\u305f\u306f\u6307\u5b9a\u3055\u308c\u305f\u30bb\u30eb\u7bc4\u56f2\u3067\u6a5f\u80fd\u3059\u308b\u95a2\u6570\u304c\u542b\u307e\u308c\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002ARRAYFORMULA \u95a2\u6570\u306f\u3001\u6570\u5f0f\u3092\u6700\u521d\u306b\u5165\u529b\u3057\u305f\u5f8c\u3001\u307e\u305f\u306f\u6570\u5f0f\u4f5c\u6210\u30d7\u30ed\u30bb\u30b9\u306e\u4e00\u90e8\u3068\u3057\u3066\u5c0e\u5165\u3067\u304d\u307e\u3059\u3002 \u4f8b: \u7dcf\u58f2\u4e0a\u306e\u8a08\u7b97 \u8ca9\u58f2\u6570\u91cf\u3068\u5358\u4fa1\u3092\u639b\u3051\u3066\u7dcf\u58f2\u4e0a\u3092\u8a08\u7b97\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u30b7\u30ca\u30ea\u30aa\u3092\u8003\u3048\u3066\u307f\u307e\u3057\u3087\u3046\u3002 \u6b21\u306e\u5f0f\u3092\u4f7f\u7528\u3057\u3066\u3001=ARRAYFORMULA(B2:B6*C2:C6)\u7bc4\u56f2 B2 \uff5e B6 \u3068 C2 \uff5e C6 \u3092\u4e57\u7b97\u3057\u307e\u3059\u3002 Enter \u30ad\u30fc\u3092\u62bc\u3059\u3068\u3001\u5bfe\u5fdc\u3059\u308b\u5024\u306e\u7a4d\u304c\u5408\u8a08\u5217\u306b\u81ea\u52d5\u7684\u306b\u5165\u529b\u3055\u308c\u307e\u3059\u3002 ARRAYFORMULA \u3068 IF \u95a2\u6570\u306e\u7d71\u5408 ARRAYFORMULA \u306fIF\u95a2\u6570\u3068\u30b7\u30fc\u30e0\u30ec\u30b9\u306b\u9023\u643a\u3057\u3001\u7bc4\u56f2\u5168\u4f53\u306b\u308f\u305f\u3063\u3066\u6761\u4ef6\u3092\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002 \u4f8b: \u30dc\u30fc\u30ca\u30b9\u306e\u53d7\u7d66\u8cc7\u683c\u306e\u6c7a\u5b9a \u305f\u3068\u3048\u3070\u300120,000 \u3092\u8d85\u3048\u308b\u91d1\u984d\u306b\u306f\u300c\u30dc\u30fc\u30ca\u30b9\u3042\u308a\u300d\u3068\u8868\u793a\u3057\u3001\u305d\u308c\u4ee5\u5916\u306e\u5834\u5408\u306f\u300c\u30dc\u30fc\u30ca\u30b9\u306a\u3057\u300d\u3068\u8868\u793a\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u6b21\u306e\u3088\u3046\u306b\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002 =ARRAYFORMULA(IF(B2:B6&gt;20000, &#8220;Bonus&#8221;, &#8220;No Bonus&#8221;))\u6307\u5b9a\u3055\u308c\u305f\u7bc4\u56f2\u5168\u4f53\u3092\u8a55\u4fa1\u3059\u308b\u305f\u3081\u306b\u3001\u6b21\u306e\u6570\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002 Enter \u30ad\u30fc\u3092\u62bc\u3059\u3068\u3001\u7d50\u679c\u304c\u30dc\u30fc\u30ca\u30b9 \u30bb\u30af\u30b7\u30e7\u30f3\u306b\u53cd\u6620\u3055\u308c\u307e\u3059\u3002 SUMIF \u3067 ARRAYFORMULA \u3092\u4f7f\u7528\u3059\u308b ARRAYFORMULA [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[807,127,174],"class_list":["post-5481","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-google-sheets","tag-microsoft","tag-web"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/posts\/5481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/comments?post=5481"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/posts\/5481\/revisions"}],"predecessor-version":[{"id":5482,"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/posts\/5481\/revisions\/5482"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/media?parent=5481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/categories?post=5481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/ja\/wp-json\/wp\/v2\/tags?post=5481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}