{"id":24093,"date":"2024-02-13T10:10:07","date_gmt":"2024-02-13T01:10:07","guid":{"rendered":"https:\/\/www.seraku.co.jp\/tectec-note\/?p=24093"},"modified":"2024-02-28T14:01:41","modified_gmt":"2024-02-28T05:01:41","slug":"excel_frequent10","status":"publish","type":"post","link":"https:\/\/www.seraku.co.jp\/tectec-note\/recruit\/excel_frequent10\/","title":{"rendered":"\u3010\u3053\u308c\u3060\u3051\u77e5\u3063\u3066\u304a\u3051\u3070OK\u3011\u6700\u91cd\u8981\u306eExcel\u95a2\u657010\u9078"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u306f\u3058\u3081\u306b<\/h2>\n\n\n\n<div class=\"main-Point\">\n<ul>\n<li>Excel\u306e\u95a2\u6570\u3068\u306f\u3001\u7279\u5b9a\u51e6\u7406\u3092\u884c\u3046\u305f\u3081\u306b\u7528\u610f\u3055\u308c\u305f\u6570\u5f0f\u30fb\u547d\u4ee4\u6587\u306e\u3053\u3068<\/li>\n<li>\u5165\u529b\u53ef\u80fd\u306a\u5024\u306f\u3001\u6570\u5024\u3084\u6587\u5b57\u5217\u3001\u30bb\u30eb\u3084\u30bb\u30eb\u7bc4\u56f2\u306a\u3069\u3055\u307e\u3056\u307e<\/li>\n<li>\u5165\u529b\u3067\u304d\u308b\u5185\u5bb9\u3084\u500b\u6570\u306a\u3069\u306e\u6761\u4ef6\u306f\u3001\u95a2\u6570\u3054\u3068\u306b\u6c7a\u3081\u3089\u308c\u3066\u3044\u308b<\/li>\n<li>\u95a2\u6570\u306e\u5165\u529b\u65b9\u6cd5\u306f3\u30d1\u30bf\u30fc\u30f3\u3042\u308a\u3001\u81ea\u8eab\u306b\u5408\u3063\u305f\u65b9\u6cd5\u3092\u9078\u307c\u3046<\/li>\n<\/ul>\n<\/div>\n\n\n\n<p>Excel\u306e\u300c\u95a2\u6570\u300d\u3068\u306f\u3001\u3042\u3089\u304b\u3058\u3081\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308bExcel\u6a5f\u80fd\u306e1\u3064\u3067\u3001\u7279\u5b9a\u51e6\u7406\u3092\u884c\u3046\u305f\u3081\u306b\u7528\u610f\u3055\u308c\u305f\u6570\u5f0f\u30fb\u547d\u4ee4\u6587\u306e\u3053\u3068\u3092\u6307\u3057\u307e\u3059\u3002\u95a2\u6570\u3068\u805e\u304f\u3068\u300c\u96e3\u3057\u305d\u3046\u300d\u300c\u306a\u3093\u3068\u306a\u304f\u82e6\u624b\u300d\u3068\u611f\u3058\u308b\u65b9\u3082\u3044\u308b\u3067\u3057\u3087\u3046\u3002<br>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u57fa\u672c\u7684\u306a\u95a2\u6570\u3068\u5165\u529b\u4f8b\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3069\u3046\u3044\u3063\u305f\u5834\u5408\u306b\u4f7f\u7528\u3059\u308b\u306e\u304b\u3082\u3054\u7d39\u4ecb\u3057\u307e\u3059\u306e\u3067\u3001\u305c\u3072\u696d\u52d9\u306b\u5f79\u7acb\u3066\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"relativeLink__wrapper\">\n\t\t\t\t<div class=\"relativeLink__inner\">\n\t\t\t\t\t<div class=\"relativeLink__thumbnail\">\n\t\t\t\t\t\t<a href=\"https:\/\/www.seraku.co.jp\/tectec-note\/industry\/creating-documents-excel\">\n\t\t\t\t\t\t\t<img src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/e7ae94f2d4bb65213eec882e13d8127c.png\" alt=\"\u30a8\u30af\u30bb\u30eb\u8cc7\u6599\u4f5c\u6210\u306e\u30b3\u30c4\uff01\u57fa\u672c\u304b\u3089\u5c0f\u6280\u307e\u3067\u89e3\u8aac\u306e\u30b5\u30e0\u30cd\u30a4\u30eb\">\n\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div class=\"relativeLink__text\">\n\t\t\t\t\t\t<a href=\"https:\/\/www.seraku.co.jp\/tectec-note\/industry\/creating-documents-excel\">\n\t\t\t\t\t\t\t<div class=\"relativeLink__title\">\u30a8\u30af\u30bb\u30eb\u8cc7\u6599\u4f5c\u6210\u306e\u30b3\u30c4\uff01\u57fa\u672c\u304b\u3089\u5c0f\u6280\u307e\u3067\u89e3\u8aac<\/div>\n\t\t\t\t\t\t\t<p>\u672c\u7a3f\u3067\u306f\u898b\u3084\u3059\u3044\u8cc7\u6599\u3092\u7c21\u5358\u306b\u4f5c\u308c\u308b\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u306e\u30b3\u30c4\u3092\u7d39\u4ecb\u3057\u307e\u3059\uff01\u521d\u5fc3\u8005\u5411\u3051\u306b\u95a2\u6570\u306a\u3057\u3067\u2026<\/p>\n\t\t\t\t\t\t\t<div style=\"text-align: right;\">\n\t\t\t\t\t\t\t\t<p class=\"relativeLink__text--more\">\u7d9a\u304d\u306f\u3053\u3061\u3089<\/p>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u57fa\u672c\u7684\u306aExcel\u95a2\u657010\u9078<\/h2>\n\n\n\n<p>Excel\u95a2\u6570\u306f\u3001\u6570\u5f0f\u3067\u6210\u308a\u7acb\u3063\u3066\u3044\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u753b\u50cf\u306f\u3001\u6570\u5f0f\u306e\u7c21\u5358\u306a\u5185\u8a33\u3067\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/18ecf7931869d600b56ba2ae4e825e69.png\" alt=\"\u57fa\u672c\u7684\u306aExcel\u95a2\u657010\u9078\" class=\"wp-image-24100\" width=\"600\" height=\"225\" srcset=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/18ecf7931869d600b56ba2ae4e825e69.png 1200w, https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/18ecf7931869d600b56ba2ae4e825e69-600x225.png 600w, https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/18ecf7931869d600b56ba2ae4e825e69-768x288.png 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure><\/div>\n\n\n<p>\u3053\u306e\u30ab\u30c3\u30b3\u5185\u306b\u5165\u529b\u53ef\u80fd\u306a\u5024\u306f\u3001\u8a08\u7b97\u306e\u3082\u3068\u306b\u306a\u308b\u5024\u3084\u6587\u5b57\u5217\u3001\u30bb\u30eb\u3084\u30bb\u30eb\u7bc4\u56f2\u306a\u3069\u3067\u3059\u3002\u95a2\u6570\u306b\u3088\u3063\u3066\u306f\u3001\u4ed6\u306e\u95a2\u6570\u3092\u5165\u529b\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\u305f\u3060\u3057\u3001\u5165\u529b\u3067\u304d\u308b\u5185\u5bb9\u3084\u500b\u6570\u306f\u95a2\u6570\u3054\u3068\u306b\u6c7a\u3081\u3089\u308c\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u4f7f\u7528\u524d\u306b\u95a2\u6570\u3092\u78ba\u8a8d\u3057\u3066\u304a\u304f\u3068\u3044\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u3092\u5165\u529b\u3059\u308b\u65b9\u6cd5\u306f\u30013\u30d1\u30bf\u30fc\u30f3\u3042\u308a\u307e\u3059\u3002\u5165\u529b\u3059\u308b\u969b\u306f\u3001\u3054\u81ea\u8eab\u306b\u5408\u3063\u305f\u65b9\u6cd5\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li>\u95a2\u6570\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u3067\u691c\u7d22\u30fb\u9078\u629e\u3057\u3066\u5165\u529b\u3059\u308b<\/li>\n<li>\u6570\u5f0f\u30bf\u30d6\u306e\u95a2\u6570\u30e9\u30a4\u30d6\u30e9\u30ea\u304b\u3089\u9078\u629e\u3057\u3066\u5165\u529b\u3059\u308b<\/li>\n<li>\u9078\u629e\u3057\u305f\u30bb\u30eb\u306b\u76f4\u63a5\u6570\u5f0f\u3092\u5165\u529b\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">1\uff0e\u3010SUM\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cSUM\u95a2\u6570\u300d\u306f\u6570\u5024\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b\u95a2\u6570\u3067\u3001\u6307\u5b9a\u7bc4\u56f2\u304b\u3089\u5408\u8a08\u5024\u3092\u8a08\u7b97\u3059\u308b\u969b\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u8acb\u6c42\u66f8\u306e\u5404\u9805\u76ee\u3092\u8db3\u3057\u305f\u5408\u8a08\u91d1\u984d\u3092\u51fa\u3057\u305f\u3044<\/li>\n<li>\u5404\u90e8\u7f72\u306e\u4eba\u54e1\u6570\u3084\u8ab2\u3054\u3068\u306e\u4eba\u54e1\u6570\u3092\u78ba\u8a8d\u3057\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b<\/h4>\n\n\n\n<p>=SUM(\u25b2:\u25bc)<br>\u4e0a\u8a18\u306fSUM\u95a2\u6570\u306e\u6570\u5f0f\u3067\u3059\u3002\u25b2\u306f\u7bc4\u56f2\u306e\u958b\u59cb\u30bb\u30eb\u3001\u25bc\u306f\u7bc4\u56f2\u306e\u7d42\u4e86\u30bb\u30eb\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001D3\u30bb\u30eb\u304b\u3089D10\u30bb\u30eb\u307e\u3067\u306e\u5408\u8a08\u5024\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u5408\u8a08\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u30aa\u30fc\u30c8SUM\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300c\u5408\u8a08\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30aa\u30fc\u30c8SUM\u306f\u03a3\u30de\u30fc\u30af\u304c\u76ee\u5370\u3067\u3059\u3002<\/p>\n\n\n\n<style>\n.wp-block-image {\n    margin: 0 0 1em;\n    display: none;\n}\n.c {\n    text-align: center;\n}\n.overlay { \/* \u30b0\u30ec\u30fc\u306e\u80cc\u666f *\/\n  position: fixed;\n  background: rgba(0, 0, 0, 0.2);\n  transition: all 0.5s 0s ease;\n  visibility: hidden;\n  opacity: 0;\n  top: 0;\n  left: 0;\n  bottom: 0;\n  right: 0;\n}\n#pop-up_01_01,\n#pop-up_01_02,\n#pop-up_01_03,\n#pop-up_02_01,\n#pop-up_02_02,\n#pop-up_02_03,\n#pop-up_02_04,\n#pop-up_02_05,\n#pop-up_02_06,\n#pop-up_02_07,\n#pop-up_02_08,\n#pop-up_02_09,\n#pop-up_02_10,\n#pop-up_02_11,\n#pop-up_02_12\n{\n  display: none;\n}\n#pop-up_01_01:checked + .overlay,\n#pop-up_01_02:checked + .overlay,\n#pop-up_01_03:checked + .overlay,\n#pop-up_02_01:checked + .overlay,\n#pop-up_02_02:checked + .overlay,\n#pop-up_02_03:checked + .overlay,\n#pop-up_02_04:checked + .overlay,\n#pop-up_02_05:checked + .overlay,\n#pop-up_02_06:checked + .overlay,\n#pop-up_02_07:checked + .overlay,\n#pop-up_02_08:checked + .overlay,\n#pop-up_02_09:checked + .overlay,\n#pop-up_02_10:checked + .overlay,\n#pop-up_02_11:checked + .overlay,\n#pop-up_02_12:checked + .overlay\n{\n  visibility: visible;\n  opacity: 1;\n  z-index: 100000;\n  background-color: #000000D0;\n  width: 100%;\n  margin: 0;\n  max-width: initial;\n}\n.popWindow {\n  width:90vw;\n  border-radius: 5px;\n  overflow: auto; \/* \u30b9\u30af\u30ed\u30fc\u30eb\u30d0\u30fc\u7528 *\/\n  max-height: 95%; \/* \u3059\u304d\u9593 *\/\n  min-width: fit-content; \/* \u6a2a\u5e45\u304c\u5e83\u3044\u6642\u306b\u767d\u306e\u90e8\u5206\u304c\u5927\u304d\u304f\u306a\u3089\u306a\u3044\u305f\u3081 *\/\n  max-width: 95%; \/* \u3059\u304d\u9593 *\/\n  position: fixed;\n  top: 50%; \/* \u4e2d\u592e\u306b *\/\n  left: 50%; \/* \u4e2d\u592e\u306b *\/\n  transform: translate(-50%, -50%); \/* \u4e2d\u592e\u306b *\/\n  z-index: 100010;\n  font-size: 13px;\n  line-height: 18px;\n  margin: 10px auto;\n  padding: 4px 10px;\n  background: #FFFD; \/* \u67a0\u306e\u8272 *\/\n  text-align: center; \/* \u6587\u5b57\u3092\u4e2d\u592e\u5bc4\u305b *\/\n  transition: all 500ms ease-in-out;\n}\n.popWindow .ptitle {\n  font-size: 15px;\n  margin: 8px;\n  color: #333;\n}\n.popWindow .close {\n  position: absolute;\n  top: 8px;\n  right: 10px;\n  transition: all 300ms;\n  font-size: 24px;\n  line-height: inherit;\n  font-weight: bold;\n  text-decoration: none;\n  color: #000;\n  padding: 2px;\n}\n.popWindow .close:hover {\n  color: #06D85F;\n}\n.popWindow::-webkit-scrollbar-track {\n  background: none;\n}\n.popWindow::-webkit-scrollbar {\n  width: 10px;\n  height: 10px;\n}\n.popWindow::-webkit-scrollbar-thumb {\n  background: #999;\n  border-radius: 5px;\n}\n.clickable:hover {\n  cursor: pointer;\n}\n\n@media only screen and (min-width: 1168px){\n.entry .entry-content>*, .entry .entry-summary>* {\n     max-width: 100%; \n}\n}\n<\/style>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_01_01\">\n<label id=\"pop-up_01_01--label\" for=\"pop-up_01_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/8804a063d5d614ee9bb5b8dd1bdb695f.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u300e\u30aa\u30fc\u30c8SUM\u300f\u3092\u9078\u629e\"><\/div><label class=\"close\" for=\"pop-up_01_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_01_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/8804a063d5d614ee9bb5b8dd1bdb695f.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0e\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8868\u793a\u304c\u51fa\u305f\u3089\u3001Enter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_01_02\">\n<label id=\"pop-up_01_02--label\" for=\"pop-up_01_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/e8f6f6b314f25d68214d9768997130d6.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u300e\u30aa\u30fc\u30c8SUM\u300f\u3092\u9078\u629e\"><\/div><label class=\"close\" for=\"pop-up_01_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_01_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/e8f6f6b314f25d68214d9768997130d6.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u5408\u8a08\u5024\u306e\u8a08\u7b97\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_01_03\">\n<label id=\"pop-up_01_03--label\" for=\"pop-up_01_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/a1dc537d363c78f939ed386c9cb31fd5.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u5408\u8a08\u5024\u306e\u8a08\u7b97\u304c\u3067\u304d\u307e\u3057\u305f\u3002\"><\/div><label class=\"close\" for=\"pop-up_01_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_01_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/a1dc537d363c78f939ed386c9cb31fd5.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u306a\u304a\u3001\u6570\u5f0f\u3092\u9593\u9055\u308f\u305a\u306b\u5165\u529b\u3067\u304d\u308b\u5834\u5408\u306f\u3001C8\u30bb\u30eb\u306b\u76f4\u63a5\u300c=SUM(D3:D10)\u300d\u3068\u5165\u529b\u3057\u3001Enter\u30ad\u30fc\u3092\u62bc\u3059\u3053\u3068\u3067\u3082\u540c\u69d8\u306e\u51e6\u7406\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2\uff0e\u3010SUMIF\u30fbSUMIFS\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cSUMIF\u95a2\u6570\u300d\u300cSUMIFS\u95a2\u6570\u300d\u306f\u3001\u6307\u5b9a\u3057\u305f\u7bc4\u56f2\u5185\u3067\u3001\u6761\u4ef6\u3092\u6e80\u305f\u3057\u3066\u3044\u308b\u6570\u5024\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b\u95a2\u6570\u3067\u3059\u3002\u300cSUMIF\u95a2\u6570\u300d\u3067\u306f\u5358\u4e00\u6761\u4ef6\u3001\u300cSUMIFS\u95a2\u6570\u300d\u3067\u306f\u8907\u6570\u6761\u4ef6\u3092\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u58f2\u4e0a\u30ea\u30b9\u30c8\u304b\u3089\u3001\u62c5\u5f53\u8005\u3054\u3068\u306e\u58f2\u4e0a\u5408\u8a08\u984d\u3092\u6c42\u3081\u305f\u3044<\/li>\n<li>\u793e\u5185\u30a4\u30d9\u30f3\u30c8\u306e\u53c2\u52a0\u8cbb\u7528\u30ea\u30b9\u30c8\u304b\u3089\u3001\u90e8\u7f72\u3054\u3068\u306e\u53c2\u52a0\u8cbb\u5408\u8a08\u3092\u6c42\u3081\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b\u3010SUMIF\u3011<\/h4>\n\n\n\n<p>=SUMIF(\u7bc4\u56f2, \u691c\u7d22\u6761\u4ef6, [\u5408\u8a08\u7bc4\u56f2])<br>\u4e0a\u8a18\u306fSUMIF\u306e\u6570\u5f0f\u3067\u3059\u3002<br>\u7bc4\u56f2\u3068\u691c\u7d22\u6761\u4ef6\u3001\u8a08\u7b97\u3059\u308b\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u3066\u3001\u8a08\u7b97\u7d50\u679c\u3092\u6c42\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u62c5\u5f53\u8005\u3054\u3068\u306e\u5408\u8a08\u58f2\u4e0a\u984d\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u5408\u8a08\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u6570\u5b66\/\u4e09\u89d2\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cSUMIF\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_01\">\n<label id=\"pop-up_02_01--label\" for=\"pop-up_02_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/ecf4c25a25a42b29531060666df4649e.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"Excel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u6570\u5b66\/\u4e09\u89d2\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cSUMIF\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/ecf4c25a25a42b29531060666df4649e.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u305d\u3046\u3059\u308b\u3068\u3001\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u306e\u3067\u3001\u7bc4\u56f2\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>3\uff0eB3\u30bb\u30eb\u304b\u3089B10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_02\">\n<label id=\"pop-up_02_02--label\" for=\"pop-up_02_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/b33662786d8be1ce6991082fb27e209a.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"B3\u30bb\u30eb\u304b\u3089B10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/b33662786d8be1ce6991082fb27e209a.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u5165\u529b\u6b04\u306b\u300cB3:B10\u300d\u3068\u8a18\u5165\u3055\u308c\u3066\u3044\u305f\u3089\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_03\">\n<label id=\"pop-up_02_03--label\" for=\"pop-up_02_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/3dd320d215cf3cf81ff11fa5a6949f26.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u5165\u529b\u6b04\u306b\u300cB3:B10\u300d\u3068\u8a18\u5165\u3055\u308c\u3066\u3044\u305f\u3089\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/3dd320d215cf3cf81ff11fa5a6949f26.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u691c\u7d22\u6761\u4ef6\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001B14\u3068\u5165\u529b\u3001\u307e\u305f\u306f\u8a72\u5f53\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>5\uff0e\u5408\u8a08\u7bc4\u56f2\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br>D3\u30bb\u30eb\u304b\u3089D10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_04\">\n<label id=\"pop-up_02_04--label\" for=\"pop-up_02_04\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/c03bba1b43148e3fcaf5e1eba659f341.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"D3\u30bb\u30eb\u304b\u3089D10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_04\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_04\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/c03bba1b43148e3fcaf5e1eba659f341.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>6\uff0eOK\u3092\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306fEnter\u30ad\u30fc\u3092\u62bc\u3059\u3053\u3068\u3067\u5408\u8a08\u5024\u304c\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>7\uff0e\u5408\u8a08\u5024\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u67a0\u3092\u4e0b\u3078\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_05\">\n<label id=\"pop-up_02_05--label\" for=\"pop-up_02_05\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/d22419755e93211de108b2b9ecf9fd53.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"D3\u30bb\u30eb\u304b\u3089D10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_05\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_05\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/d22419755e93211de108b2b9ecf9fd53.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u305d\u308c\u305e\u308c\u306e\u5408\u8a08\u5024\u304c\u8a08\u7b97\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u4f8b\u306e\u3088\u3046\u306b\u3001\u7d9a\u3051\u3066\u6b21\u306e\u62c5\u5f53\u8005\u5206\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b\u969b\u306f\u300c\u7d76\u5bfe\u53c2\u7167\u300d\u3092\u884c\u3046\u3068\u52b9\u7387\u7684\u3067\u3057\u3087\u3046\u3002<br>\u7d76\u5bfe\u53c2\u7167\u3068\u306f\u3001F4\u30ad\u30fc\u3092\u62bc\u3059\u3053\u3068\u3067\u8ffd\u52a0\u3055\u308c\u305f\u300c$\u300d\u306e\u3053\u3068\u3067\u3059\u3002\u30ce\u30fc\u30c8\u30d1\u30bd\u30b3\u30f3\u3067\u4f5c\u696d\u3092\u3055\u308c\u308b\u65b9\u306e\u5834\u5408\u306f\u3001Fn+F4\u30ad\u30fc\u3067\u5165\u529b\u53ef\u80fd\u3067\u3059\u3002<br>\u5217\u65b9\u5411\u3092\u7d76\u5bfe\u53c2\u7167\u3059\u308b\u5834\u5408\u306f\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u306e\u524d\u306b\u633f\u5165\u3057\u3001\u884c\u65b9\u5411\u306b\u7d76\u5bfe\u53c2\u7167\u3059\u308b\u5834\u5408\u306f\u6570\u5b57\u306e\u524d\u306b\u633f\u5165\u3057\u307e\u3059\u3002<br>\u4eca\u56de\u306e\u4f8b\u3067\u306f\u3001\u5217\u65b9\u5411\u3068\u884c\u65b9\u5411\u3001\u3069\u3061\u3089\u3082\u7d76\u5bfe\u53c2\u7167\u3057\u305f\u3082\u306e\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b\u3010SUMIFS\u3011<\/h4>\n\n\n\n<p>=SUMIFS(\u5408\u8a08\u5bfe\u8c61\u7bc4\u56f2, \u6761\u4ef6\u7bc4\u56f2 1, \u6761\u4ef6 1, [\u6761\u4ef6\u7bc4\u56f2 2, \u6761\u4ef6 2], &#8230;)<br>\u4e0a\u8a18\u306fSUMIFS\u306e\u6570\u5f0f\u3067\u3059\u3002<br>\u5408\u8a08\u3059\u308b\u5bfe\u8c61\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u3066\u304b\u3089\u3001\u6307\u5b9a\u6761\u4ef6\u306e\u7bc4\u56f2\u3068\u6761\u4ef6\u3092\u3001\u5fc5\u8981\u306a\u5206\u5165\u529b\u3057\u3066\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u62c5\u5f53\u8005\u3054\u3068\u306b\u30d7\u30e9\u30f3A\u306e\u58f2\u4e0a\u5408\u8a08\u984d\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u5408\u8a08\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u6570\u5b66\/\u4e09\u89d2\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cSUMIFS\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_06\">\n<label id=\"pop-up_02_06--label\" for=\"pop-up_02_06\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/ce7dd9a8d4e80db0ad75f7b4adbdf860.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"Excel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u6570\u5b66\/\u4e09\u89d2\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cSUMIFS\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_06\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_06\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/ce7dd9a8d4e80db0ad75f7b4adbdf860.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u305d\u3046\u3059\u308b\u3068\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u306e\u3067\u3001\u5408\u8a08\u5bfe\u8c61\u7bc4\u56f2\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>3\uff0eD3\u30bb\u30eb\u304b\u3089D10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_07\">\n<label id=\"pop-up_02_07--label\" for=\"pop-up_02_07\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/511e41128b0ab357796b337a4f6ee01f.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"D3\u30bb\u30eb\u304b\u3089D10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_07\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_07\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/511e41128b0ab357796b337a4f6ee01f.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u6b21\u306b\u3001\u6761\u4ef6\u7bc4\u56f21\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002B3\u30bb\u30eb\u304b\u3089B10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_08\">\n<label id=\"pop-up_02_08--label\" for=\"pop-up_02_08\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/e3559c85dd7030fa1fc914e04c72c31b-1.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u6b21\u306b\u3001\u6761\u4ef6\u7bc4\u56f21\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002B3\u30bb\u30eb\u304b\u3089B10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_08\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_08\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/e3559c85dd7030fa1fc914e04c72c31b-1.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u6761\u4ef61\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001B14\u3068\u5165\u529b\u3001\u307e\u305f\u306f\u8a72\u5f53\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_09\">\n<label id=\"pop-up_02_09--label\" for=\"pop-up_02_09\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/c2acc3476a7144a6df3115ef1a39dda8.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u6b21\u306b\u3001\u6761\u4ef6\u7bc4\u56f21\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002B3\u30bb\u30eb\u304b\u3089B10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_09\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_09\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/c2acc3476a7144a6df3115ef1a39dda8.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>5\uff0e\u6761\u4ef6\u7bc4\u56f22\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002C3\u30bb\u30eb\u304b\u3089C10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_10\">\n<label id=\"pop-up_02_10--label\" for=\"pop-up_02_10\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/98dadd8ee7d5fd40dd20f026ca8ccff8.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u6761\u4ef6\u7bc4\u56f22\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002C3\u30bb\u30eb\u304b\u3089C10\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3067\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_10\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_10\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/98dadd8ee7d5fd40dd20f026ca8ccff8.png\" alt=\"\" width=\"563\" height=\"219\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u6761\u4ef62\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002D13\u3068\u5165\u529b\u3001\u307e\u305f\u306f\u8a72\u5f53\u30bb\u30eb\u3092\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_11\">\n<label id=\"pop-up_02_11--label\" for=\"pop-up_02_11\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/5da8008b4f0e1667ebf475437c0d05cf.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u6761\u4ef62\u306e\u5165\u529b\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002D13\u3068\u5165\u529b\u3001\u307e\u305f\u306f\u8a72\u5f53\u30bb\u30eb\u3092\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u30921\u56de\u62bc\u3057\u307e\u3059\u3002\"><\/div><label class=\"close\" for=\"pop-up_02_11\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_11\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/5da8008b4f0e1667ebf475437c0d05cf.png\" alt=\"\" width=\"563\" height=\"257\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>6\uff0eOK\u3092\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306fEnter\u30ad\u30fc\u3092\u62bc\u3059\u3053\u3068\u3067\u5408\u8a08\u5024\u304c\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>7\uff0e\u5408\u8a08\u5024\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u67a0\u3092\u4e0b\u3078\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_02_12\">\n<label id=\"pop-up_02_12--label\" for=\"pop-up_02_12\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" loading=\"lazy\" width=\"1128\" height=\"513\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/31789b9939c629b092d66db8fa6583b4.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u5408\u8a08\u5024\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u67a0\u3092\u4e0b\u3078\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\" srcset=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/31789b9939c629b092d66db8fa6583b4.png 1128w, https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/31789b9939c629b092d66db8fa6583b4-600x273.png 600w, https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/31789b9939c629b092d66db8fa6583b4-768x349.png 768w\" sizes=\"(max-width: 1128px) 100vw, 1128px\" \/><\/div><label class=\"close\" for=\"pop-up_02_12\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_02_12\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/31789b9939c629b092d66db8fa6583b4.png\" alt=\"\" width=\"563\" height=\"257\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u305d\u308c\u305e\u308c\u306e\u5408\u8a08\u5024\u304c\u8a08\u7b97\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u6761\u4ef6\u7bc4\u56f22\u3067\u306e\u7d76\u5bfe\u53c2\u7167\u3092\u5fd8\u308c\u308b\u3068\u3001\u30c9\u30e9\u30c3\u30b0\u3057\u305f\u969b\u306b\u6c42\u3081\u305f\u30c7\u30fc\u30bf\u304c\u53cd\u6620\u3055\u308c\u306a\u304f\u306a\u308a\u307e\u3059\u3002\u5165\u529b\u5f8c\u306f\u3001OK\u306e\u30af\u30ea\u30c3\u30af\u524d\u306b\u5fc5\u8981\u306a\u7bc4\u56f2\u304c\u7d76\u5bfe\u53c2\u7167\u3055\u308c\u3066\u3044\u308b\u304b\u3001\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3\uff0e\u3010AVERAGE\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cAVERAGE\u95a2\u6570\u300d\u306f\u6570\u5024\u306e\u5e73\u5747\u3092\u6c42\u3081\u308b\u95a2\u6570\u3067\u3001\u6307\u5b9a\u7bc4\u56f2\u306b\u3042\u308b\u5024\u306e\u5e73\u5747\u5024\u3092\u8a08\u7b97\u3059\u308b\u969b\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u9867\u5ba2\u5c64\u306e\u5e74\u9f62\u5e73\u5747\u3092\u6c42\u3081\u305f\u3044<\/li>\n<li>\u90e8\u7f72\u3054\u3068\u306e\u58f2\u4e0a\u5e73\u5747\u3092\u6c42\u3081\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b<\/h4>\n\n\n\n<p>=AVERAGE(\u25b2:\u25bc)<br>\u4e0a\u8a18\u306fAVERAGE\u95a2\u6570\u306e\u6570\u5f0f\u3067\u3059\u3002\u25b2\u306f\u7bc4\u56f2\u306e\u958b\u59cb\u30bb\u30eb\u3001\u25bc\u306f\u7bc4\u56f2\u306e\u7d42\u4e86\u30bb\u30eb\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u53c2\u8003\u8868\u306eD4\u30bb\u30eb\u304b\u3089D10\u30bb\u30eb\u307e\u3067\u306e\u5e73\u5747\u5024\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u5e73\u5747\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u30aa\u30fc\u30c8SUM\u300f\u3092\u9078\u629e\u3057\u3001\u5e73\u5747\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30aa\u30fc\u30c8SUM\u306f\u03a3\u30de\u30fc\u30af\u304c\u76ee\u5370\u3067\u3059\u3002<\/p>\n\n\n\n<style>\n#pop-up_03_01,\n#pop-up_03_02,\n#pop-up_03_03,\n#pop-up_03_04\n{\n  display: none;\n}\n#pop-up_03_01:checked + .overlay,\n#pop-up_03_02:checked + .overlay,\n#pop-up_03_03:checked + .overlay,\n#pop-up_03_04:checked + .overlay\n{\n  visibility: visible;\n  opacity: 1;\n  z-index: 100000;\n  background-color: #000000D0;\n  width: 100%;\n  margin: 0;\n  max-width: initial;\n}\n<\/style>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_03_01\">\n<label id=\"pop-up_03_01--label\" for=\"pop-up_03_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/48535a53f83bc05f5edd2e3fc2f354d1.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"Excel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u30aa\u30fc\u30c8SUM\u300f\u3092\u9078\u629e\u3057\u3001\u5e73\u5747\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30aa\u30fc\u30c8SUM\u306f\u03a3\u30de\u30fc\u30af\u304c\u76ee\u5370\u3067\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_03_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_03_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/48535a53f83bc05f5edd2e3fc2f354d1.png\" alt=\"\" width=\"563\" height=\"205\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0e\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8868\u793a\u304c\u51fa\u305f\u3089\u3001Enter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_03_02\">\n<label id=\"pop-up_03_02--label\" for=\"pop-up_03_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/47b1ab6460daa13dd72d4280eba3d750.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8868\u793a\u304c\u51fa\u305f\u3089\u3001Enter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_03_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_03_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/47b1ab6460daa13dd72d4280eba3d750.png\" alt=\"\" width=\"563\" height=\"205\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u5e73\u5747\u5024\u306e\u8a08\u7b97\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_03_03\">\n<label id=\"pop-up_03_03--label\" for=\"pop-up_03_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/795b103e726b8f4200937cf1accb0eac.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u5e73\u5747\u5024\u306e\u8a08\u7b97\u304c\u3067\u304d\u307e\u3057\u305f\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_03_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_03_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/795b103e726b8f4200937cf1accb0eac.png\" alt=\"\" width=\"563\" height=\"205\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u306a\u304a\u3001\u4ed6\u306e\u5e73\u5747\u5024\u3082\u6c42\u3081\u308b\u5834\u5408\u306b\u4fbf\u5229\u306a\u65b9\u6cd5\u3068\u3057\u3066\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u6a5f\u80fd\u304c\u3042\u308a\u307e\u3059\u3002<br>\u9078\u629e\u3057\u305f\u30bb\u30eb\u7bc4\u56f2\u306e\u53f3\u4e0b\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3059\u308b\u3053\u3068\u3067\u3001\u6b8b\u308a\u306e\u30bb\u30eb\u306b\u3082\u6570\u5f0f\u304c\u5165\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_03_04\">\n<label id=\"pop-up_03_04--label\" for=\"pop-up_03_04\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/9453dc2ccf67b1c089079c968a6c396a.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u9078\u629e\u3057\u305f\u30bb\u30eb\u7bc4\u56f2\u306e\u53f3\u4e0b\u3092\u30af\u30ea\u30c3\u30af\uff06\u30c9\u30e9\u30c3\u30b0\u3059\u308b\u3053\u3068\u3067\u3001\u6b8b\u308a\u306e\u30bb\u30eb\u306b\u3082\u6570\u5f0f\u304c\u5165\u529b\u3055\u308c\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_03_04\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_03_04\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/9453dc2ccf67b1c089079c968a6c396a.png\" alt=\"\" width=\"563\" height=\"205\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">4\uff0e\u3010COUNT\u30fbCOUNTA\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cCOUNT\u30fbCOUNTA\u95a2\u6570\u300d\u306f\u6307\u5b9a\u7bc4\u56f2\u5185\u304b\u3089\u65e5\u4ed8\u3084\u6642\u523b\u306a\u3069\u3001\u6570\u5024\u30c7\u30fc\u30bf\u306e\u500b\u6570\u3092\u6c42\u3081\u308b\u95a2\u6570\u3067\u3059\u3002\u6708\u9593\u306e\u51fa\u5411\u65e5\u6570\u3084\u7dca\u6025\u51fa\u52d5\u65e5\u6570\u306a\u3069\u306e\u7b97\u51fa\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<br>\u3057\u304b\u3057\u300cCOUNT\u95a2\u6570\u300d\u304c\u8a08\u7b97\u53ef\u80fd\u306a\u306e\u306f\u6570\u5024\u306e\u307f\u3067\u3001\u6587\u5b57\u5217\u306f\u5bfe\u8c61\u5916\u306a\u70b9\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002\u6587\u5b57\u5217\u304c\u30c7\u30fc\u30bf\u306b\u542b\u307e\u308c\u308b\u5834\u5408\u306f\u3001\u7a7a\u767d\u30bb\u30eb\u4ee5\u5916\u306e\u3059\u3079\u3066\u3092\u6570\u3048\u3089\u308c\u308b\u300cCOUNTA\u95a2\u6570\u300d\u3092\u7528\u3044\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u51fa\u52e4\u65e5\u6570\u3092\u6570\u3048\u305f\u3044<\/li>\n<li>\u6708\u9593\u306e\u51fa\u52d5\u65e5\u6570\u3092\u6570\u3048\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b\u3010COUNT\u3011<\/h4>\n\n\n\n<p>=COUNT(\u25b2:\u25bc)<br>\u4e0a\u8a18\u306fCOUNT\u95a2\u6570\u306e\u6570\u5f0f\u3067\u3059\u3002\u25b2\u306f\u7bc4\u56f2\u306e\u958b\u59cb\u30bb\u30eb\u3001\u25bc\u306f\u7bc4\u56f2\u306e\u7d42\u4e86\u30bb\u30eb\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u53c2\u8003\u8868\u306b\u8a18\u8f09\u3055\u308c\u305f\u51fa\u52d5\u65e5\u6570\u306e\u6570\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u6570\u3048\u305f\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u30aa\u30fc\u30c8SUM\u300f\u3092\u9078\u629e\u3057\u3001\u6570\u5024\u306e\u500b\u6570\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30aa\u30fc\u30c8SUM\u306f\u03a3\u30de\u30fc\u30af\u304c\u76ee\u5370\u3067\u3059\u3002<\/p>\n\n\n\n<style>\n#pop-up_04_01,\n#pop-up_04_02,\n#pop-up_04_03,\n#pop-up_04_04,\n#pop-up_04_05,\n#pop-up_04_06\n{\n  display: none;\n}\n#pop-up_04_01:checked + .overlay,\n#pop-up_04_02:checked + .overlay,\n#pop-up_04_03:checked + .overlay,\n#pop-up_04_04:checked + .overlay,\n#pop-up_04_05:checked + .overlay,\n#pop-up_04_06:checked + .overlay\n{\n  visibility: visible;\n  opacity: 1;\n  z-index: 100000;\n  background-color: #000000D0;\n  width: 100%;\n  margin: 0;\n  max-width: initial;\n}\n<\/style>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_04_01\">\n<label id=\"pop-up_04_01--label\" for=\"pop-up_04_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/2d25d10ed6281fde897ae45297e59cc6.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"Excel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u30aa\u30fc\u30c8SUM\u300f\u3092\u9078\u629e\u3057\u3001\u6570\u5024\u306e\u500b\u6570\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30aa\u30fc\u30c8SUM\u306f\u03a3\u30de\u30fc\u30af\u304c\u76ee\u5370\u3067\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_04_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_04_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/2d25d10ed6281fde897ae45297e59cc6.png\" alt=\"\" width=\"563\" height=\"205\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0eE3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001E20\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_04_02\">\n<label id=\"pop-up_04_02--label\" for=\"pop-up_04_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/50883f3b02f665de199bb3697f9e47bb.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"E3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001E20\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_04_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_04_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/2d25d10ed6281fde897ae45297e59cc6.png\" alt=\"\" width=\"563\" height=\"205\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0eG3\u30bb\u30eb\u5185\u306b\u300c=COUNT(E3:E20)\u300d\u3068\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u305f\u3089\u3001Enter\u30ad\u30fc\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>5\uff0e\u6570\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_04_03\">\n<label id=\"pop-up_04_03--label\" for=\"pop-up_04_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/7f3f74be86d4c6ec79c1342375d192b6.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"5\uff0e\u6570\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_04_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_04_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/7f3f74be86d4c6ec79c1342375d192b6.png\" alt=\"\" width=\"563\" height=\"205\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b\u3010COUNTA\u3011<\/h4>\n\n\n\n<p>=COUNTA(\u25b2:\u25bc)<br>\u4e0a\u8a18\u306fCOUNTA\u95a2\u6570\u306e\u6570\u5f0f\u3067\u3059\u3002\u25b2\u306f\u7bc4\u56f2\u306e\u958b\u59cb\u30bb\u30eb\u3001\u25bc\u306f\u7bc4\u56f2\u306e\u7d42\u4e86\u30bb\u30eb\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u8868\u306b\u8a18\u8f09\u3055\u308c\u305f\u5fdc\u63f4\u8fbc\u307f\u306e\u51fa\u52d5\u65e5\u6570\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u6570\u3048\u305f\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<br>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u305d\u306e\u4ed6\u306e\u95a2\u6570\u300f\u3092\u9078\u629e\u3057\u3001\u7d71\u8a08\u306e\u4e00\u89a7\u304b\u3089\u300cCOUNTA\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_04_04\">\n<label id=\"pop-up_04_04--label\" for=\"pop-up_04_04\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/80e4aa7e04e91a028779b17f0949c465.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u305d\u306e\u4ed6\u306e\u95a2\u6570\u300f\u3092\u9078\u629e\u3057\u3001\u7d71\u8a08\u306e\u4e00\u89a7\u304b\u3089\u300cCOUNTA\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_04_04\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_04_04\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/80e4aa7e04e91a028779b17f0949c465.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0e\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u305f\u3089E3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001E20\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_04_05\">\n<label id=\"pop-up_04_05--label\" for=\"pop-up_04_05\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/623aa07fe8de2401510fc33c793650e2.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"3\uff0e\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u305f\u3089E3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001E20\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_04_05\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_04_05\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/623aa07fe8de2401510fc33c793650e2.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u3092\u78ba\u8a8d\u3057\u3001\u50241\u5165\u529b\u6b04\u306b\u300cE3:E20\u300d\u3068\u5165\u529b\u3055\u308c\u3066\u3044\u305f\u3089\u3001OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>5\uff0e\u6570\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_04_06\">\n<label id=\"pop-up_04_06--label\" for=\"pop-up_04_06\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/0fe64ccfac670e2db013b7fbb11cdb12.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"5\uff0e\u6570\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_04_06\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_04_06\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/0fe64ccfac670e2db013b7fbb11cdb12.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">5\uff0e\u3010IF\u30fbIFS\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cIF\u30fbIFS\u95a2\u6570\u300d\u306f\u3001\u8a2d\u5b9a\u6761\u4ef6\u3092\u6e80\u305f\u3057\u3066\u3044\u308b\u5834\u5408\u3068\u305d\u3046\u3067\u306a\u3044\u5834\u5408\u306e\u7d50\u679c\u3092\u8868\u793a\u3067\u304d\u308b\u95a2\u6570\u3067\u3059\u3002\u300c\u6761\u4ef6\u3092\u6e80\u305f\u305b\u3070\u25ef\u3001\u6e80\u305f\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u2715\u3068\u8868\u793a\u300d\u3068\u3044\u3063\u305f\u6761\u4ef6\u6307\u5b9a\u3092\u884c\u3046\u3053\u3068\u3067\u3001\u6761\u4ef6\u304c\u6e80\u305f\u3055\u308c\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u3092\u4e00\u89a7\u3067\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u57fa\u6e96\u3092\u4e0a\u56de\u3063\u305f\u304b\u3069\u3046\u304b\u3092\u4e00\u89a7\u5316\u3057\u305f\u3044<\/li>\n<li>\u8a66\u9a13\u7d50\u679c\u304b\u3089\u7d20\u65e9\u304f\u5224\u65ad\u3057\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<p>\u300cIF\u95a2\u6570\u300d\u306b\u8a2d\u5b9a\u53ef\u80fd\u306a\u6761\u4ef6\u306f1\u3064\u307e\u3067\u3068\u6c7a\u3081\u3089\u308c\u3066\u3044\u307e\u3059\u3002\u8907\u6570\u6761\u4ef6\u3092\u8a2d\u5b9a\u3001\u307e\u305f\u306f\u7d44\u307f\u5408\u308f\u305b\u308b\u5834\u5408\u306b\u306f\u300cIFS\u95a2\u6570\u300d\u3092\u4f7f\u7528\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u6761\u4ef6\u3092\u6307\u5b9a\u3059\u308b\u969b\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u6bd4\u8f03\u6f14\u7b97\u5b50\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<br>\u95a2\u6570\u3092\u5fdc\u7528\u3057\u3066\u3044\u304f\u969b\u306b\u3082\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u306e\u3067\u3001\u899a\u3048\u3066\u304a\u304f\u3068\u3044\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table rt-Table\"><table><tbody><tr><th>\u6f14\u7b97\u5b50<\/th><th>\u4f8b<\/th><th>\u610f\u5473<\/th><\/tr><tr><th>\uff1d<\/th><td>A=B<\/td><td>A\u3068B\u304c\u7b49\u3057\u3044<\/td><\/tr>\n<tr><th>\uff1c\uff1e<\/th><td>A<>B<\/td><td>A\u3068B\u304c\u7b49\u3057\u304f\u306a\u3044<\/td><\/tr>\n<tr><th>\uff1e\uff1d<\/th><td>A>=B<\/td><td>A\u304cB\u4ee5\u4e0a<\/td><\/tr>\n<tr><th>\uff1c\uff1d<\/th><td>A<=B<\/td><td>A\u304cB\u4ee5\u4e0b<\/td><\/tr>\n<tr><th>\uff1e<\/th><td>A>B<\/td><td>A\u304cB\u3088\u308a\u5927\u304d\u3044<\/td><\/tr>\n<tr><th>\uff1c<\/th><td>A<B<\/td><td>A\u304cB\u3088\u308a\u5c0f\u3055\u3044<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b\u3010IF\u3011<\/h4>\n\n\n\n<p>=IF(\u8ad6\u7406\u5f0f,\u771f\u306e\u5834\u5408,\u507d\u306e\u5834\u5408)<br>\u4e0a\u8a18\u306fIF\u95a2\u6570\u306e\u6570\u5f0f\u3067\u3059\u3002\u8ad6\u7406\u5f0f\u3068\u306f\u5224\u65ad\u306e\u57fa\u6e96\u3068\u306a\u308b\u5024\u306e\u3053\u3068\u3067\u3001\u771f\u306e\u5834\u5408\u306e\u51e6\u7406\u3001\u507d\u306e\u5834\u5408\u306e\u51e6\u7406\u3092\u305d\u308c\u305e\u308c\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u8a66\u9a13\u306e\u5408\u8a08\u5f97\u70b9300\u70b9\u3092\u57fa\u6e96\u3068\u3057\u3001300\u70b9\u4ee5\u4e0a\u306e\u5834\u5408\u306f\u3007\u3092\u3001\u6e80\u305f\u306a\u3044\u5834\u5408\u306f\u2715\u3092\u8868\u793a\u3059\u308b\u3088\u3046\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u7d50\u679c\u5217\u306e\u4e00\u756a\u4e0a\u306b\u3042\u308b\u30bb\u30eb\uff08G3\uff09\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<style>\n#pop-up_05_01,\n#pop-up_05_02,\n#pop-up_05_03,\n#pop-up_05_04,\n#pop-up_05_05,\n#pop-up_05_06,\n#pop-up_05_07,\n#pop-up_05_08,\n#pop-up_05_09,\n#pop-up_05_10,\n#pop-up_05_11,\n#pop-up_05_12,\n#pop-up_05_13,\n#pop-up_05_14,\n#pop-up_05_15,\n#pop-up_05_16\n{\n  display: none;\n}\n#pop-up_05_01:checked + .overlay,\n#pop-up_05_02:checked + .overlay,\n#pop-up_05_03:checked + .overlay,\n#pop-up_05_04:checked + .overlay,\n#pop-up_05_05:checked + .overlay,\n#pop-up_05_06:checked + .overlay,\n#pop-up_05_07:checked + .overlay,\n#pop-up_05_08:checked + .overlay,\n#pop-up_05_09:checked + .overlay,\n#pop-up_05_10:checked + .overlay,\n#pop-up_05_11:checked + .overlay,\n#pop-up_05_12:checked + .overlay,\n#pop-up_05_13:checked + .overlay,\n#pop-up_05_14:checked + .overlay,\n#pop-up_05_15:checked + .overlay,\n#pop-up_05_16:checked + .overlay\n{\n  visibility: visible;\n  opacity: 1;\n  z-index: 100000;\n  background-color: #000000D0;\n  width: 100%;\n  margin: 0;\n  max-width: initial;\n}\n<\/style>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_01\">\n<label id=\"pop-up_05_01--label\" for=\"pop-up_05_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/5faf863bc4f118a71558b4d0b57db5cf.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"1\uff0e\u7d50\u679c\u5217\u306e\u4e00\u756a\u4e0a\u306b\u3042\u308b\u30bb\u30eb\uff08G3\uff09\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/5faf863bc4f118a71558b4d0b57db5cf.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u8ad6\u7406\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cIF\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_02\">\n<label id=\"pop-up_05_02--label\" for=\"pop-up_05_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/71ecd558c5ebb990d0bf5dd988606b02.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u8ad6\u7406\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cIF\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/71ecd558c5ebb990d0bf5dd988606b02.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0e\u5408\u8a08\u70b9\u304b\u3089\u5224\u65ad\u3059\u308b\u305f\u3081\u3001F3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001F22\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_03\">\n<label id=\"pop-up_05_03--label\" for=\"pop-up_05_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/492154a02d0dfff48c4adf4e8729d0ed.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"3\uff0e\u5408\u8a08\u70b9\u304b\u3089\u5224\u65ad\u3059\u308b\u305f\u3081\u3001F3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001F22\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/492154a02d0dfff48c4adf4e8729d0ed.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u8ad6\u7406\u5f0f\u306e\u5165\u529b\u6b04\u306b\u300cF3:F22\u300d\u3068\u5165\u529b\u3055\u308c\u305f\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u305f\u3089\u3001\u305d\u306e\u5f8c\u306b\u7d9a\u3051\u3066\u300c&gt;=300\u300d\u3068\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_04\">\n<label id=\"pop-up_05_04--label\" for=\"pop-up_05_04\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/59559683eb6ce8b28d1f49bebd903152.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u8ad6\u7406\u5f0f\u306e\u5165\u529b\u6b04\u306b\u300cF3:F22\u300d\u3068\u5165\u529b\u3055\u308c\u305f\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u305f\u3089\u3001\u305d\u306e\u5f8c\u306b\u7d9a\u3051\u3066\u300c&gt;=300\u300d\u3068\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_04\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_04\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/59559683eb6ce8b28d1f49bebd903152.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u3053\u308c\u3067\u300cF3\u304b\u3089F22\u306e\u3046\u3061\u3001300\u70b9\u4ee5\u4e0a\u300d\u3092\u610f\u5473\u3059\u308b\u6570\u5f0f\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>4\uff0e\u6b21\u306b\u3001\u5024\u304c\u771f\u306e\u5834\u5408\u306e\u5165\u529b\u6b04\u306b\u300c&#8221;\u3007&#8221;\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_05\">\n<label id=\"pop-up_05_05--label\" for=\"pop-up_05_05\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/3ee3cb5a61d5a28f6ace14512c59dc5c.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"4\uff0e\u6b21\u306b\u3001\u5024\u304c\u771f\u306e\u5834\u5408\u306e\u5165\u529b\u6b04\u306b\u300c&quot;\u3007&quot;\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_05\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_05\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/3ee3cb5a61d5a28f6ace14512c59dc5c.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u300c&#8221;&#8221;\uff08\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\uff09\u300d\u3067\u56f2\u3080\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u306e\u3067\u3001\u5165\u529b\u3092\u5fd8\u308c\u306a\u3044\u3088\u3046\u6ce8\u610f\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>5\uff0e\u540c\u69d8\u306b\u3001\u5024\u304c\u507d\u306e\u5834\u5408\u306e\u5165\u529b\u6b04\u306b\u300c&#8221;\u2715&#8221;\u300d\u3068\u5165\u529b\u3057\u305f\u3089\u3001OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_06\">\n<label id=\"pop-up_05_06--label\" for=\"pop-up_05_06\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/535c20d7cbac5c43cecc80281a7a9ddc.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"5\uff0e\u540c\u69d8\u306b\u3001\u5024\u304c\u507d\u306e\u5834\u5408\u306e\u5165\u529b\u6b04\u306b\u300c&quot;\u2715&quot;\u300d\u3068\u5165\u529b\u3057\u305f\u3089\u3001OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_06\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_06\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/535c20d7cbac5c43cecc80281a7a9ddc.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>6\uff0e\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u306b\u3088\u308b\u7d50\u679c\u304c\u8868\u793a\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_07\">\n<label id=\"pop-up_05_07--label\" for=\"pop-up_05_07\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/0decd05ab95705a67ad5c9261794eaab.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"6\uff0e\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u306b\u3088\u308b\u7d50\u679c\u304c\u8868\u793a\u3067\u304d\u307e\u3057\u305f\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_07\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_07\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/0decd05ab95705a67ad5c9261794eaab.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b\u3010IFS\u3011<\/h4>\n\n\n\n<p>=IF(\u8ad6\u7406\u5f0f1,\u5024\u304c\u771f\u306e\u5834\u54081,\u8ad6\u7406\u5f0f2,\u5024\u304c\u771f\u306e\u5834\u54082,\u8ad6\u7406\u5f0f3,&#8230;)<br>\u4e0a\u8a18\u306fIF\u95a2\u6570\u306e\u6570\u5f0f\u3067\u3059\u3002\u3053\u306e\u6570\u5f0f\u3067\u306f\u3001\u6761\u4ef6\u3092\u6307\u5b9a\u3059\u308b\u3054\u3068\u306b\u8ad6\u7406\u5f0f\u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u300c\u8ad6\u7406\u5f0f,\u5024\u304c\u771f\u306e\u5834\u5408\u300d\u306f\u30bb\u30c3\u30c8\u3067\u8003\u3048\u308b\u3068\u3001\u7406\u89e3\u3057\u3084\u3059\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u3053\u306e\u4f8b\u3067\u306f\u3001\u540c\u3058\u8868\u3092\u4f7f\u7528\u3057\u3001\u8a66\u9a13\u7d50\u679c\u3092\u3082\u3068\u306b\u4ee5\u4e0b\u306e\u6761\u4ef6\u3092\u6c42\u3081\u307e\u3059\u3002<\/li>\n<li>\u5408\u8a08\u5f97\u70b9\u304c300\u70b9\u4ee5\u4e0a\u306e\u5834\u5408\u306f\u300c\u3007\u300d\u3068\u3059\u308b<\/li>\n<li>\u5408\u8a08\u5f97\u70b9\u304c250\u70b9\u4ee5\u4e0a\u306e\u5834\u5408\u306f\u300c\u25b3\u300d\u3068\u3059\u308b<\/li>\n<li>\u5408\u8a08\u5f97\u70b9\u304c249\u70b9\u672a\u6e80\u306e\u5834\u5408\u306f\u300c\u2715\u300d\u3068\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>1\uff0e\u307e\u305a\u3001\u7d50\u679c\u5217\u306e\u4e00\u756a\u4e0a\u306b\u3042\u308b\u30bb\u30eb\uff08G3\uff09\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_08\">\n<label id=\"pop-up_05_08--label\" for=\"pop-up_05_08\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/9d99018a103f7f0b4c21a24c428a6923.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"1\uff0e\u307e\u305a\u3001\u7d50\u679c\u5217\u306e\u4e00\u756a\u4e0a\u306b\u3042\u308b\u30bb\u30eb\uff08G3\uff09\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_08\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_08\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/9d99018a103f7f0b4c21a24c428a6923.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u8ad6\u7406\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cIFS\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_09\">\n<label id=\"pop-up_05_09--label\" for=\"pop-up_05_09\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/b02e2c12780ff9a88f0399c6635ccf82-1.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u8ad6\u7406\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cIFS\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_09\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_09\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/b02e2c12780ff9a88f0399c6635ccf82-1.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0e\u8ad6\u7406\u5f0f1\u306b\u306f1\u3064\u76ee\u306e\u6761\u4ef6\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br>\u5408\u8a08\u70b9\u3092\u57fa\u6e96\u306b\u5224\u65ad\u3059\u308b\u305f\u3081\u3001F3\u304b\u3089F22\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_10\">\n<label id=\"pop-up_05_10--label\" for=\"pop-up_05_10\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/42a2d2745013d39f4f8098d074bf2807.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"3\uff0e\u8ad6\u7406\u5f0f1\u306b\u306f1\u3064\u76ee\u306e\u6761\u4ef6\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u5408\u8a08\u70b9\u3092\u57fa\u6e96\u306b\u5224\u65ad\u3059\u308b\u305f\u3081\u3001F3\u304b\u3089F22\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_10\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_10\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/42a2d2745013d39f4f8098d074bf2807.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u8ad6\u7406\u5f0f1\u306e\u5165\u529b\u6b04\u306b\u300cF3:F22\u300d\u3068\u5165\u529b\u3055\u308c\u305f\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u305f\u3089\u3001\u305d\u306e\u5f8c\u306b\u7d9a\u3051\u3066\u300c&gt;=300\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_11\">\n<label id=\"pop-up_05_11--label\" for=\"pop-up_05_11\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/a68b712bc586b24dde15738e8e5b566e.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u8ad6\u7406\u5f0f1\u306e\u5165\u529b\u6b04\u306b\u300cF3:F22\u300d\u3068\u5165\u529b\u3055\u308c\u305f\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u305f\u3089\u3001\u305d\u306e\u5f8c\u306b\u7d9a\u3051\u3066\u300c&gt;=300\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_11\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_11\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/a68b712bc586b24dde15738e8e5b566e.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u5024\u304c\u771f\u306e\u5834\u54081\u306e\u5165\u529b\u6b04\u306b\u300c&#8221;\u3007&#8221;\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_12\">\n<label id=\"pop-up_05_12--label\" for=\"pop-up_05_12\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/766f418a59d1dea03368488872aa729b.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"4\uff0e\u5024\u304c\u771f\u306e\u5834\u54081\u306e\u5165\u529b\u6b04\u306b\u300c&quot;\u3007&quot;\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_12\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_12\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/766f418a59d1dea03368488872aa729b.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u3053\u306e\u5834\u5408\u3082\u300c&#8221;&#8221;\uff08\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\uff09\u300d\u306e\u5165\u529b\u3092\u5fd8\u308c\u306a\u3044\u3088\u3046\u6ce8\u610f\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>5\uff0e\u540c\u69d8\u306b\u3001\u8ad6\u7406\u5f0f2\u306e\u5165\u529b\u6b04\u306b\u306f2\u3064\u76ee\u306e\u6761\u4ef6\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u300cF3:F22&gt;=250\u300d\u3068\u5165\u529b\u3092\u884c\u3044\u3001\u5024\u304c\u771f\u306e\u5834\u54082\u306e\u5165\u529b\u6b04\u306b\u306f\u300c&#8221;\u25b3&#8221;\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_13\">\n<label id=\"pop-up_05_13--label\" for=\"pop-up_05_13\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/8110d077d5ff79ebf34e801e4daa51f7.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"5\uff0e\u540c\u69d8\u306b\u3001\u8ad6\u7406\u5f0f2\u306e\u5165\u529b\u6b04\u306b\u306f2\u3064\u76ee\u306e\u6761\u4ef6\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u300cF3:F22&gt;=250\u300d\u3068\u5165\u529b\u3092\u884c\u3044\u3001\u5024\u304c\u771f\u306e\u5834\u54082\u306e\u5165\u529b\u6b04\u306b\u306f\u300c&quot;\u25b3&quot;\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_13\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_13\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/8110d077d5ff79ebf34e801e4daa51f7.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u3053\u308c\u3067\u300cF3\u304b\u3089F22\u306e\u3046\u3061\u3001250\u70b9\u4ee5\u4e0a\u306e\u5834\u5408\u306f\u25b3\u3092\u8868\u793a\u3059\u308b\u300d\u3068\u3044\u3063\u305f\u610f\u5473\u306e\u6570\u5f0f\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>6\uff0e\u8ad6\u7406\u5f0f3\u306e\u5165\u529b\u6b04\u306b\u5165\u529b\u3059\u308b\u306e\u306f\u30013\u3064\u76ee\u306e\u6761\u4ef6\u3067\u3059\u3002\u300cF3:F22&lt;249\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_14\">\n<label id=\"pop-up_05_14--label\" for=\"pop-up_05_14\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/805d7a6082016b6fe905b7a36b72a444.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"6\uff0e\u8ad6\u7406\u5f0f3\u306e\u5165\u529b\u6b04\u306b\u5165\u529b\u3059\u308b\u306e\u306f\u30013\u3064\u76ee\u306e\u6761\u4ef6\u3067\u3059\u3002\u300cF3:F22<249\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_14\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_14\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/805d7a6082016b6fe905b7a36b72a444.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u3053\u308c\u3067\u300cF3\u304b\u3089F22\u306e\u3046\u3061\u3001249\u70b9\u672a\u6e80\u306e\u5834\u5408\u300d\u3092\u610f\u5473\u3059\u308b\u6570\u5f0f\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>7\uff0e\u5024\u304c\u771f\u306e\u5834\u54083\u306b\u306f\u300c&#8221;\u2715&#8221;\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<br>\u5165\u529b\u6b04\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408\u306f\u3001\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u5185\u306b\u3042\u308b\u30b9\u30af\u30ed\u30fc\u30eb\u30d0\u30fc\u3092\u5c11\u3057\u4e0b\u3052\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_15\">\n<label id=\"pop-up_05_15--label\" for=\"pop-up_05_15\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/d03e6f9044eedf9a2862c578939b8ed2.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"7\uff0e\u5024\u304c\u771f\u306e\u5834\u54083\u306b\u306f\u300c&quot;\u2715&quot;\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\u5165\u529b\u6b04\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408\u306f\u3001\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u5185\u306b\u3042\u308b\u30b9\u30af\u30ed\u30fc\u30eb\u30d0\u30fc\u3092\u5c11\u3057\u4e0b\u3052\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_15\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_15\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/d03e6f9044eedf9a2862c578939b8ed2.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>8\uff0eOK\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u306b\u3088\u308b\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_05_16\">\n<label id=\"pop-up_05_16--label\" for=\"pop-up_05_16\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/a1d020effa353c1e140129686fb29d10.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"8\uff0eOK\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u306b\u3088\u308b\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_05_16\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_05_16\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/a1d020effa353c1e140129686fb29d10.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n\n\n\n<h3 class=\"wp-block-heading\">6\uff0e\u3010COUNTIF\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cCOUNTIF\u300d\u306f\u8a2d\u5b9a\u3057\u305f\u6761\u4ef6\u3068\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u6570\u3092\u6c42\u3081\u308b\u95a2\u6570\u3067\u3059\u3002\u6307\u5b9a\u6570\u5024\u4ee5\u4e0a\u3068\u306a\u3063\u305f\u30c7\u30fc\u30bf\u5024\u3092\u6570\u3048\u308b\u969b\u306a\u3069\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u8a66\u9a13\u306e\u5408\u683c\u8005\u6570\u3092\u6c42\u3081\u305f\u3044<\/li>\n<li>\u6307\u5b9a\u3057\u305f\u5024\u3068\u5408\u3046\u6570\u3092\u6c42\u3081\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b<\/h4>\n\n\n\n<p>=COUNTIF(\u25b2:\u25bc,\u691c\u7d22\u6761\u4ef6)<br>\u4e0a\u8a18\u306fCOUNTIF\u95a2\u6570\u306e\u6570\u5f0f\u3067\u3059\u3002\u25b2\u25bc\u306b\u306f\u7bc4\u56f2\u306e\u958b\u59cb\u304a\u3088\u3073\u7d42\u4e86\u30bb\u30eb\u3092\u3001\u691c\u7d22\u6761\u4ef6\u306b\u306f\u7bc4\u56f2\u5185\u304b\u3089\u6570\u3048\u305f\u3044\u5024\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u8a66\u9a13\u7d50\u679c\u304b\u3089\u5408\u683c\u8005\u306e\u6570\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u5408\u683c\u4eba\u6570\u3092\u5165\u529b\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u305d\u306e\u4ed6\u306e\u95a2\u6570\u300f\u3092\u9078\u629e\u3057\u3001\u7d71\u8a08\u306e\u4e00\u89a7\u304b\u3089\u300cCOUNTIF\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<style>\n#pop-up_06_01,\n#pop-up_06_02,\n#pop-up_06_03,\n#pop-up_06_04\n{\n  display: none;\n}\n#pop-up_06_01:checked + .overlay,\n#pop-up_06_02:checked + .overlay,\n#pop-up_06_03:checked + .overlay,\n#pop-up_06_04:checked + .overlay\n{\n  visibility: visible;\n  opacity: 1;\n  z-index: 100000;\n  background-color: #000000D0;\n  width: 100%;\n  margin: 0;\n  max-width: initial;\n}\n<\/style>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_06_01\">\n<label id=\"pop-up_06_01--label\" for=\"pop-up_06_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/cec9dfd04b8544f2ff99ecfab242b301.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u305d\u306e\u4ed6\u306e\u95a2\u6570\u300f\u3092\u9078\u629e\u3057\u3001\u7d71\u8a08\u306e\u4e00\u89a7\u304b\u3089\u300cCOUNTIF\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_06_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_06_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/cec9dfd04b8544f2ff99ecfab242b301.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0e\u7bc4\u56f2\u306e\u5165\u529b\u6b04\u306bG3:G22\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_06_02\">\n<label id=\"pop-up_06_02--label\" for=\"pop-up_06_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/31510ae10149ff15f22141982be953d3.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"3\uff0e\u7bc4\u56f2\u306e\u5165\u529b\u6b04\u306bG3:G22\u3068\u5165\u529b\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_06_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_06_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/31510ae10149ff15f22141982be953d3.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u5408\u683c\u8005\u306e\u6570\u3092\u6c42\u3081\u308b\u306e\u3067\u3001\u691c\u7d22\u6761\u4ef6\u306f&#8221;\u3007&#8221;\u3092\u5165\u529b\u3057\u3066OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_06_03\">\n<label id=\"pop-up_06_03--label\" for=\"pop-up_06_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/21e9fe2fd7244477d49fcd59e7d7764e.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"4\uff0e\u5408\u683c\u8005\u306e\u6570\u3092\u6c42\u3081\u308b\u306e\u3067\u3001\u691c\u7d22\u6761\u4ef6\u306f&quot;\u3007&quot;\u3092\u5165\u529b\u3057\u3066OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_06_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_06_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/21e9fe2fd7244477d49fcd59e7d7764e.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>5\uff0e\u6570\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_06_04\">\n<label id=\"pop-up_06_04--label\" for=\"pop-up_06_04\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/475c57553fedd20dbf2e87f0658a33cd.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"5\uff0e\u6570\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_06_04\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_06_04\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/475c57553fedd20dbf2e87f0658a33cd.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">7\uff0e\u3010MAX\u30fbMIN\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cMAX\u95a2\u6570\u300d\u306f\u6700\u5927\u5024\u3092\u300cMIN\u95a2\u6570\u300d\u306f\u6700\u5c0f\u5024\u3092\u6c42\u3081\u308b\u95a2\u6570\u3067\u3059\u3002\u8907\u6570\u306e\u6570\u5024\u30c7\u30fc\u30bf\u304b\u3089\u6700\u5927\u5024\u3084\u6700\u5c0f\u5024\u3092\u6c42\u3081\u308b\u969b\u306b\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u58f2\u4e0a\u984d\u306e\u6700\u5927\u5024\u3001\u307e\u305f\u306f\u6700\u5c0f\u5024\u3092\u6c42\u3081\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b\u3010MAX\u3011<\/h4>\n\n\n\n<p>=MAX(\u25b2:\u25bc)<br>\u4e0a\u8a18\u306fMAX\u95a2\u6570\u306e\u6570\u5f0f\u3067\u3059\u3002\u25b2\u25bc\u306b\u306f\u7bc4\u56f2\u306e\u958b\u59cb\u304a\u3088\u3073\u7d42\u4e86\u30bb\u30eb\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u5408\u8a08\u70b9\u306e\u7bc4\u56f2\u304b\u3089\u6700\u5927\u5024\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u6700\u5927\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u3001H5\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<style>\n#pop-up_07_01,\n#pop-up_07_02,\n#pop-up_07_03,\n#pop-up_07_04,\n#pop-up_07_05,\n#pop-up_07_06,\n#pop-up_07_07,\n#pop-up_07_08\n{\n  display: none;\n}\n#pop-up_07_01:checked + .overlay,\n#pop-up_07_02:checked + .overlay,\n#pop-up_07_03:checked + .overlay,\n#pop-up_07_04:checked + .overlay,\n#pop-up_07_05:checked + .overlay,\n#pop-up_07_06:checked + .overlay,\n#pop-up_07_07:checked + .overlay,\n#pop-up_07_08:checked + .overlay\n{\n  visibility: visible;\n  opacity: 1;\n  z-index: 100000;\n  background-color: #000000D0;\n  width: 100%;\n  margin: 0;\n  max-width: initial;\n}\n<\/style>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_07_01\">\n<label id=\"pop-up_07_01--label\" for=\"pop-up_07_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/d59a24acd20aa06429bbdd131e72c277.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"1\uff0e\u6700\u5927\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u3001H5\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_07_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_07_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/d59a24acd20aa06429bbdd131e72c277.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u30aa\u30fc\u30c8SUM\u300f\u3092\u9078\u629e\u3057\u3001\u6700\u5927\u5024\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30aa\u30fc\u30c8SUM\u306f\u03a3\u30de\u30fc\u30af\u304c\u76ee\u5370\u3067\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_07_02\">\n<label id=\"pop-up_07_02--label\" for=\"pop-up_07_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/6033092983f8cdd26ff55317f1cf392e.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u30aa\u30fc\u30c8SUM\u300f\u3092\u9078\u629e\u3057\u3001\u6700\u5927\u5024\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30aa\u30fc\u30c8SUM\u306f\u03a3\u30de\u30fc\u30af\u304c\u76ee\u5370\u3067\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_07_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_07_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/6033092983f8cdd26ff55317f1cf392e.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0eF3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001F22\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_07_03\">\n<label id=\"pop-up_07_03--label\" for=\"pop-up_07_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/893553aa2ae51f08eda3c0f8b09844c5.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"3\uff0eF3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001F22\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_07_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_07_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/893553aa2ae51f08eda3c0f8b09844c5.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u6570\u5f0f\u30d0\u30fc\u3001\u307e\u305f\u306fH5\u30bb\u30eb\u306b\u300c=MAX(F3:F22)\u300d\u3068\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u305f\u3089\u3001Enter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>5\uff0e\u6700\u5927\u5024\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_07_04\">\n<label id=\"pop-up_07_04--label\" for=\"pop-up_07_04\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/ebc74cb1648e374ed6c125c40d311cb1-1.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"5\uff0e\u6700\u5927\u5024\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_07_04\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_07_04\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/ebc74cb1648e374ed6c125c40d311cb1-1.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u306a\u304a\u3001\u6570\u5f0f\u3092\u9593\u9055\u308f\u305a\u306b\u5165\u529b\u3067\u304d\u308b\u5834\u5408\u306f\u3001H5\u30bb\u30eb\u306b\u76f4\u63a5\u300c=MAX(F3:F22)\u300d\u3068\u5165\u529b\u3057\u3001Enter\u30ad\u30fc\u3092\u62bc\u3059\u3053\u3068\u3067\u3082\u540c\u69d8\u306e\u51e6\u7406\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b\u3010MIN\u3011<\/h4>\n\n\n\n<p>=MIN(\u25b2:\u25bc)<br>\u4e0a\u8a18\u306fMIN\u95a2\u6570\u306e\u6570\u5f0f\u3067\u3059\u3002\u25b2\u25bc\u306b\u306f\u7bc4\u56f2\u306e\u958b\u59cb\u304a\u3088\u3073\u7d42\u4e86\u30bb\u30eb\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u5408\u8a08\u70b9\u306e\u7bc4\u56f2\u304b\u3089\u6700\u5c0f\u5024\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u6700\u5c0f\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u3001H7\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_07_05\">\n<label id=\"pop-up_07_05--label\" for=\"pop-up_07_05\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/068e8987a40715ad6a4892b69ec84e5d.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"1\uff0e\u6700\u5c0f\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u3001H7\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_07_05\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_07_05\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/068e8987a40715ad6a4892b69ec84e5d.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u30aa\u30fc\u30c8SUM\u3092\u9078\u629e\u3057\u3001\u6700\u5c0f\u5024\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30aa\u30fc\u30c8SUM\u306f\u03a3\u30de\u30fc\u30af\u304c\u76ee\u5370\u3067\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_07_06\">\n<label id=\"pop-up_07_06--label\" for=\"pop-up_07_06\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/cb9888ed47cdd74f661a7fd6c10317ae.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u30aa\u30fc\u30c8SUM\u3092\u9078\u629e\u3057\u3001\u6700\u5c0f\u5024\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30aa\u30fc\u30c8SUM\u306f\u03a3\u30de\u30fc\u30af\u304c\u76ee\u5370\u3067\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_07_06\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_07_06\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/cb9888ed47cdd74f661a7fd6c10317ae.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0eF3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001F22\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_07_07\">\n<label id=\"pop-up_07_07--label\" for=\"pop-up_07_07\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/c5c1d11e67f76a977739be9d4e606a05.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"3\uff0eF3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001F22\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_07_07\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_07_07\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/c5c1d11e67f76a977739be9d4e606a05.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u6570\u5f0f\u30d0\u30fc\u3001\u307e\u305f\u306fH7\u30bb\u30eb\u306b\u300c=MIN(F3:F22)\u300d\u3068\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u305f\u3089\u3001Enter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>5\uff0e\u6700\u5c0f\u5024\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_07_08\">\n<label id=\"pop-up_07_08--label\" for=\"pop-up_07_08\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/be20a4ab021795cd85a54f3e718b4870.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"4\uff0e\u6570\u5f0f\u30d0\u30fc\u3001\u307e\u305f\u306fH7\u30bb\u30eb\u306b\u300c=MIN(F3:F22)\u300d\u3068\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u305f\u3089\u3001Enter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_07_08\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_07_08\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/be20a4ab021795cd85a54f3e718b4870.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">8\uff0e\u3010VLOOKUP\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cVLOOKUP\u95a2\u6570\u300d\u306f\u3001\u6307\u5b9a\u7bc4\u56f2\u5185\u304b\u3089\u8a2d\u5b9a\u6761\u4ef6\u306b\u5f53\u3066\u306f\u307e\u308b\u5024\u3092\u6c42\u3081\u308b\u969b\u306b\u4f7f\u7528\u3059\u308b\u95a2\u6570\u3067\u3059\u3002\u3053\u306e\u95a2\u6570\u306b\u306f\u3001\u691c\u7d22\u5024\u306b\u6307\u5b9a\u3059\u308b\u5024\u304c\u5de6\u7aef\u5217\u306b\u306a\u3044\u3068\u3001\u30a8\u30e9\u30fc\u304c\u8d77\u304d\u308b\u3068\u3044\u3063\u305f\u6ce8\u610f\u70b9\u304c\u3042\u308a\u307e\u3059\u3002<br>\u6761\u4ef6\u8a2d\u5b9a\u306b\u7528\u3044\u308b\u8868\u306a\u3069\u306f\u3001\u5fc5\u305aA\u5217\u304b\u3089\u59cb\u307e\u308b\u3088\u3046\u306b\u8abf\u6574\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u5224\u65ad\u57fa\u6e96\u8868\u3092\u3082\u3068\u306b\u3001\u6210\u7e3e\u3092\u30e9\u30f3\u30af\u4ed8\u3051\u3057\u305f\u3044<\/li>\n<li>\u8a2d\u5b9a\u3057\u305f\u57fa\u6e96\u3092\u3082\u3068\u306b\u3001\u8a55\u4fa1\u3092\u884c\u3044\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b<\/h4>\n\n\n\n<p>=VLOOKUP(\u691c\u7d22\u5024,\u30bb\u30eb\u7bc4\u56f2,\u5217\u756a\u53f7,\u691c\u7d22\u65b9\u6cd5)<br>\u4e0a\u8a18\u304c\u300cVLOOKUP\u95a2\u6570\u300d\u306e\u6570\u5f0f\u3067\u3059\u30024\u3064\u76ee\u306b\u5165\u529b\u3059\u308b\u300c\u691c\u7d22\u65b9\u6cd5\u300d\u306b\u6307\u5b9a\u3059\u308b\u5024\u306f\u300eTRUE\uff1a\u8fd1\u3044\u5024\u3092\u63a2\u3059\u300f\u300eFALSE\uff1a\u5b8c\u5168\u4e00\u81f4\u3092\u63a2\u3059\u300f\u306e2\u3064\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u5408\u8a08\u70b9\u3092\u3082\u3068\u306b\u8a55\u4fa1\u57fa\u6e96\u3068\u5408\u81f4\u3059\u308b\u5024\u3092\u6c42\u3081\u307e\u3059\u3002<br>1\uff0e\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u3001C3\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<style>\n#pop-up_08_01,\n#pop-up_08_02,\n#pop-up_08_03,\n#pop-up_08_04,\n#pop-up_08_05,\n#pop-up_08_06,\n#pop-up_08_07,\n#pop-up_08_08,\n#pop-up_08_09\n{\n  display: none;\n}\n#pop-up_08_01:checked + .overlay,\n#pop-up_08_02:checked + .overlay,\n#pop-up_08_03:checked + .overlay,\n#pop-up_08_04:checked + .overlay,\n#pop-up_08_05:checked + .overlay,\n#pop-up_08_06:checked + .overlay,\n#pop-up_08_07:checked + .overlay,\n#pop-up_08_08:checked + .overlay,\n#pop-up_08_09:checked + .overlay\n{\n  visibility: visible;\n  opacity: 1;\n  z-index: 100000;\n  background-color: #000000D0;\n  width: 100%;\n  margin: 0;\n  max-width: initial;\n}\n<\/style>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_08_01\">\n<label id=\"pop-up_08_01--label\" for=\"pop-up_08_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/047ebdbd026b93750c75f93e55083ecd.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"1\uff0e\u5024\u3092\u5165\u529b\u3057\u305f\u3044\u3001C3\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_08_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_08_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/047ebdbd026b93750c75f93e55083ecd.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u691c\u7d22\/\u884c\u5217\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cVLOOKUP\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_08_02\">\n<label id=\"pop-up_08_02--label\" for=\"pop-up_08_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/df31ca09a397ef6b1f4c75613bed717c.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u691c\u7d22\/\u884c\u5217\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cVLOOKUP\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_08_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_08_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/df31ca09a397ef6b1f4c75613bed717c.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0e\u5408\u8a08\u70b9\u3092\u3082\u3068\u306b\u5224\u65ad\u3059\u308b\u305f\u3081\u3001\u691c\u7d22\u5024\u306e\u5165\u529b\u6b04\u306b\u306f\u300cB3\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_08_03\">\n<label id=\"pop-up_08_03--label\" for=\"pop-up_08_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/e1316b953e5dea549b7baf0ea874ed91.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"3\uff0e\u5408\u8a08\u70b9\u3092\u3082\u3068\u306b\u5224\u65ad\u3059\u308b\u305f\u3081\u3001\u691c\u7d22\u5024\u306e\u5165\u529b\u6b04\u306b\u306f\u300cB3\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_08_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_08_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/e1316b953e5dea549b7baf0ea874ed91.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u7bc4\u56f2\u306e\u5165\u529b\u6b04\u3067\u306f\u3001\u8a55\u4fa1\u57fa\u6e96\u306e\u8868\u5168\u4f53\u3092\u6307\u5b9a\u3059\u308b\u305f\u3081\u3001A14\u30bb\u30eb\u304b\u3089E18\u30bb\u30eb\u307e\u3067\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_08_04\">\n<label id=\"pop-up_08_04--label\" for=\"pop-up_08_04\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/aff258132933f299f5777b73ad93ad0a.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"4\uff0e\u7bc4\u56f2\u306e\u5165\u529b\u6b04\u3067\u306f\u3001\u8a55\u4fa1\u57fa\u6e96\u306e\u8868\u5168\u4f53\u3092\u6307\u5b9a\u3059\u308b\u305f\u3081\u3001A14\u30bb\u30eb\u304b\u3089E18\u30bb\u30eb\u307e\u3067\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_08_04\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_08_04\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/aff258132933f299f5777b73ad93ad0a.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u3053\u306e\u6642\u3001\u7bc4\u56f2\u304b\u3089\u57fa\u6e96\u306e\u8868\u304c\u30ba\u30ec\u306a\u3044\u3088\u3046\u306b\u3001\u7d76\u5bfe\u53c2\u7167\u3092\u884c\u3044\u307e\u3059\u3002<br>\u5165\u529b\u6b04\u306eA14:E18\u3092\u5168\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_08_05\">\n<label id=\"pop-up_08_05--label\" for=\"pop-up_08_05\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/1f6cf898a09ce79ee0cdcc8333cc5295.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"\u3053\u306e\u6642\u3001\u7bc4\u56f2\u304b\u3089\u57fa\u6e96\u306e\u8868\u304c\u30ba\u30ec\u306a\u3044\u3088\u3046\u306b\u3001\u7d76\u5bfe\u53c2\u7167\u3092\u884c\u3044\u307e\u3059\u3002\u5165\u529b\u6b04\u306eA14:E18\u3092\u5168\u9078\u629e\u3057\u3001F4\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_08_05\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_08_05\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/1f6cf898a09ce79ee0cdcc8333cc5295.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>5\uff0e\u5217\u756a\u53f7\u306f\u3001\u7bc4\u56f2\u5165\u529b\u3057\u305f\u8868\u306e\u4f55\u5217\u76ee\u3092\u57fa\u6e96\u3068\u3059\u308b\u304b\u3001\u3068\u3044\u3063\u305f\u6761\u4ef6\u6307\u5b9a\u3067\u3059\u3002<br>\u4e00\u81f4\u3059\u308b\u884c\u306e5\u5217\u76ee\u304b\u3089\u5024\u3092\u53d6\u308a\u51fa\u3059\u305f\u3081\u3001\u8a55\u4fa1\u5217\u306e\u756a\u53f7\u300c5\u300d\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_08_06\">\n<label id=\"pop-up_08_06--label\" for=\"pop-up_08_06\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/76ec493899778cb0d2cca41f1544983c.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"5\uff0e\u5217\u756a\u53f7\u306f\u3001\u7bc4\u56f2\u5165\u529b\u3057\u305f\u8868\u306e\u4f55\u5217\u76ee\u3092\u57fa\u6e96\u3068\u3059\u308b\u304b\u3001\u3068\u3044\u3063\u305f\u6761\u4ef6\u6307\u5b9a\u3067\u3059\u3002\u4e00\u81f4\u3059\u308b\u884c\u306e5\u5217\u76ee\u304b\u3089\u5024\u3092\u53d6\u308a\u51fa\u3059\u305f\u3081\u3001\u8a55\u4fa1\u5217\u306e\u756a\u53f7\u300c5\u300d\u3092\u5165\u529b\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_08_06\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_08_06\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/76ec493899778cb0d2cca41f1544983c.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>6\uff0e\u691c\u7d22\u65b9\u6cd5\u306b\u306f\u3001\u691c\u7d22\u5024\u306e\u8fd1\u4f3c\u5024\u304b\u3089\u3082\u691c\u7d22\u3057\u3066\u3082\u3089\u3046\u305f\u3081\u300cTRUE\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_08_07\">\n<label id=\"pop-up_08_07--label\" for=\"pop-up_08_07\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/27677f29a95db4a1221511d7b26a31ee.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"6\uff0e\u691c\u7d22\u65b9\u6cd5\u306b\u306f\u3001\u691c\u7d22\u5024\u306e\u8fd1\u4f3c\u5024\u304b\u3089\u3082\u691c\u7d22\u3057\u3066\u3082\u3089\u3046\u305f\u3081\u300cTRUE\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_08_07\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_08_07\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/27677f29a95db4a1221511d7b26a31ee.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>7\uff0eOK\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u306b\u3088\u308b\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_08_08\">\n<label id=\"pop-up_08_08--label\" for=\"pop-up_08_08\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/c25597180f09999f71d0dd03c8329a19.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"7\uff0eOK\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u306b\u3088\u308b\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_08_08\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_08_08\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/c25597180f09999f71d0dd03c8329a19.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>8\uff0eC3\u30bb\u30eb\u306b\u53cd\u6620\u3055\u308c\u305f\u3089\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u6a5f\u80fd\u3067C4\u304b\u3089C10\u30bb\u30eb\u306b\u3082\u53cd\u6620\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_08_09\">\n<label id=\"pop-up_08_09--label\" for=\"pop-up_08_09\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/6df9978716bbf4422aff072c8de24ec1.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"8\uff0eC3\u30bb\u30eb\u306b\u53cd\u6620\u3055\u308c\u305f\u3089\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u6a5f\u80fd\u3067C4\u304b\u3089C10\u30bb\u30eb\u306b\u3082\u53cd\u6620\u3057\u307e\u3057\u3087\u3046\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_08_09\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_08_09\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/6df9978716bbf4422aff072c8de24ec1.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">8-1\uff0e\u3010XLOOKUP\u95a2\u6570\u3011<\/h4>\n\n\n\n<p>\u300cXLOOKUP\u95a2\u6570\u300d\u3068\u306f\u3001\u5148\u306b\u3054\u7d39\u4ecb\u3057\u305f\u300cVLOOKUP\u95a2\u6570\u300d\u306e\u9032\u5316\u7248\u3068\u3082\u3044\u3048\u308b\u3001\u65b0\u3057\u3044\u95a2\u6570\u3067\u3059\u3002\u300cOffice2021\u300d\u304b\u3089\u642d\u8f09\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u3001\u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f3\u578b\u300cMicrosoft365\u300d\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u3082\u642d\u8f09\u3055\u308c\u3066\u3044\u308b\u3067\u3057\u3087\u3046\u3002<br>\u300cVLOOKUP\u95a2\u6570\u300d\u3068\u306e\u9055\u3044\u306f\u3001\u5de6\u7aef\u306b\u9650\u3089\u305a\u691c\u7d22\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u3063\u305f\u70b9\u3067\u3059\u3002<br>\u9023\u7d9a\u3057\u305f\u30bb\u30eb\u3067\u3042\u308c\u3070\u3001\u3072\u3068\u3064\u306e\u6570\u5f0f\u3067\u540c\u6642\u306b\u5024\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3057\u305f\u3002<br>\u3053\u306e\u95a2\u6570\u306f\u300cVLOOKUP\u300d\u3068\u540c\u3058\u304f\u3001Excel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u691c\u7d22\/\u884c\u5217\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u9078\u629e\u3059\u308b\u3053\u3068\u3067\u4f7f\u7528\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">9\uff0e\u3010ROW\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cROW\u95a2\u6570\u300d\u306f\u3001\u6307\u5b9a\u3057\u305f\u884c\u756a\u53f7\u306e\u6570\u5024\u3092\u8868\u793a\u3055\u305b\u308b\u969b\u306b\u4f7f\u7528\u3059\u308b\u95a2\u6570\u3067\u3059\u3002\u884c\u306e\u8ffd\u52a0\u30fb\u524a\u9664\u3057\u3066\u3082\u756a\u53f7\u304c\u30ba\u30ec\u305f\u308a\u98db\u3093\u3060\u308a\u3057\u306a\u3044\u8868\u306e\u4f5c\u6210\u304c\u53ef\u80fd\u3067\u3059\u3002<br>\u307e\u305f\u3001\u3053\u306e\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u756a\u53f7\u3092\u632f\u3063\u305f\u5834\u5408\u306f\u3001\u9014\u4e2d\u306e\u884c\u3092\u524a\u9664\u3057\u3066\u3082\u81ea\u52d5\u3067\u632f\u308a\u76f4\u3055\u308c\u307e\u3059\u3002\u756a\u53f7\u3092\u98db\u3070\u3059\u3053\u3068\u304c\u306a\u3044\u305f\u3081\u3001\u81a8\u5927\u306a\u30c7\u30fc\u30bf\u91cf\u3092\u6574\u7406\u3059\u308b\u969b\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u6253\u3061\u8fbc\u3093\u3060\u30ea\u30b9\u30c8\u3092\u30ca\u30f3\u30d0\u30ea\u30f3\u30b0\u3057\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b<\/h4>\n\n\n\n<p>=ROW()<br>\u4e0a\u8a18\u304c\u300cROW\u95a2\u6570\u300d\u306e\u6570\u5f0f\u3067\u3059\u3002\u5217\u756a\u53f7\u3068\u306f\u7570\u306a\u308b\u6570\u5b57\u3092\u8868\u793a\u3055\u305b\u308b\u5834\u5408\u306f\u3001\u3053\u306e\u6570\u5f0f\u306e\u5f8c\u306b\u6570\u5b57\u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u4f8b\u3067\u306f\u3001\u5217\u756a\u53f7\u3068\u7570\u306a\u308b\u5834\u5408\u306e\u5165\u529b\u4f8b\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<br>1\uff0e\u5217\u756a\u53f7\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u3001B3\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<style>\n#pop-up_09_01,\n#pop-up_09_02,\n#pop-up_09_03,\n#pop-up_09_04,\n#pop-up_09_05,\n#pop-up_09_06\n{\n  display: none;\n}\n#pop-up_09_01:checked + .overlay,\n#pop-up_09_02:checked + .overlay,\n#pop-up_09_03:checked + .overlay,\n#pop-up_09_04:checked + .overlay,\n#pop-up_09_05:checked + .overlay,\n#pop-up_09_06:checked + .overlay\n{\n  visibility: visible;\n  opacity: 1;\n  z-index: 100000;\n  background-color: #000000D0;\n  width: 100%;\n  margin: 0;\n  max-width: initial;\n}\n<\/style>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_09_01\">\n<label id=\"pop-up_09_01--label\" for=\"pop-up_09_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/cc05df13dd4dbbd0335e25d5288f5d47.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"1\uff0e\u5217\u756a\u53f7\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u3001B3\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_09_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_09_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/cc05df13dd4dbbd0335e25d5288f5d47.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u691c\u7d22\/\u884c\u5217\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cROW\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_09_02\">\n<label id=\"pop-up_09_02--label\" for=\"pop-up_09_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/206e9097cfc8c22c4aa85e5c48a5add1.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u691c\u7d22\/\u884c\u5217\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cROW\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_09_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_09_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/206e9097cfc8c22c4aa85e5c48a5add1.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0e\u95a2\u6570\u306e\u5f15\u6570\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u304c\u3001\u4f55\u3082\u5165\u529b\u305b\u305a\u3001OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br>\u3053\u306e\u6642\u30bb\u30eb\u3092\u9078\u629e\u3057\u306a\u3044\u3088\u3046\u6ce8\u610f\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_09_03\">\n<label id=\"pop-up_09_03--label\" for=\"pop-up_09_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/99e290d6f0e33cc8c2fe6a5181eeb5a8.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"3\uff0e\u95a2\u6570\u306e\u5f15\u6570\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u304c\u3001\u4f55\u3082\u5165\u529b\u305b\u305a\u3001OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u3053\u306e\u6642\u30bb\u30eb\u3092\u9078\u629e\u3057\u306a\u3044\u3088\u3046\u6ce8\u610f\u3057\u307e\u3057\u3087\u3046\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_09_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_09_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/99e290d6f0e33cc8c2fe6a5181eeb5a8.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0e\u4eca\u56de\u306e\u4f8b\u3067\u306f\u3001\u5217\u756a\u53f7\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u30bb\u30eb\u306f\u4e0a\u304b\u30893\u756a\u76ee\u306b\u3042\u305f\u308a\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001B3\u30bb\u30eb\u306b\u306f\u300c3\u300d\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002<br>\u6570\u5f0f\u30d0\u30fc\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u6570\u5f0f\u306e\u5f8c\u306b\u300c-2\u300d\u3068\u5165\u529b\u3057\u3001Enter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_09_04\">\n<label id=\"pop-up_09_04--label\" for=\"pop-up_09_04\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/e25340048ac5d70b869e7762d534bae5.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"4\uff0e\u4eca\u56de\u306e\u4f8b\u3067\u306f\u3001\u5217\u756a\u53f7\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u30bb\u30eb\u306f\u4e0a\u304b\u30893\u756a\u76ee\u306b\u3042\u305f\u308a\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001B3\u30bb\u30eb\u306b\u306f\u300c3\u300d\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u6570\u5f0f\u30d0\u30fc\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u6570\u5f0f\u306e\u5f8c\u306b\u300c-2\u300d\u3068\u5165\u529b\u3057\u3001Enter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_09_04\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_09_04\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/e25340048ac5d70b869e7762d534bae5.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>5\uff0eB3\u30bb\u30eb\u5185\u306b\u300c1\u300d\u3068\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u305f\u3089\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067\u4e0b\u306e\u30bb\u30eb\u306b\u3082\u53cd\u6620\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_09_05\">\n<label id=\"pop-up_09_05--label\" for=\"pop-up_09_05\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/2b8498b069873ebbf3758a668b54cd89.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"5\uff0eB3\u30bb\u30eb\u5185\u306b\u300c1\u300d\u3068\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u305f\u3089\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067\u4e0b\u306e\u30bb\u30eb\u306b\u3082\u53cd\u6620\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_09_05\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_09_05\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/2b8498b069873ebbf3758a668b54cd89.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>6\uff0e\u5217\u756a\u53f7\u3092\u632f\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_09_06\">\n<label id=\"pop-up_09_06--label\" for=\"pop-up_09_06\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/821a9dcbdef555573037d56276180363.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"6\uff0e\u5217\u756a\u53f7\u3092\u632f\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_09_06\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_09_06\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/821a9dcbdef555573037d56276180363.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u306a\u304a\u3001\u5217\u756a\u53f7\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u30bb\u30eb\u304c1\u756a\u76ee\u306b\u3042\u308b\u5834\u5408\u306f\u3001\u4f55\u3082\u5165\u529b\u305b\u305aOK\u3092\u30af\u30ea\u30c3\u30af\u3057\u305f\u6bb5\u968e\u3067\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u306a\u3069\u306e\u52d5\u4f5c\u3092\u884c\u3063\u3066\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<br>\u5165\u529b\u5185\u5bb9\u306f\u3001\u8868\u793a\u3055\u305b\u305f\u3044\u30bb\u30eb\u306b\u5408\u308f\u305b\u3066\u8abf\u6574\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">10\uff0e\u3010DATE\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u300cDATE\u95a2\u6570\u300d\u306f\u3001\u5e74\u6708\u65e5\u3092\u5165\u529b\u307e\u305f\u306f\u30bb\u30eb\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u65e5\u4ed8\u30c7\u30fc\u30bf\u306e\u4f5c\u6210\u30fb\u6574\u7406\u3092\u884c\u3063\u3066\u304f\u308c\u308b\u95a2\u6570\u3067\u3059\u3002\u5225\u3005\u306e\u30bb\u30eb\u306b\u5165\u529b\u3055\u308c\u305f\u5e74\u6708\u65e5\u3092\u6574\u7406\u3057\u305f\u308a\u3001\u65e5\u4ed8\u8868\u8a18\u3092\u30b7\u30f3\u30d7\u30eb\u306b\u307e\u3068\u3081\u305f\u308a\u3059\u308b\u969b\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"flame\">\n<li style=\"list-style: none; position: relative; left: -1rem;\">\u6d3b\u7528\u3067\u304d\u308b\u30b7\u30fc\u30f3<\/li>\n<li>\u8a18\u5165\u5f8c\u306e\u5e74\u6708\u65e5\u3092\u6574\u7406\u3057\u305f\u3044<\/li>\n<li>\u65e5\u4ed8\u8868\u8a18\u3092\u307e\u3068\u3081\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5165\u529b\u4f8b<\/h4>\n\n\n\n<p>=DATE([\u5e74],[\u6708],[\u65e5])<br>\u4e0a\u8a18\u304c\u300cDATE\u95a2\u6570\u300d\u306e\u6570\u5f0f\u3067\u3059\u3002\u5e74\u3001\u6708\u3001\u65e5\u3001\u305d\u308c\u305e\u308c\u306e\u5024\u3092\u9806\u306b\u5165\u529b\u3057\u3066\u8a08\u7b97\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u5165\u529b\u4f8b\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>1\uff0e\u65e5\u4ed8\u3092\u307e\u3068\u3081\u305f\u3044\u3001E3\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<style>\n#pop-up_10_01,\n#pop-up_10_02,\n#pop-up_10_03,\n#pop-up_10_04,\n#pop-up_10_05\n{\n  display: none;\n}\n#pop-up_10_01:checked + .overlay,\n#pop-up_10_02:checked + .overlay,\n#pop-up_10_03:checked + .overlay,\n#pop-up_10_04:checked + .overlay,\n#pop-up_10_05:checked + .overlay\n{\n  visibility: visible;\n  opacity: 1;\n  z-index: 100000;\n  background-color: #000000D0;\n  width: 100%;\n  margin: 0;\n  max-width: initial;\n}\n<\/style>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_10_01\">\n<label id=\"pop-up_10_01--label\" for=\"pop-up_10_01\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/8af955d1c0780108a87c1e4404280eab.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"1\uff0e\u65e5\u4ed8\u3092\u307e\u3068\u3081\u305f\u3044\u3001E3\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_10_01\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_10_01\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/8af955d1c0780108a87c1e4404280eab.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u65e5\u4ed8\/\u6642\u523b\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cDATE\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_10_02\">\n<label id=\"pop-up_10_02--label\" for=\"pop-up_10_02\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/bfa918d0db75e8b2e7a6bd3227bf934f.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"2\uff0eExcel\u30d6\u30c3\u30af\u5185\u306b\u3042\u308b\u6570\u5f0f\u30bf\u30d6\u304b\u3089\u300e\u65e5\u4ed8\/\u6642\u523b\u300f\u3092\u9078\u629e\u3057\u3001\u4e00\u89a7\u304b\u3089\u300cDATE\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_10_02\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_10_02\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/bfa918d0db75e8b2e7a6bd3227bf934f.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>3\uff0e\u5e74\u306e\u5165\u529b\u6b04\u306fB3\u3001\u6708\u306e\u5165\u529b\u6b04\u306fC3\u3001\u65e5\u306e\u5165\u529b\u6b04\u306fD3\u3068\u305d\u308c\u305e\u308c\u306e\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_10_03\">\n<label id=\"pop-up_10_03--label\" for=\"pop-up_10_03\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/84aebcfbba4593310e567a078c1aecfb.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"3\uff0e\u5e74\u306e\u5165\u529b\u6b04\u306fB3\u3001\u6708\u306e\u5165\u529b\u6b04\u306fC3\u3001\u65e5\u306e\u5165\u529b\u6b04\u306fD3\u3068\u305d\u308c\u305e\u308c\u306e\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_10_03\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_10_03\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/84aebcfbba4593310e567a078c1aecfb.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>4\uff0eOK\u3092\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306fEnter\u30ad\u30fc\u3092\u62bc\u3059\u3068\u3001\u65e5\u4ed8\u6b04\u306b\u307e\u3068\u3081\u305f\u5024\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_10_04\">\n<label id=\"pop-up_10_04--label\" for=\"pop-up_10_04\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/140f5f96451a99917a9ac781d91e9086.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"4\uff0eOK\u3092\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306fEnter\u30ad\u30fc\u3092\u62bc\u3059\u3068\u3001\u65e5\u4ed8\u6b04\u306b\u307e\u3068\u3081\u305f\u5024\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_10_04\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_10_04\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/140f5f96451a99917a9ac781d91e9086.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<p>\u78ba\u8a8d\u3067\u304d\u305f\u3089\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067\u4e0b\u306e\u30bb\u30eb\u306b\u3082\u53cd\u6620\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>5\uff0e\u65e5\u4ed8\u306e\u6574\u7406\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<input type=\"checkbox\" id=\"pop-up_10_05\">\n<label id=\"pop-up_10_05--label\" for=\"pop-up_10_05\" class=\"overlay\">\n  <label class=\"popWindow\">\n    <div class=\"ptitle\"><img decoding=\"async\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/3b7d06fd45313839e3c446e127c05aa2.png\" rel=\"noopener\" target=\"_blank\"\u3000alt=\"5\uff0e\u65e5\u4ed8\u306e\u6574\u7406\u304c\u3067\u304d\u307e\u3057\u305f\u3002\" class=\"wp-image-24145\"><\/div><label class=\"close\" for=\"pop-up_10_05\">\u00d7<\/label>\n<\/label>\n<\/label>\n<div class=\"c\">\n  <label for=\"pop-up_10_05\">\n    <img decoding=\"async\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/www.seraku.co.jp\/tectec-note\/wp-content\/uploads\/3b7d06fd45313839e3c446e127c05aa2.png\" alt=\"\" width=\"550\" height=\"318\"  \/>\n  <\/label>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u307e\u3068\u3081<\/h2>\n\n\n\n<p>\u57fa\u672c\u7684\u306aExcel\u95a2\u6570\u309210\u500b\u3001\u3054\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002Excel\u95a2\u6570\u306f\u7d04500\u500b\u3082\u306e\u7a2e\u985e\u304c\u3042\u308a\u3001\u3053\u3053\u3067\u3054\u7d39\u4ecb\u3057\u305f\u95a2\u6570\u306f\u307b\u3093\u306e\u4e00\u90e8\u3067\u3059\u3002\u95a2\u308f\u308b\u696d\u52d9\u306b\u3088\u3063\u3066\u306f\u3001\u57fa\u672c\u306e\u95a2\u6570\u3092\u306f\u3058\u3081\u3068\u3057\u305f\u3001\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\u306b\u89e6\u308c\u3066\u899a\u3048\u3066\u3044\u304f\u3053\u3068\u3082\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<br>Excel\u306f\u696d\u52d9\u3067\u4f7f\u7528\u3059\u308b\u3053\u3068\u306e\u591a\u3044\u30c4\u30fc\u30eb\u3067\u3042\u308a\u3001Excel\u3084Word\u306a\u3069\u306e\u30c4\u30fc\u30eb\u304c\u4f7f\u3048\u308b\u524d\u63d0\u3067\u6c42\u4eba\u3092\u52df\u308b\u4f01\u696d\u3082\u591a\u3044\u50be\u5411\u306b\u3042\u308a\u307e\u3059\u3002\u5c31\u6d3b\u306b\u304a\u3044\u3066\u3082\u3001Excel\u95a2\u6570\u306e\u57fa\u672c\u3060\u3051\u3067\u3082\u5b66\u3093\u3067\u304a\u304f\u3053\u3068\u306f\u3001\u5f79\u7acb\u3064\u53ef\u80fd\u6027\u304c\u3042\u308b\u3067\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u306f\u3058\u3081\u306b Excel\u306e\u95a2\u6570\u3068\u306f\u3001\u7279\u5b9a\u51e6\u7406\u3092\u884c\u3046\u305f\u3081\u306b\u7528\u610f\u3055\u308c\u305f\u6570\u5f0f\u30fb\u547d\u4ee4\u6587\u306e\u3053\u3068 \u5165\u529b\u53ef\u80fd\u306a\u5024\u306f\u3001\u6570\u5024\u3084\u6587\u5b57\u5217\u3001\u30bb\u30eb\u3084\u30bb\u30eb\u7bc4\u56f2\u306a\u3069\u3055\u307e\u3056\u307e \u5165\u529b\u3067\u304d\u308b\u5185\u5bb9\u3084\u500b\u6570\u306a\u3069\u306e\u6761\u4ef6\u306f\u3001\u95a2\u6570\u3054\u3068\u306b\u6c7a\u3081\u3089\u308c\u3066\u3044\u308b \u95a2\u6570\u306e\u5165\u529b\u65b9\u6cd5\u306f3\u30d1 [&hellip;]<\/p>\n","protected":false},"author":24,"featured_media":24095,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[71,72],"acf":[],"_links":{"self":[{"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/posts\/24093"}],"collection":[{"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/comments?post=24093"}],"version-history":[{"count":318,"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/posts\/24093\/revisions"}],"predecessor-version":[{"id":25044,"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/posts\/24093\/revisions\/25044"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/media\/24095"}],"wp:attachment":[{"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/media?parent=24093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/categories?post=24093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.seraku.co.jp\/tectec-note\/wp-json\/wp\/v2\/tags?post=24093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}