<![CDATA[
<DIV>
<P>========================================================================================</P>
<P>현재 사용하는 엑셀 버젼을 기재하시면 좀더 <SPAN style="FONT-SIZE: 11pt"><STRONG><FONT color=#112a75>정확하고 신속한 답변</FONT></STRONG></SPAN>을 얻으실 수 있습니다. </P>
<P> </P>
<P><STRONG><SPAN style="FONT-SIZE: 11pt">엑셀 버젼(<FONT color=#e31600>예: 2013</FONT>) : </SPAN></STRONG></P>
<P><STRONG><SPAN style="FONT-SIZE: 11pt"></SPAN></STRONG>========================================================================================</P>
<P> </P>
<P><a href='javascript:fileFilterViewer("http://cfile260.uf.daum.net/attach/227C5C3B53C35E252E9E2C", "/cfile260/22/7C5C3B53C35E252E9E2C", "2013 ★★좌대입출고관리양식- Final.xlsx", "grpid%3D1GIVp%26fldid%3DK4Nh%26dataid%3D1812%26fileid%3D1%26regdt%3D20140714133740&url=http%3A%2F%2Fcfile260.uf.daum.net%2Fattach%2F227C5C3B53C35E252E9E2C")'><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_xls_s.gif" border="0" alt="첨부파일" class="vam"/> 2013 ★★좌대입출고관리양식- Final.xlsx</a></P>
<P>
<TABLE style="WIDTH: 690pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=917>
<COLGROUP>
<COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2080" span=6 width=65>
<COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2176" width=68>
<COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2080" span=5 width=65>
<COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1632" width=51>
<COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2656" width=83>
<TBODY>
<TR style="HEIGHT: 16.5pt" height=22>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; HEIGHT: 16.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78 height=22 width=65><FONT color=#000000 size=3 face="맑은 고딕"><STRONG> </STRONG></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">0.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">6260.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">1108.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">0.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">-6.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 51pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=68><STRONG><FONT color=#000000 face="맑은 고딕">43.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">0.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">0.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">0.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">-12.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=65><STRONG><FONT color=#000000 face="맑은 고딕">37.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 38pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 width=51><STRONG><FONT color=#000000 face="맑은 고딕">0.0</FONT></STRONG></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f79646; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl80 width=83><STRONG><FONT color=#000000 face="맑은 고딕">17326.0</FONT></STRONG></TD></TR>
<TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f79646; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl81 height=19><FONT color=#000000 size=3 face="맑은 고딕"> </FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f79646; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl83><FONT color=#000000 size=3 face="맑은 고딕">0.0</FONT></TD></TR></TBODY></TABLE></P></DIV>
<P> </P>
<P> </P>
<P>안녕하세요 아래 sum 부분이 0으로 나타나고 합계가 안나와서요 </P>
<P>수식 계산옵션 부분도 자동으로 변경되었는데도 동일한 현상이라</P>
<P>부탁드릴께요 </P>
<!-- -->
]]>
첫댓글 안녕하세요? [미서도현맘]님...
여쭤보신 자료는 순환참조 때문에 오류가 생긴상태입니다.
한두개 셀이 순환참조라면 수정해 드리겠는데 상당히 많은 셀이 오류가 있군요.
e62, k51, f51, h66, l53, n62,h 58, l63, d58 등등 이외에도 많은 셀이 있는데 해당셀의 수식을 다시 수정해 주셔야 합니다.
F9 키를 누르고 시트 좌측하단의 상태표시줄 부분을 보시면 순환참조가 생기는 셀 어드레스를 볼 수 있습니다.
그럼 잘 해결되시길... ^^*