<p style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);color:rgb(11, 11, 11);font-style:normal;font-weight:400;text-align:start;background-color:rgb(255, 255, 255)">학생 소지품·복장 점검표를 구글 시트로 만들 때, <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">체크박스를 누르면 그 칸에 체크한 날짜가 자동으로 기록</strong>되게 하는 방법입니다. 칸마다 날짜가 따로 남고, 나중에 고칠 수도 있습니다. 학생별 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">합계</strong>도 저절로 계산됩니다.</p><hr style="border:0px;color:inherit;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-style:normal;font-weight:400;text-align:start;background-color:rgb(255, 255, 255)"><h2 style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:500;color:rgb(11, 11, 11);font-style:normal;text-align:start;background-color:rgb(255, 255, 255)">🎯 이렇게 됩니다</h2><table style="border-collapse:collapse;border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);border-spacing:0px;border-radius:0px;text-align:start;font-style:inherit;font-weight:inherit"><thead><tr><th style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:bottom;text-align:start;font-weight:600;background:linear-gradient(color(srgb 0.0431373 0.0431373 0.0431373 / 0.05), color(srgb 0.0431373 0.0431373 0.0431373 / 0.05)) 0% 0% / repeat scroll padding-box border-box rgb(255, 255, 255);border-start-start-radius:5px;border-block-end:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">하는 일</th><th style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:bottom;text-align:start;font-weight:600;background:linear-gradient(color(srgb 0.0431373 0.0431373 0.0431373 / 0.05), color(srgb 0.0431373 0.0431373 0.0431373 / 0.05)) 0% 0% / repeat scroll padding-box border-box rgb(255, 255, 255);border-start-end-radius:5px;border-block-end:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">결과</th></tr></thead><tbody><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top">👆 체크박스 체크</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top">그 칸 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">메모</strong>에 오늘 날짜(예: 10/23)가 들어감 · 합계 +1</td></tr><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">📝 날짜 고치기</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">칸 오른쪽 클릭 → <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">메모 수정</strong> (체크가 유지되는 동안 덮어쓰지 않음)</td></tr><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">🔄 체크 해제</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">그 칸 메모가 지워짐 · 합계 −1</td></tr><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">📦 여러 칸 한꺼번에</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">범위를 선택하고 스페이스바 → 칸마다 날짜가 들어감</td></tr></tbody></table><p style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">💡 날짜가 들어간 칸은 오른쪽 위에 작은 삼각형이 생기고, 마우스를 올리면 날짜가 보입니다.</p><p style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">🤔 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">왜 수식(=TODAY())으로 안 하나요?</strong> TODAY() 는 시트를 열 때마다 오늘 날짜로 바뀝니다. 스크립트는 날짜를 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">값</strong>으로 적어 두기 때문에 다음 날에도, 한 달 뒤에도 그대로 남습니다.</p><p style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">🚀 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">사용법은 간단합니다.</strong> 맨 아래 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">견본 시트 링크</strong>를 열고 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">파일 → 사본 만들기</strong> 를 하면 됩니다. 스크립트와 합계 수식까지 함께 복사되므로 아래 「설정하기」 없이 바로 쓸 수 있습니다.</p><hr style="border:0px;color:inherit;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-style:normal;font-weight:400;text-align:start;background-color:rgb(255, 255, 255)"><h2 style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:500;color:rgb(11, 11, 11);font-style:normal;text-align:start;background-color:rgb(255, 255, 255)">🧩 시트 모양</h2><table style="border-collapse:collapse;border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);border-spacing:0px;border-radius:0px;text-align:start;font-style:inherit;font-weight:inherit"><thead><tr><th style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:bottom;text-align:start;font-weight:600;background:linear-gradient(color(srgb 0.0431373 0.0431373 0.0431373 / 0.05), color(srgb 0.0431373 0.0431373 0.0431373 / 0.05)) 0% 0% / repeat scroll padding-box border-box rgb(255, 255, 255);border-start-start-radius:5px;border-block-end:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">행</th><th style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:bottom;text-align:start;font-weight:600;background:linear-gradient(color(srgb 0.0431373 0.0431373 0.0431373 / 0.05), color(srgb 0.0431373 0.0431373 0.0431373 / 0.05)) 0% 0% / repeat scroll padding-box border-box rgb(255, 255, 255);border-start-end-radius:5px;border-block-end:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">내용</th></tr></thead><tbody><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top">1행</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top">오늘날짜 · 항목 이름(핸드폰 · 태블릿 · 교복 · 실내화 · 스마트워치 · 음식물)</td></tr><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">2행</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">머리글 — 반 · 번호 · <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">성 명</strong> · 1~21 · <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">합계</strong></td></tr><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">3행부터</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">학생 한 줄씩 · F~Z열 체크박스 · AA열 합계</td></tr></tbody></table><p style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">🔑 스크립트는 2행의 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">「성 명」</strong> 칸과 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">「합계」</strong> 칸을 찾아서, 그 사이 열을 체크박스 범위로 씁니다. 그래서 학생(행)이나 항목(열)을 늘려도 코드를 고칠 필요가 없습니다.</p><hr style="border:0px;color:inherit;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-style:normal;font-weight:400;text-align:start;background-color:rgb(255, 255, 255)"><h2 style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:500;color:rgb(11, 11, 11);font-style:normal;text-align:start;background-color:rgb(255, 255, 255)">🔧 설정하기 (5분)</h2><h3 style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600;color:rgb(11, 11, 11);font-style:normal;text-align:start;background-color:rgb(255, 255, 255)">🥇 1단계 — 스크립트 넣기</h3><ol style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);color:rgb(11, 11, 11);font-style:normal;font-weight:400;text-align:start;background-color:rgb(255, 255, 255)"><li style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">구글 시트 메뉴 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">확장 프로그램 → Apps Script</strong> 를 엽니다.</li><li style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">들어 있는 내용을 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">모두 지우고</strong> 아래 코드를 붙여 넣습니다.</li><li style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">💾 <strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">저장</strong> 을 누릅니다. 끝! (따로 승인·트리거 설정이 필요 없습니다)</li></ol><span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)">// ── 설정 ──────────────────────────────────────────────</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)">const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> NAME_HEAD </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(30, 158, 60);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(30, 158, 60)"> '성 명'</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span><span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)"> // 체크박스 바로 왼쪽 머리글</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)">const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> TOTAL_HEAD </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(30, 158, 60);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(30, 158, 60)"> '합계'</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span><span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)"> // 체크박스 바로 오른쪽 머리글</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)">const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> DATE_FMT </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(30, 158, 60);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(30, 158, 60)"> 'M/d'</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span><span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)"> // 날짜 모양</span>
<span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)">// ── 체크하면 메모에 날짜 기록 ─────────────────────────</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)">function</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)"> onEdit</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">e</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">)</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> {</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> r </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> e</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">range</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> sh </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> r</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getSheet</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">();</span>
<span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)"> // 머리글(성 명) 찾기 — 위쪽 10줄 안에서</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> top </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> sh</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getRange</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)">1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> 1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> Math</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">min</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)">10</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> sh</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getMaxRows</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">()),</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> sh</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getMaxColumns</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">());</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> name </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> top</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">createTextFinder</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">NAME_HEAD</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">).</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">matchEntireCell</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)">true</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">).</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">findNext</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">();</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> if</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> (</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">!</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">name</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">)</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> return</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span><span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)"> // 이 양식이 아닌 시트</span><span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)"> // 같은 줄에서 합계 찾기</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> headRow </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> sh</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getRange</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">name</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getRow</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(),</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> 1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> 1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> sh</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getMaxColumns</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">());</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> total </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> headRow</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">createTextFinder</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">TOTAL_HEAD</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">).</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">matchEntireCell</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)">true</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">).</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">findNext</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">();</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> if</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> (</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">!</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">total</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">)</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> return</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span>
<span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> firstRow </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> name</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getRow</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">()</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> +</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> 1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> firstCol </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> name</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getColumn</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">()</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> +</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> 1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> lastCol </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> total</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getColumn</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">()</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> -</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> 1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span>
<span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> r1 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> Math</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">max</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">r</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getRow</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(),</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> firstRow</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">),</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> r2 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> r</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getLastRow</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">();</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> c1 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> Math</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">max</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">r</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getColumn</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(),</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> firstCol</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">),</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> c2 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> Math</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">min</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">r</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getLastColumn</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(),</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> lastCol</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">);</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> if</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> (</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">r1 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">></span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> r2 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">||</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> c1 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">></span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> c2</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">)</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> return</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span><span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)"> // 체크박스 영역 밖이면 무시</span>
<span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> area </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> sh</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getRange</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">r1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> c1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> r2 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">-</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> r1 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">+</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> 1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> c2 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">-</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> c1 </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">+</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> 1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">);</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> vals </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> area</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getValues</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(),</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> notes </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> area</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getNotes</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">();</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> const</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> today </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">=</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> Utilities</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">formatDate</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)">new</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)"> Date</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(),</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> e</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">source</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getSpreadsheetTimeZone</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(),</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> DATE_FMT</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">);</span>
<span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> area</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">setNotes</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">(</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">vals</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">map</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">((</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">row</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> i</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">)</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> =></span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> row</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">map</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">((</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">v</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">,</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> j</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">)</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> =></span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> {</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> if</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> (</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">v </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">!==</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> 1</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> &&</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> v </span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">!==</span><span style="color:rgb(205, 32, 84);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(205, 32, 84)"> true</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">)</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> return</span><span style="color:rgb(30, 158, 60);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(30, 158, 60)"> ''</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span><span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)"> // 해제 → 메모 지움</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> return</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> notes</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">[</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">i</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">][</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">j</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">]</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> ||</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> today</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">;</span><span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)"> // 새로 체크 → 오늘, 이미 있으면 그대로</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> })));</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">}</span>
<span style="color:rgb(153, 153, 153);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(153, 153, 153)">// ── =MY_SHEET_NAME() : 시트 이름 표시 ─────────────────</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)">function</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)"> MY_SHEET_NAME</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">()</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)"> {</span><span style="color:rgb(197, 98, 27);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(197, 98, 27)"> return</span><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)"> SpreadsheetApp</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">.</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getActiveSheet</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">().</span><span style="color:rgb(0, 115, 230);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(0, 115, 230)">getName</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">();</span><span style="color:rgb(115, 115, 115);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(115, 115, 115)">}</span><span style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);color:rgb(137, 135, 129);background:linear-gradient(to right, rgba(0, 0, 0, 0), rgb(255, 255, 255) 12px) 0% 0% / repeat scroll padding-box border-box rgba(0, 0, 0, 0)"></span><h3 style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600;color:rgb(11, 11, 11);font-style:normal;text-align:start;background-color:rgb(255, 255, 255)">🥈 2단계 — 합계 수식 넣기</h3><p style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);color:rgb(11, 11, 11);font-style:normal;font-weight:400;text-align:start;background-color:rgb(255, 255, 255)"><strong style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);font-weight:600">AA3 한 칸에만</strong> 아래 수식을 넣습니다. 아래쪽 학생 줄은 저절로 채워집니다.</p><span style="color:rgb(26, 26, 26);background-color:rgba(0, 0, 0, 0);font-weight:400;font-style:normal;text-decoration:rgb(26, 26, 26)">=ARRAYFORMULA(IF(D3:D="", "", MMULT(--(F3:Z=1), TRANSPOSE(COLUMN(F2:Z2)^0))))</span><table style="border-collapse:collapse;border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);border-spacing:0px;border-radius:0px;text-align:start;font-style:inherit;font-weight:inherit"><thead><tr><th style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:bottom;text-align:start;font-weight:600;background:linear-gradient(color(srgb 0.0431373 0.0431373 0.0431373 / 0.05), color(srgb 0.0431373 0.0431373 0.0431373 / 0.05)) 0% 0% / repeat scroll padding-box border-box rgb(255, 255, 255);border-start-start-radius:5px;border-block-end:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">부분</th><th style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:bottom;text-align:start;font-weight:600;background:linear-gradient(color(srgb 0.0431373 0.0431373 0.0431373 / 0.05), color(srgb 0.0431373 0.0431373 0.0431373 / 0.05)) 0% 0% / repeat scroll padding-box border-box rgb(255, 255, 255);border-start-end-radius:5px;border-block-end:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">하는 일</th></tr></thead><tbody><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top">F3:Z=1</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top">체크된 칸 찾기</td></tr><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">MMULT(…)</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">줄마다 체크된 칸 수 세기</td></tr><tr><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">IF(D3:D="", "", …)</td><td style="border:0px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1);vertical-align:top;border-block-start:1px solid color(srgb 0.0431373 0.0431373 0.0431373 / 0.1)">
콘텐츠를 불러오는 중..
댓글목록
등록된 댓글이 없습니다.