{"id":5466,"date":"2024-11-11T10:56:36","date_gmt":"2024-11-11T10:56:36","guid":{"rendered":"https:\/\/howtogeek.blog\/ko\/?p=5466"},"modified":"2024-11-11T10:56:36","modified_gmt":"2024-11-11T10:56:36","slug":"a-comprehensive-guide-on-utilizing-the-array-formula-in-google-sheets","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/ko\/a-comprehensive-guide-on-utilizing-the-array-formula-in-google-sheets\/","title":{"rendered":"Google \uc2dc\ud2b8\uc5d0\uc11c \ubc30\uc5f4 \uc218\uc2dd\uc744 \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \ud3ec\uad04\uc801\uc778 \uac00\uc774\ub4dc"},"content":{"rendered":"<h1>Google \uc2dc\ud2b8\uc5d0\uc11c ARRAYFORMULA\uc758 \ud798 \ud65c\uc6a9\ud558\uae30<\/h1>\n<p><strong>Google \uc2dc\ud2b8\uc758 ARRAYFORMULA<\/strong> \ud568\uc218 \ub294 \uac8c\uc784 \uccb4\uc778\uc800\ub85c, \uc0ac\uc6a9\uc790\uac00 \ub2e8\uc77c \uc218\uc2dd\uc744 \uc804\uccb4 \uc5f4\uc5d0 \uc190\uc27d\uac8c \uc801\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. \uc774 \uac15\ub825\ud55c \uae30\ub2a5\uc740 \uc9c0\ub8e8\ud55c \ubcf5\uc0ac-\ubd99\uc5ec\ub123\uae30\ub098 \uc5ec\ub7ec \uc140\uc5d0 \uac78\uccd0 \uc218\uc2dd\uc744 \ub04c\uc5b4\ub2e4 \ub193\uc744 \ud544\uc694\uc131\uc744 \uc5c6\uc560 \ub370\uc774\ud130 \uc870\uc791\uc744 \ub354 \ube60\ub974\uace0 \ud6a8\uc728\uc801\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc90d\ub2c8\ub2e4. \ud569\uacc4\ub97c \uacc4\uc0b0\ud558\ub4e0 \ubcf5\uc7a1\ud55c \uc5f0\uc0b0\uc744 \uc218\ud589\ud558\ub4e0 ARRAYFORMULA\ub294 <strong>IF<\/strong> , <strong>SUM<\/strong> , <strong>SUMIF\ub97c<\/strong> \ud3ec\ud568\ud55c \ub2e4\ub978 \ud568\uc218\uc640 \uacb0\ud569\ud558\uc5ec \uacc4\uc0b0\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uc790\ub3d9\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"using-the-array-formula\">ARRAYFORMULA \uc0ac\uc6a9 \ubc29\ubc95<\/h2>\n<p>\uc774 \ud568\uc218\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud55c \uad6c\ubb38\uc740 \uc774\uba70 <code>ARRAYFORMULA(array_formula)<\/code>, \ub2e8\uc77c \uc778\uc218\uac00 \ud544\uc694\ud560 \ub54c \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 \ub3d9\uc77c\ud55c \ud06c\uae30, \ud45c\ud604\uc2dd \ub610\ub294 \uc9c0\uc815\ub41c \uc140 \ubc94\uc704\uc758 \uc5ec\ub7ec \ubc30\uc5f4\uacfc \ud568\uaed8 \uc791\ub3d9\ud558\ub294 \ud568\uc218\uac00 \ud3ec\ud568\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. ARRAYFORMULA \ud568\uc218\ub294 \uc218\uc2dd\uc744 \ucc98\uc74c \uc785\ub825\ud55c \ud6c4 \ub610\ub294 \uc218\uc2dd \uc0dd\uc131 \ud504\ub85c\uc138\uc2a4\uc758 \uc77c\ubd80\ub85c \ub3c4\uc785\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\uc608: \ucd1d \ub9e4\ucd9c \uacc4\uc0b0<\/h3>\n<p><em>\ud310\ub9e4\ub7c9<\/em> \uc5d0 <em>\ub2e8\uac00\ub97c<\/em> \uacf1\ud558\uc5ec \ucd1d \ub9e4\ucd9c\uc744 \uacc4\uc0b0\ud574\uc57c \ud558\ub294 \uc0c1\ud669\uc744 \uc0dd\uac01\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4 .<em><\/em><\/p>\n<ol>\n<li>\ub2e4\uc74c \uacf5\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc138\uc694: <code>=ARRAYFORMULA(B2:B6*C2:C6)<\/code>B2~B6 \ubc94\uc704\uc640 C2~C6 \ubc94\uc704\ub97c \uacf1\ud569\ub2c8\ub2e4.<\/li>\n<li>Enter \ud0a4\ub97c \ub204\ub974\uba74 \ud569\uacc4 \uc5f4\uc5d0 \ud574\ub2f9 \uac12\uc758 \uacf1\uc774 \uc790\ub3d9\uc73c\ub85c \ucc44\uc6cc\uc9d1\ub2c8\ub2e4.<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt=\"\ucd1d \ub9e4\ucd9c \uacc4\uc0b0\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/11\/image-190-1.webp\" title=\"\ucd1d \ub9e4\ucd9c \uacc4\uc0b0\" width=\"831\"\/><\/figure>\n<h2 id=\"using-the-if-function\">ARRAYFORMULA\ub97c IF \ud568\uc218\uc640 \ud1b5\ud569<\/h2>\n<p>ARRAYFORMULA\ub294 <strong>IF<\/strong> \ud568\uc218\uc640 \uc6d0\ud65c\ud558\uac8c \uc791\ub3d9\ud558\uc5ec \ubc94\uc704 \uc804\ubc18\uc5d0 \uac78\uccd0 \uc870\uac74\uc744 \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\uc608: \ubcf4\ub108\uc2a4 \uc790\uaca9 \uacb0\uc815<\/h3>\n<p>\uc608\ub97c \ub4e4\uc5b4, 20,000\uc744 \ucd08\uacfc\ud558\ub294 \uae08\uc561\uc5d0 \ub300\ud574 &#8220;\ubcf4\ub108\uc2a4&#8221;\ub97c \ud45c\uc2dc\ud558\uace0 \uadf8\ub807\uc9c0 \uc54a\uc740 \uacbd\uc6b0 &#8220;\ubcf4\ub108\uc2a4 \uc5c6\uc74c&#8221;\uc744 \ud45c\uc2dc\ud558\ub824\ub294 \uacbd\uc6b0 \ub2e4\uc74c\uc744 \uad6c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\ub2e4\uc74c \uacf5\uc2dd\uc744 \uc785\ub825\ud558\uc138\uc694: <code>=ARRAYFORMULA(IF(B2:B6&gt;20000, \"Bonus\", \"No Bonus\"))<\/code>\uc9c0\uc815\ub41c \ubc94\uc704 \uc804\uccb4\ub97c \ud3c9\uac00\ud569\ub2c8\ub2e4.<\/li>\n<li>Enter \ud0a4\ub97c \ub204\ub974\uba74 \uacb0\uacfc\uac00 \ubcf4\ub108\uc2a4 \uc139\uc158\uc5d0 \uc801\uc808\ud788 \ubc18\uc601\ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt=\"\ubcf4\ub108\uc2a4 \uacc4\uc0b0 \uc608\uc2dc\" class=\"wp-image\" decoding=\"async\" height=\"485\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/11\/image-193-1.webp\" title=\"\ubcf4\ub108\uc2a4 \uacc4\uc0b0 \uc608\uc2dc\" width=\"863\"\/><\/figure>\n<h2 id=\"using-the-sumif-function\">SUMIF\uc640 \ud568\uaed8 ARRAYFORMULA \uc0ac\uc6a9<\/h2>\n<p>ARRAYFORMULA\ub294 <strong>SUMIF<\/strong> \ud568\uc218\uc640 \ud6a8\uacfc\uc801\uc73c\ub85c \uacb0\ud569\ud558\uc5ec \ub354\uc6b1 \uace0\uae09 \ub370\uc774\ud130 \ubd84\uc11d\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\uc608: \uc8fc\ubb38\ub41c \ubb38\uad6c\ub958 \ud488\ubaa9 \uacc4\uc0b0<\/h3>\n<p>\uc8fc\ubb38\ud55c \ubd84\ub958\ub41c \ubb38\uad6c\ub958 \ud488\ubaa9\uc758 \uc218\ub7c9\uc744 \uacc4\uc0b0\ud558\ub824\uba74 \ub2e4\uc74c \ub2e8\uacc4\ub97c \ub530\ub974\uc138\uc694.<\/p>\n<ol>\n<li>\ub2e4\uc74c \uacf5\uc2dd\uc73c\ub85c \uc2dc\uc791\ud558\uc138\uc694: <code>SUMIF(F2:F, H2:H, D2:D)<\/code>.<\/li>\n<li>Enter \ud0a4\ub97c \ub20c\ub7ec \uc140 I2\uc5d0 32\uac00 \uc785\ub825\ub41c \uac83\uacfc \uac19\uc774 \ucd1d\uacc4\ub97c \ud655\uc778\ud558\uc138\uc694.<\/li>\n<li>\ubaa8\ub4e0 \uce74\ud14c\uace0\ub9ac\ub85c \ud655\uc7a5\ud558\ub824\uba74 \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uc138\uc694 <code>=ARRAYFORMULA(SUMIF(F2:F, H2:H, D2:D))<\/code>.<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt=\"ARRAYFORMULA\uc640 \ud568\uaed8 SUMIF \uc0ac\uc6a9\" 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\uc640 \ud568\uaed8 SUMIF \uc0ac\uc6a9\" width=\"1038\"\/><\/figure>\n<h2 id=\"things-to-know\">\uc911\uc694\ud55c \uace0\ub824 \uc0ac\ud56d<\/h2>\n<ul>\n<li>\uc624\ub958\ub97c \ud53c\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub41c \ubaa8\ub4e0 \ubc30\uc5f4\uc758 \ud06c\uae30\uac00 \ub3d9\uc77c\ud55c\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<li>\ub2e8\ucd95\ud0a4\ub97c \ud65c\uc6a9\ud558\uba74 <code>Ctrl + Shift + Enter<\/code>&#8216;ARRAYFORMULA&#8217;\ub97c \uc790\ub3d9\uc73c\ub85c \uc218\uc2dd\uc5d0 \uc0bd\uc785\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>ARRAYFORMULA\uc5d0\uc11c \uac1c\ubcc4 \uc140\uc5d0 \ub300\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc740 \uc9c0\uc815\ub41c \ubc94\uc704 \ub0b4\uc758 \ubaa8\ub4e0 \uc140\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4.<\/li>\n<li>ARRAYFORMULA\ub294 \ub2e4\uc591\ud55c \ud568\uc218\uc640 \ud568\uaed8 \uc791\ub3d9\ud558\uc9c0\ub9cc <strong>\ucffc\ub9ac<\/strong> \ub098 <strong>\ud544\ud130<\/strong> \ud568\uc218\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>Google \uc2dc\ud2b8\uc5d0\uc11c ARRAYFORMULA\ub97c \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc9c0\uce68\uc740 <a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-the-array-formula-in-google-sheets\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">\uc774 \uc18c\uc2a4\ub97c<\/a> \ubc29\ubb38\ud558\uc138\uc694 .<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google \uc2dc\ud2b8\uc5d0\uc11c ARRAYFORMULA\uc758 \ud798 \ud65c\uc6a9\ud558\uae30 Google \uc2dc\ud2b8\uc758 ARRAYFORMULA \ud568\uc218 \ub294 \uac8c\uc784 \uccb4\uc778\uc800\ub85c, \uc0ac\uc6a9\uc790\uac00 \ub2e8\uc77c \uc218\uc2dd\uc744 \uc804\uccb4 \uc5f4\uc5d0 \uc190\uc27d\uac8c \uc801\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. \uc774 \uac15\ub825\ud55c \uae30\ub2a5\uc740 \uc9c0\ub8e8\ud55c \ubcf5\uc0ac-\ubd99\uc5ec\ub123\uae30\ub098 \uc5ec\ub7ec \uc140\uc5d0 \uac78\uccd0 \uc218\uc2dd\uc744 \ub04c\uc5b4\ub2e4 \ub193\uc744 \ud544\uc694\uc131\uc744 \uc5c6\uc560 \ub370\uc774\ud130 \uc870\uc791\uc744 \ub354 \ube60\ub974\uace0 \ud6a8\uc728\uc801\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc90d\ub2c8\ub2e4. \ud569\uacc4\ub97c \uacc4\uc0b0\ud558\ub4e0 \ubcf5\uc7a1\ud55c \uc5f0\uc0b0\uc744 \uc218\ud589\ud558\ub4e0 ARRAYFORMULA\ub294 IF , SUM , SUMIF\ub97c \ud3ec\ud568\ud55c \ub2e4\ub978 \ud568\uc218\uc640 [&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":[809,130,176],"class_list":["post-5466","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\/ko\/wp-json\/wp\/v2\/posts\/5466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/comments?post=5466"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/5466\/revisions"}],"predecessor-version":[{"id":5467,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/5466\/revisions\/5467"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/media?parent=5466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/categories?post=5466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/tags?post=5466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}