<![CDATA[
<P>제가 오늘 실기시험을 봤는데요 DAVERAGE 함수를 구할때 예를들면 주소가 종로인사람의 구매실적 평균을 구한다치면</P>
<P>DAVERAGE(B1:D9,2,B1:B2) 이렇게해도 되는건가요?아니면 DAVERAGE( A1:D9,3,B1:B2) 이랗게 해야만 하나요?ㅠ.ㅠ</P>
<P> a b c d</P>
<P>
<TABLE style="WIDTH: 284pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=379 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 60pt" span=2 width=80>
<COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 2616" width=92>
<COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 3612" width=127>
<TBODY>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 60pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=80 height=18><FONT face=돋움 color=#000000 size=3>고객이름</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 60pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=80><FONT face=돋움 color=#000000 size=3>주소</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 69pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=92><FONT face=돋움 color=#000000 size=3>구매실적</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 95pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=127><FONT face=돋움 color=#000000 size=3>실적포인트</FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face=돋움 color=#000000 size=3>홍길동</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face=돋움 color=#000000 size=3>종로</FONT></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="700000"><FONT face=돋움 color=#000000 size=3>700,000 </FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="700"><FONT size=3><FONT color=#000000><FONT face=돋움><SPAN style="mso-spacerun: yes"> </SPAN>700 </FONT></FONT></FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face=돋움 color=#000000 size=3>박찬훈</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face=돋움 color=#000000 size=3>서초</FONT></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="1600000"><FONT face=돋움 color=#000000 size=3>1,600,000 </FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="3200"><FONT size=3><FONT color=#000000><FONT face=돋움><SPAN style="mso-spacerun: yes"> </SPAN>3,200 </FONT></FONT></FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face=돋움 color=#000000 size=3>김덕진</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face=돋움 color=#000000 size=3>강남</FONT></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="600000"><FONT face=돋움 color=#000000 size=3>600,000 </FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="600"><FONT size=3><FONT color=#000000><FONT face=돋움><SPAN style="mso-spacerun: yes"> </SPAN>600 </FONT></FONT></FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face=돋움 color=#000000 size=3>이소라</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face=돋움 color=#000000 size=3>강남</FONT></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="2200000"><FONT face=돋움 color=#000000 size=3>2,200,000 </FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4400"><FONT size=3><FONT color=#000000><FONT face=돋움><SPAN style="mso-spacerun: yes"> </SPAN>4,400 </FONT></FONT></FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face=돋움 color=#000000 size=3>김종택</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face=돋움 color=#000000 size=3>서초</FONT></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="500000"><FONT face=돋움 color=#000000 size=3>500,000 </FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="500"><FONT size=3><FONT color=#000000><FONT face=돋움><SPAN style="mso-spacerun: yes"> </SPAN>500 </FONT></FONT></FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face=돋움 color=#000000 size=3>정영일</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face=돋움 color=#000000 size=3>서초</FONT></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="2800000"><FONT face=돋움 color=#000000 size=3>2,800,000 </FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="8400"><FONT size=3><FONT color=#000000><FONT face=돋움><SPAN style="mso-spacerun: yes"> </SPAN>8,400 </FONT></FONT></FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face=돋움 color=#000000 size=3>최수형</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face=돋움 color=#000000 size=3>종로</FONT></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="300000"><FONT face=돋움 color=#000000 size=3>300,000 </FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="0"><FONT size=3><FONT color=#000000><FONT face=돋움><SPAN style="mso-spacerun: yes"> </SPAN>- </FONT></FONT></FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face=돋움 color=#000000 size=3>한우규</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face=돋움 color=#000000 size=3>서초</FONT></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="3200000"><FONT face=돋움 color=#000000 size=3>3,200,000 </FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="9600"><FONT size=3><FONT color=#000000><FONT face=돋움><SPAN style="mso-spacerun: yes"> </SPAN>9,600 </FONT></FONT></FONT></TD></TR></TBODY></TABLE></P>
<!-- -->
]]>
첫댓글 앞에 d가 붙는 함수는 데이터베이스 함수입니다..daverage(전체 범위, 열번호, 옵션)입니다..그러므로 전자의 경우는 무조건 틀린 답입니다..후자의 경우가 맞는 답이라 하겠습니다..
전자도 맞는 답인것 같은데요...daverage(셀범위, 열번호(필드명), 조건범위)인걸로 알고있는데요..근데 대부분 시험문제는 조건범위가 A열에 나오는 경우가 많으니까 전체범위를 잡구요..그냥 전체범위를 잡는게 더 쉽고 편하니까 그렇게 하는것 같아요..
아..그렇군요 실기준비해야 되는데 도움얻고 갑니다.^^
그럼 맞을수도 있는건가요~~~?ㅜㅜ