{"id":5976,"date":"2024-12-04T07:54:23","date_gmt":"2024-12-04T07:54:23","guid":{"rendered":"https:\/\/howtogeek.blog\/ko\/?p=5976"},"modified":"2024-12-04T07:54:23","modified_gmt":"2024-12-04T07:54:23","slug":"stepbystep-guide-to-creating-a-monthly-spending-tracker-in-google-sheets","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/ko\/stepbystep-guide-to-creating-a-monthly-spending-tracker-in-google-sheets\/","title":{"rendered":"Google \uc2dc\ud2b8\uc5d0\uc11c \uc6d4\ubcc4 \uc9c0\ucd9c \ucd94\uc801\uae30\ub97c \ub9cc\ub4dc\ub294 \ub2e8\uacc4\ubcc4 \uac00\uc774\ub4dc"},"content":{"rendered":"<p>\uc7ac\uc815\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\ub294 \uac83\uc740 \ud544\uc218\uc801\uc774\uc9c0\ub9cc, \ud2b9\ud788 \uc9c0\ucd9c\uc744 \ucd94\uc801\ud560 \ub54c \uc885\uc885 \uc555\ub3c4\uc801\uc73c\ub85c \ub290\uaef4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\ud589\ud788\ub3c4 <strong>Google \uc2dc\ud2b8<\/strong> \uc640 \uac19\uc740 \ub3c4\uad6c\ub294 \uc0ac\uc6a9\uc790 \uc9c0\uc815 \uc6d4\ubcc4 \uc9c0\ucd9c \ucd94\uc801\uae30\ub97c \ub9cc\ub4dc\ub294 \uc9c1\uad00\uc801\uc778 \ud50c\ub7ab\ud3fc\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. Google \uc2dc\ud2b8\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uae30\uc131 \ud15c\ud50c\ub9bf\uc744 \uc81c\uacf5\ud558\uc9c0\ub9cc, \ud544\uc694\uc5d0 \ub9de\ub294 \ucd94\uc801\uae30\ub97c \ub514\uc790\uc778\ud558\ub294 \uac83\uc740 \ub2ec\uc131 \uac00\ub2a5\ud558\uace0 \uac04\ub2e8\ud569\ub2c8\ub2e4.<\/p>\n<h2 class=\"wp-block-heading\" id=\"step-1-define-your-expense-tracker-structure\">1\ub2e8\uacc4: \ube44\uc6a9 \ucd94\uc801 \uad6c\uc870 \uc815\uc758<\/h2>\n<p>\uc9c0\ucd9c \ucd94\uc801\uae30\ub97c \ub9cc\ub4e4\uae30 \uc804\uc5d0 \ud3ec\ud568\ud558\ub824\ub294 \uad6c\uc131 \uc694\uc18c\ub97c \uace0\ub824\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc124\uc815\uc744 \uac04\uc18c\ud654\ud558\uba74 \uc9c0\ucd9c\uc744 \ub354 \uc798 \uc2dc\uac01\ud654\ud558\uace0 \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n<ul class=\"wp-block-list\">\n<li>Google \uc2dc\ud2b8 \uc6f9\ud398\uc774\uc9c0\uc5d0 \uc811\uc18d\ud558\uc5ec Google \uacc4\uc815\uc5d0 \ub85c\uadf8\uc778\ud588\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<li>\uc0c8 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \uc2dc\uc791\ud558\ub824\uba74 &#8216;\ube48 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8&#8217; \uc635\uc158\uc744 \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc0c8 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \ub9cc\ub4e4\uae30\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-768-1.webp\" title=\"\uc0c8 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \ub9cc\ub4e4\uae30\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uc0c8 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \uc67c\ucabd \ud558\ub2e8 \ubaa8\uc11c\ub9ac\uc5d0 \uc788\ub294 &#8216;+&#8217; \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \ub2e4\ub978 \uc2dc\ud2b8\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4. \ub450 \uac1c\uc758 \uc2dc\ud2b8\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \uccab \ubc88\uc9f8\ub294 \ube44\uc6a9\uc744 \uc785\ub825\ud558\ub294 \ub370 \uc0ac\uc6a9\ud558\uace0 \ub450 \ubc88\uc9f8\ub294 \ub370\uc774\ud130\ub97c \uc694\uc57d\ud558\uace0 \uc2dc\uac01\ud654\ud558\ub294 \ub370 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc0c8\ub85c\uc6b4 \uc2dc\ud2b8 \ucd94\uac00\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-769-1.webp\" title=\"\uc0c8\ub85c\uc6b4 \uc2dc\ud2b8 \ucd94\uac00\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uccab \ubc88\uc9f8 \uc2dc\ud2b8\uc5d0 \ub2e4\uc74c \uba38\ub9ac\uae00\uc774 \uc788\ub294 5\uac1c\uc758 \uc5f4\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.\n<ul class=\"wp-block-list\">\n<li><strong>\uc7a5\uc18c:<\/strong> \uad6c\ub9e4\ud55c \uc0c1\ud488\uc744 \ud310\ub9e4\ud558\ub294 \uc18c\ub9e4\uc810.<\/li>\n<li><strong>\uce74\ud14c\uace0\ub9ac:<\/strong> \uad6c\ub9e4\ud55c \ud488\ubaa9\uc758 \uc720\ud615.<\/li>\n<li><strong>\uae08\uc561:<\/strong> \uac01 \ud488\ubaa9\uc758 \ube44\uc6a9.<\/li>\n<li><strong>\ub0a0\uc9dc:<\/strong> \uad6c\ub9e4 \ub0a0\uc9dc.<\/li>\n<li><strong>\uc6d4:<\/strong> \uac70\ub798\uac00 \ubc1c\uc0dd\ud55c \uc6d4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ube44\uc6a9 \ucd94\uc801\uae30 \uc5f4 \uc81c\ubaa9\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-770-1.webp\" title=\"\ube44\uc6a9 \ucd94\uc801\uae30 \uc5f4 \uc81c\ubaa9\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-2-establish-a-category-menu\">2\ub2e8\uacc4: \uce74\ud14c\uace0\ub9ac \uba54\ub274 \uc124\uc815<\/h2>\n<p>\ub370\uc774\ud130 \uc785\ub825\uc744 \uac04\uc18c\ud654\ud558\ub824\uba74 \ube44\uc6a9 \ucd94\uc801\uae30 \ub0b4\uc5d0\uc11c \uac70\ub798\uc5d0 \ud2b9\uc815 \ubc94\uc8fc\ub97c \uc9c0\uc815\ud558\uc138\uc694.<\/p>\n<ul class=\"wp-block-list\">\n<li>&#8216;\uce74\ud14c\uace0\ub9ac&#8217; \uc5f4\uc744 \uc120\ud0dd\ud558\uace0, \uae30\uae30\uc5d0 \ub530\ub77c <code>Ctrl<\/code>\ub610\ub294 \ud0a4\ub97c \ub204\ub978 <code>CMD<\/code>\ucc44\ub85c \uc704\ucabd\uc5d0 \uc788\ub294 \uc0bd\uc785 \uba54\ub274\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274 \uc0bd\uc785\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-771-1.webp\" title=\"\ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274 \uc0bd\uc785\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uc635\uc158\uc5d0\uc11c &#8216;\ub4dc\ub86d\ub2e4\uc6b4&#8217;\uc744 \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ub4dc\ub86d\ub2e4\uc6b4 \ub9cc\ub4e4\uae30\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-772-1.webp\" title=\"\ub4dc\ub86d\ub2e4\uc6b4 \ub9cc\ub4e4\uae30\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uc0ac\uc774\ub4dc\ubc14\uac00 \uc5f4\ub9ac\uba74 \ub2e4\uc591\ud55c \uce74\ud14c\uace0\ub9ac\ub97c \ucd94\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub354 \ub9ce\uc740 \uce74\ud14c\uace0\ub9ac\ub97c \ud3ec\ud568\ud558\ub824\uba74 &#8216;\ub2e4\ub978 \ud56d\ubaa9 \ucd94\uac00&#8217;\ub97c \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ub4dc\ub86d\ub2e4\uc6b4\uc5d0 \uce74\ud14c\uace0\ub9ac \ucd94\uac00\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-773-1.webp\" title=\"\ub4dc\ub86d\ub2e4\uc6b4\uc5d0 \uce74\ud14c\uace0\ub9ac \ucd94\uac00\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uc606\uc5d0 \uc788\ub294 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\ub97c \ud074\ub9ad\ud558\uc5ec \ubc94\uc8fc\uc5d0 \uc0c9\uc0c1 \ucf54\ub4dc\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc644\ub8cc\ub418\uba74 &#8216;\uc644\ub8cc&#8217;\ub97c \ud074\ub9ad\ud558\uc5ec \uc120\ud0dd \uc0ac\ud56d\uc744 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ub4dc\ub86d\ub2e4\uc6b4 \uce74\ud14c\uace0\ub9ac \ub9c8\ubb34\ub9ac\ud558\uae30\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-774-1.webp\" title=\"\ub4dc\ub86d\ub2e4\uc6b4 \uce74\ud14c\uace0\ub9ac \ub9c8\ubb34\ub9ac\ud558\uae30\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-3-format-your-spending-tracker\">3\ub2e8\uacc4: \uc9c0\ucd9c \ucd94\uc801\uae30 \ud3ec\ub9f7\ud558\uae30<\/h2>\n<p>\uba85\ud655\uc131\uacfc \uc77c\uad00\uc131\uc744 \uc720\uc9c0\ud558\ub824\uba74 \uc6d4\ubcc4 \uc9c0\ucd9c \ucd94\uc801\uc744 \uc62c\ubc14\ub978 \ud615\uc2dd\uc73c\ub85c \uc791\uc131\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n<ul class=\"wp-block-list\">\n<li>&#8216;\ub0a0\uc9dc&#8217; \uc5f4\uc744 \ud3b8\uc9d1\ud558\ub824\uba74 \uc5f4 \uba38\ub9ac\uae00\uc744 \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ub0a0\uc9dc \uc5f4 \uc120\ud0dd\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-775-1.webp\" title=\"\ub0a0\uc9dc \uc5f4 \uc120\ud0dd\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\ub3c4\uad6c \ubaa8\uc74c\uc5d0\uc11c &#8216;123&#8217; \uae30\ud638\ub85c \uc2dd\ubcc4\ub418\ub294 &#8216;\ucd94\uac00 \ud615\uc2dd&#8217; \uc635\uc158\uc744 \ucc3e\uc73c\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc11c\uc2dd \uc635\uc158\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-776-1.webp\" title=\"\uc11c\uc2dd \uc635\uc158\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uc5d0\uc11c &#8216;\ub0a0\uc9dc&#8217;\ub97c \uc120\ud0dd\ud558\uac70\ub098 &#8216;\uc11c\uc2dd&#8217; \uba54\ub274\ub85c \uc774\ub3d9\ud558\uc5ec &#8216;\uc22b\uc790&#8217;\ub97c \uc120\ud0dd\ud55c \ub2e4\uc74c &#8216;\ub0a0\uc9dc&#8217;\ub97c \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ub0a0\uc9dc \ud615\uc2dd \uc120\ud0dd\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-777-1.webp\" title=\"\ub0a0\uc9dc \ud615\uc2dd \uc120\ud0dd\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uad6c\ub9e4\uc77c\ub85c\ubd80\ud130 \uc6d4\uc744 \ud45c\uc2dc\ud558\ub824\uba74 TEXT \ud568\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. &#8216;\uc6d4&#8217; \uc5f4\uc758 \uccab \ubc88\uc9f8 \uc140\uc744 \ud074\ub9ad\ud558\uace0, \ub97c \uc785\ub825\ud558\uace0 , \ub0a0\uc9dc\ub97c \ud3ec\ud568\ud558\ub294 \uc140\ub85c <code>=TEXT(cell_reference,\"mmm\")<\/code>\ubc14\uafc9\ub2c8\ub2e4 .<code>cell_reference<\/code><\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc6d4 \ud45c\uc2dc\ub97c \uc704\ud55c TEXT \ud568\uc218\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-779-1.webp\" title=\"\uc6d4 \ud45c\uc2dc\ub97c \uc704\ud55c TEXT \ud568\uc218\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\ub2e4\ub978 \uc5f4\uc744 \ucc44\uc6b4 \ud6c4 \uc6d4 \uc5f4 \uc140\uc758 \ubaa8\uc11c\ub9ac\uc5d0 \uc788\ub294 \ucc44\uc6b0\uae30 \ud578\ub4e4\uc744 \ud074\ub9ad\ud558\uc5ec \ub04c\uc5b4\uc11c \ub2e4\ub978 \uc140\uc744 \uc790\ub3d9\uc73c\ub85c \ucc44\uc6c1\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc6d4 \uc5f4 \uc790\ub3d9 \ucc44\uc6b0\uae30\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-29-1.webp\" title=\"\uc6d4 \uc5f4 \uc790\ub3d9 \ucc44\uc6b0\uae30\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\ud1b5\ud654 \uc11c\uc2dd\uc744 \uc9c0\uc815\ud558\ub824\uba74 \uae08\uc561 \uc5f4 \uc81c\ubaa9\uc744 \uc120\ud0dd\ud55c \ub2e4\uc74c \ub3c4\uad6c \ubaa8\uc74c\uc5d0\uc11c <code>$<\/code>\ub610\ub294 <code>\u20ac<\/code>\uc544\uc774\ucf58\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4. \uc989\uc2dc \ud45c\uc2dc\ub418\uc9c0 \uc54a\uc73c\uba74 &#8216;\ucd94\uac00 \uc11c\uc2dd&#8217; \uc635\uc158\uc774 \ud544\uc694\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ud1b5\ud654 \ud615\uc2dd\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-28-1.webp\" title=\"\ud1b5\ud654 \ud615\uc2dd\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>&#8216;\ucd94\uac00 \ud615\uc2dd&#8217;\uc5d0\uc11c \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c &#8216;\ud1b5\ud654&#8217;, &#8216;\ubc18\uc62c\ub9bc\ub41c \ud1b5\ud654&#8217; \ub610\ub294 &#8216;\uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud1b5\ud654&#8217;\ub97c \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ud1b5\ud654 \uc635\uc158 \uc120\ud0dd\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-27-1.webp\" title=\"\ud1b5\ud654 \uc635\uc158 \uc120\ud0dd\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-4-summarize-your-expenses-using-functions\">4\ub2e8\uacc4: \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ube44\uc6a9 \uc694\uc57d<\/h2>\n<ul class=\"wp-block-list\">\n<li>\uccab \ubc88\uc9f8 \uc2dc\ud2b8\uc5d0 \ube44\uc6a9 \ub370\uc774\ud130\ub97c \uc785\ub825\ud55c \ud6c4 \ud558\ub2e8\uc758 \ud0ed\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub450 \ubc88\uc9f8 \uc2dc\ud2b8\ub85c \uc804\ud658\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Google \uc2dc\ud2b8\uc5d0\uc11c \uc2dc\ud2b8 \uc804\ud658\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-783-1.webp\" title=\"Google \uc2dc\ud2b8\uc5d0\uc11c \uc2dc\ud2b8 \uc804\ud658\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uac01 \uc6d4\uc758 \ucc98\uc74c \uc138 \uae00\uc790\ub85c \uc140 B1~M1\uc5d0 \ub77c\ubca8\uc744 \ubd99\uc785\ub2c8\ub2e4. \uac01 \ubc94\uc8fc\uc758 \ud569\uacc4\ub294 \uc5f4 N\uc5d0 \ubc18\uc601\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc6d4 \ub77c\ubca8 \uc785\ub825\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-784-1.webp\" title=\"\uc6d4 \ub77c\ubca8 \uc785\ub825\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>A\uc758 \ub450 \ubc88\uc9f8 \uc5f4\uc5d0 \uccab \ubc88\uc9f8 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \ube44\uc6a9 \ubc94\uc8fc\uc640 \uc77c\uce58\ud558\ub294 \ube44\uc6a9 \ubc94\uc8fc\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ube44\uc6a9 \ubc94\uc8fc \uc785\ub825\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-31.webp\" title=\"\ube44\uc6a9 \ubc94\uc8fc \uc785\ub825\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>A\uc5f4\uc758 \ub9c8\uc9c0\ub9c9 \uce74\ud14c\uace0\ub9ac \uc544\ub798\uc5d0 &#8216;\uc6d4\uac04 \ucd1d\uacc4&#8217; \ub77c\ubca8\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc6d4 \ucd1d\uc561 \uc785\ub825\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-32.webp\" title=\"\uc6d4 \ucd1d\uc561 \uc785\ub825\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uc140 B2\uc5d0 SUMIFS \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubc94\uc8fc\ub97c \uc694\uc57d\ud569\ub2c8\ub2e4 <code>=SUMIFS(Sheet1!$C$2:$C$11, Sheet1!$B$2:$B$11, $A2, Sheet1!$E$2:$E$11, B$1)<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"SUMIFS \uacf5\uc2dd \uc0ac\uc6a9\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-33-1.webp\" title=\"SUMIFS \uacf5\uc2dd \uc0ac\uc6a9\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uc218\uc2dd\uc744 \uc785\ub825\ud55c \ud6c4 \uc6d4\ubcc4 \ucd1d\uacc4 \uc606\uc758 \ub9c8\uc9c0\ub9c9 \uc140\ub85c \uc218\ud3c9\uc73c\ub85c \ub04c\uc5b4\uac04 \ub2e4\uc74c \ubc94\uc8fc \uc544\ub798\ub85c \ub04c\uc5b4\ub2e4 \ub193\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc140 \uc804\uccb4\uc5d0 \uac78\uccd0 \uc218\uc2dd \ub04c\uae30\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-36-1.webp\" title=\"\uc140 \uc804\uccb4\uc5d0 \uac78\uccd0 \uc218\uc2dd \ub04c\uae30\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>N2 \uc5f4\uc5d0\uc11c\ub294 <code>=SUM(B2:M2)<\/code>\ubc94\uc8fc\ubcc4 \ud569\uacc4\ub97c \uacc4\uc0b0\ud558\ub294 \ub370 \uc0ac\uc6a9\ud558\uba70, \uc774 \uc218\uc2dd\uc744 \ubaa8\ub4e0 \ud56d\ubaa9\uc5d0 \ub300\ud574 \uc544\ub798\ub85c \ub04c\uc5b4\uc635\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uce74\ud14c\uace0\ub9ac \ucd1d\uacc4 \uacc4\uc0b0\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-35-1-1.webp\" title=\"\uce74\ud14c\uace0\ub9ac \ucd1d\uacc4 \uacc4\uc0b0\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uc6d4\ubcc4 \ucd1d\uacc4 \ud589\uc5d0\uc11c\ub294 <code>=SUM(B2:B10)<\/code>\uc2dc\ud2b8\uc758 \ud574\ub2f9 \uc140 \ubc94\uc704\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubaa8\ub4e0 \ubc94\uc8fc\uc758 \ube44\uc6a9\uc744 \uc694\uc57d\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc6d4 \ucd1d\uc561 \uacc4\uc0b0\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-37-1.webp\" title=\"\uc6d4 \ucd1d\uc561 \uacc4\uc0b0\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-5-visualize-expenses-with-charts\">5\ub2e8\uacc4: \ucc28\ud2b8\ub85c \ube44\uc6a9 \uc2dc\uac01\ud654<\/h2>\n<p>Google \uc2dc\ud2b8\uc758 \uc2a4\ud30c\ud06c\ub77c\uc778\uacfc \ud30c\uc774 \ucc28\ud2b8\ub97c \ud65c\uc6a9\ud558\uba74 \ube44\uc6a9\uc744 \uc2dc\uac01\uc801\uc73c\ub85c \ucd94\uc801\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ul class=\"wp-block-list\">\n<li>\uc140 O2\uc5d0 \uc2a4\ud30c\ud06c\ub77c\uc778\uc5d0 \ub300\ud55c \uc218\uc2dd\uc744 \uc785\ub825\ud569\ub2c8\ub2e4: <code>=SPARKLINE(B2:M2)<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ub370\uc774\ud130 \uc2dc\uac01\ud654\ub97c \uc704\ud55c \uc2a4\ud30c\ud06c\ub77c\uc778 \uc0dd\uc131\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-38-1.webp\" title=\"\ub370\uc774\ud130 \uc2dc\uac01\ud654\ub97c \uc704\ud55c \uc2a4\ud30c\ud06c\ub77c\uc778 \uc0dd\uc131\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\ubaa8\ub4e0 \ubc94\uc8fc\uc5d0 \uc801\uc6a9\ud558\ub824\uba74 \ucc44\uc6b0\uae30 \ud578\ub4e4\uc744 \uc544\ub798\ub85c \ub4dc\ub798\uadf8\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc2a4\ud30c\ud06c\ub77c\uc778\uc744 \uc544\ub798\ub85c \ud655\uc7a5\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-39-1.webp\" title=\"\uc2a4\ud30c\ud06c\ub77c\uc778\uc744 \uc544\ub798\ub85c \ud655\uc7a5\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\ud30c\uc774 \ucc28\ud2b8\ub97c \ucd94\uac00\ud558\ub824\uba74 \uba54\ub274\uc5d0\uc11c &#8216;\uc0bd\uc785&#8217;\uc744 \ud074\ub9ad\ud558\uace0 &#8216;\ucc28\ud2b8&#8217;\ub97c \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ucc28\ud2b8 \uc0bd\uc785\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-792-1.webp\" title=\"\ucc28\ud2b8 \uc0bd\uc785\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\ucc28\ud2b8 \ud3b8\uc9d1\uae30\uc5d0\uc11c &#8216;\ucc28\ud2b8 \uc720\ud615&#8217; \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uc5d0\uc11c &#8216;\uc6d0\ud615 \ucc28\ud2b8&#8217;\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ud30c\uc774 \ucc28\ud2b8 \uc720\ud615 \uc120\ud0dd\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-793-1.webp\" title=\"\ud30c\uc774 \ucc28\ud2b8 \uc720\ud615 \uc120\ud0dd\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>&#8216;\ub370\uc774\ud130 \ubc94\uc704&#8217; \ud544\ub4dc\uc5d0 \ub370\uc774\ud130 \ubc94\uc704\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4(\uc608: <code>N2:N10<\/code>).<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ucc28\ud2b8\uc758 \ub370\uc774\ud130 \ubc94\uc704 \uc124\uc815\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-40.webp\" title=\"\ucc28\ud2b8\uc758 \ub370\uc774\ud130 \ubc94\uc704 \uc124\uc815\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>&#8216;\ub77c\ubca8 \ucd94\uac00&#8217;\ub97c \ud074\ub9ad\ud558\uace0 \ub77c\ubca8\uc5d0 \ub300\ud55c \ub370\uc774\ud130 \ubc94\uc704(\uc608: <code>A2:A10<\/code>)\ub97c \uc120\ud0dd\ud55c \ub2e4\uc74c \uc124\uc815\uc744 \uc644\ub8cc\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ud30c\uc774 \ucc28\ud2b8\uc5d0 \ub77c\ubca8 \ucd94\uac00\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-41.webp\" title=\"\ud30c\uc774 \ucc28\ud2b8\uc5d0 \ub77c\ubca8 \ucd94\uac00\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\ud30c\uc774 \ucc28\ud2b8\ub294 \ub2e4\uc591\ud55c \ube44\uc6a9\uc5d0 \ub300\ud55c \uc138\ubd80 \ub0b4\uc6a9\uc744 \uc81c\uc2dc\ud558\uc5ec \uc7ac\uc815\uc5d0 \ub300\ud55c \ud1b5\ucc30\ub825\uc744 \ub192\uc5ec\uc90d\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ucd5c\uc885 \ud30c\uc774 \ucc28\ud2b8 \uc2dc\uac01\ud654\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-43.webp\" title=\"\ucd5c\uc885 \ud30c\uc774 \ucc28\ud2b8 \uc2dc\uac01\ud654\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-6-apply-filters-to-view-categories\">6\ub2e8\uacc4: \ud6a8\uacfc\uc801\uc778 \uc2dc\uccad\uc744 \uc704\ud55c \ud544\ud130 \uc801\uc6a9<\/h2>\n<p>\ud544\ud130\ub97c \uc0ac\uc6a9\ud558\uba74 \uac70\ub798\ub97c \uc190\uc27d\uac8c \uc815\ub82c\ud558\uac70\ub098 \uc228\uae38 \uc218 \uc788\uc5b4 \ucd94\uc801\uae30\uc758 \uad00\ub9ac \ud6a8\uc728\uc131\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/p>\n<ul class=\"wp-block-list\">\n<li>\ud544\ud130\ub9c1\ud558\ub824\ub294 \uc5f4\uc758 \uba38\ub9ac\uae00\uc744 \ud074\ub9ad\ud558\uc138\uc694.<\/li>\n<li>\ub3c4\uad6c \ubaa8\uc74c\uc5d0\uc11c \uc5ed\uc0bc\uac01\ud615\uc73c\ub85c \ud45c\ud604\ub41c &#8216;\ud544\ud130 \ub9cc\ub4e4\uae30&#8217; \ubc84\ud2bc\uc744 \ub204\ub974\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Google \uc2dc\ud2b8\uc5d0\uc11c \ud544\ud130 \ub9cc\ub4e4\uae30\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-44-1.webp\" title=\"Google \uc2dc\ud2b8\uc5d0\uc11c \ud544\ud130 \ub9cc\ub4e4\uae30\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>\uc5f4 \uc81c\ubaa9 \uc606\uc5d0 \uc788\ub294 \ud544\ud130 \uc544\uc774\ucf58\uc744 \ud074\ub9ad\ud558\uba74 \ub2e4\uc591\ud55c \uc635\uc158\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. &#8216;\uac12\uc73c\ub85c \ud544\ud130\ub9c1&#8217;, &#8216;A\uc5d0\uc11c Z\ub85c \uc815\ub82c&#8217; \ub610\ub294 \ucd94\uac00 \uc815\ub82c \uae30\ubcf8 \uc124\uc815 \uc911\uc5d0\uc11c \uc120\ud0dd\ud55c \ub2e4\uc74c &#8216;\ud655\uc778&#8217;\uc744 \ud074\ub9ad\ud558\uc5ec \uc801\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc5f4\uc5d0 \ub300\ud55c \uc815\ub82c \uc635\uc158\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-45.webp\" title=\"\uc5f4\uc5d0 \ub300\ud55c \uc815\ub82c \uc635\uc158\"\/><\/figure>\n<h3 class=\"wp-block-heading\" id=\"important-notes\">\uc911\uc694 \ucc38\uace0 \uc0ac\ud56d<\/h3>\n<ul class=\"wp-block-list\">\n<li>\uc0c8\ub85c\uc6b4 \ube44\uc6a9\uc774 \ucd94\uac00\ub418\uba74 \ube44\uc6a9 \ucd94\uc801\uae30\uac00 \uc790\ub3d9\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub418\uc5b4 \ud30c\uc774 \ucc28\ud2b8\uc758 \ubcc0\uacbd \uc0ac\ud56d\uc744 \ubc18\uc601\ud569\ub2c8\ub2e4.<\/li>\n<li>\ub354 \uc27d\uac8c \ud0d0\uc0c9\ud558\uace0 \ube44\uc6a9\uc744 \ubd84\uc11d\ud560 \uc218 \uc788\ub3c4\ub85d \ud56d\ubaa9\uc744 \ud45c \ud615\uc2dd\uc73c\ub85c \ubcc0\ud658\ud558\ub294 \uac83\uc744 \uace0\ub824\ud558\uc138\uc694.<\/li>\n<li>\ud15c\ud50c\ub9bf\uc744 \uc0ac\uc6a9\ud558\ub294 \ub300\uc2e0 \ub9de\ucda4\ud615 \ube44\uc6a9 \ucd94\uc801\uae30\ub97c \ub9cc\ub4dc\ub294 \uac00\uc7a5 \ud070 \uc7a5\uc810\uc740 \uc624\ub958\uac00 \ubc1c\uc0dd\ud560 \uacbd\uc6b0 \uc989\uc2dc \uc218\uc815\ud560 \uc218 \uc788\ub294 \uc720\uc5f0\uc131\uc785\ub2c8\ub2e4.<\/li>\n<li>\ud3b8\uc758\ub97c \uc704\ud574 \uc2a4\ub9c8\ud2b8\ud3f0\uc5d0 Google \uc2dc\ud2b8 \uc571\uc744 \uc124\uce58\ud558\uc5ec \uc774\ub3d9 \uc911\uc5d0\ub3c4 \ube44\uc6a9\uc744 \uae30\ub85d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\uc7ac\uc815\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\ub294 \uac83\uc740 \ud544\uc218\uc801\uc774\uc9c0\ub9cc, \ud2b9\ud788 \uc9c0\ucd9c\uc744 \ucd94\uc801\ud560 \ub54c \uc885\uc885 \uc555\ub3c4\uc801\uc73c\ub85c \ub290\uaef4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\ud589\ud788\ub3c4 Google \uc2dc\ud2b8 \uc640 \uac19\uc740 \ub3c4\uad6c\ub294 \uc0ac\uc6a9\uc790 \uc9c0\uc815 \uc6d4\ubcc4 \uc9c0\ucd9c \ucd94\uc801\uae30\ub97c \ub9cc\ub4dc\ub294 \uc9c1\uad00\uc801\uc778 \ud50c\ub7ab\ud3fc\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. Google \uc2dc\ud2b8\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uae30\uc131 \ud15c\ud50c\ub9bf\uc744 \uc81c\uacf5\ud558\uc9c0\ub9cc, \ud544\uc694\uc5d0 \ub9de\ub294 \ucd94\uc801\uae30\ub97c \ub514\uc790\uc778\ud558\ub294 \uac83\uc740 \ub2ec\uc131 \uac00\ub2a5\ud558\uace0 \uac04\ub2e8\ud569\ub2c8\ub2e4. 1\ub2e8\uacc4: \ube44\uc6a9 \ucd94\uc801 \uad6c\uc870 \uc815\uc758 \uc9c0\ucd9c \ucd94\uc801\uae30\ub97c \ub9cc\ub4e4\uae30 \uc804\uc5d0 \ud3ec\ud568\ud558\ub824\ub294 \uad6c\uc131 [&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":[19,809],"class_list":["post-5976","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-google","tag-google-sheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/5976","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=5976"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/5976\/revisions"}],"predecessor-version":[{"id":5977,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/5976\/revisions\/5977"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/media?parent=5976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/categories?post=5976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/tags?post=5976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}