eOffice (구글독스/한컴독스/한글/엑셀/컴활/사무자동화

엑셀 초짜입니다. SUMIF 좀 봐주세요 ㅠㅠ <table width="600" style="width: 451pt; border-collapse: collapse;" border="0" cellspacing="0" cellpadding="0"> <colgroup><col width="60" style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;"> <col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;"> <col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;"> <col width="17" style="width: 13pt; mso-width-source: userset; mso-width-alt: 621;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="64" style="width: 48pt;" span="4"> <tbody><tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border: 0px windowtext; width: 45pt; height: 12.75pt; background-color: transparent;"></td> <td width="86" style="border: 0px windowtext; width: 65pt; background-color: transparent;"></td> <td width="99" style="border: 0px windowtext; width: 74pt; background-color: transparent;"></td> <td width="17" style="border: 0px windowtext; width: 13pt; background-color: transparent;"></td> <td width="82" style="border: 0px windowtext; width: 62pt; background-color: transparent;"></td> <td width="64" style="border: 0px windowtext; width: 48pt; background-color: transparent;"></td> <td width="64" style="border: 0px windowtext; width: 48pt; background-color: transparent;"></td> <td width="64" style="border: 0px windowtext; width: 48pt; background-color: transparent;"></td> <td width="64" style="border: 0px windowtext; width: 48pt; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;">C</td> <td style="border: 0px windowtext; background-color: transparent;">D</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border: 0.5pt solid black; width: 45pt; height: 12.75pt; background-color: transparent;">3</td> <td width="86" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black black black rgb(51, 51, 51); width: 65pt; background-color: transparent;">휴맥스홀딩스</td> <td width="99" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black black black rgb(51, 51, 51); width: 74pt; background-color: transparent;">5,680</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: rgb(51, 51, 51) black black; width: 45pt; height: 12.75pt; background-color: transparent;">4</td> <td width="86" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 65pt; background-color: transparent;">휴메딕스</td> <td width="99" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 74pt; background-color: transparent;">29,000</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td width="82" style="border: 0.5pt solid windowtext; width: 62pt; background-color: transparent;">J</td> <td width="64" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext rgb(51, 51, 51); width: 48pt; background-color: transparent;">K</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: rgb(51, 51, 51) black black; width: 45pt; height: 12.75pt; background-color: transparent;">5</td> <td width="86" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 65pt; background-color: transparent;">휴비스</td> <td width="99" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 74pt; background-color: transparent;">7,520</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: transparent;">흥국</td> <td align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: yellow;">0</td> <td style="border: 0px windowtext; background-color: transparent; mso-ignore: colspan;" colspan="3">수식 : =SUMIF($C:$C,$J5,D:D)</td> </tr> <tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: rgb(51, 51, 51) black black; width: 45pt; height: 12.75pt; background-color: transparent;">6</td> <td width="86" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 65pt; background-color: transparent;">휴스틸</td> <td width="99" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 74pt; background-color: transparent;">15,600</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: transparent;">휴맥스홀딩스</td> <td align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: yellow;">0</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: rgb(51, 51, 51) black black; width: 45pt; height: 12.75pt; background-color: transparent;">7</td> <td width="86" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 65pt; background-color: transparent;">휴온스글로벌</td> <td width="99" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 74pt; background-color: transparent;">35,850</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: transparent;">　</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">　</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: rgb(51, 51, 51) black black; width: 45pt; height: 12.75pt; background-color: transparent;">8</td> <td width="86" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 65pt; background-color: transparent;">휴켐스</td> <td width="99" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 74pt; background-color: transparent;">25,000</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: rgb(51, 51, 51) black black; width: 45pt; height: 12.75pt; background-color: transparent;">9</td> <td width="86" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 65pt; background-color: transparent;">흥구석유</td> <td width="99" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 74pt; background-color: transparent;">2,985</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: rgb(51, 51, 51) black black; width: 45pt; height: 12.75pt; background-color: transparent;">10</td> <td width="86" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 65pt; background-color: transparent;">흥국</td> <td width="99" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 74pt; background-color: transparent;">9,560</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td width="60" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: rgb(51, 51, 51) black black; width: 45pt; height: 12.75pt; background-color: transparent;">11</td> <td width="86" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 65pt; background-color: transparent;">희림</td> <td width="99" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: rgb(51, 51, 51) black black rgb(51, 51, 51); width: 74pt; background-color: transparent;">5,070</td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> <tr height="17" style="height: 12.75pt;"> <td height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> <td style="border: 0px windowtext; background-color: transparent;"></td> </tr> </tbody></table>노란 음영색에서 수식을 넣어 흥국은 9,560,  휴맥스홀딩스는 5,680원이 나오게 하고 싶은데요흥국은 우측과 같이 수식을 넣었는데  값이 0 이 나오네요어디가 잘못되었을까요? 파일을 추가로 첨부합니다.답변 부탁드립니다. 고수님들<a href='javascript:fileFilterViewer("http://cfile261.uf.daum.net/attach/25D23533596613C10BB574", "/cfile261/25/D23533596613C10BB574", "SUMIF.xls", "grpid%3D68qa%26fldid%3D7GMk%26dataid%3D12256%26fileid%3D1%26regdt%3D20170712211957&url=http%3A%2F%2Fcfile261.uf.daum.net%2Fattach%2F25D23533596613C10BB574")'><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_etc_s.gif" border="0" alt="첨부파일" class="vam"/> SUMIF.xls</a>

카페정보

카페 전체 메뉴

▲

친구 카페

이전 다음

ㆍ 정보처리mini0A0
ㆍ 엑셀 동영상mini0A0

카페 게시글

?.............[MS] 엑셀 SUMIF 좀 봐주세요

mensou 추천 0 조회 128 17.07.12 21:19 댓글 3

게시글 본문내용

다음검색

첨부된 파일 개 ▼

저작자 표시 컨텐츠변경 비영리

엑셀 지존
17.07.21 19:30

첫댓글 안녕하세요.. 많이 답답하셨을것 같습니다. "D"란의 숫자를 입력하실때 ","(콤마)를 입력하셔서 그런것 같습니다.예)5,680(X) 5680(O) *.숫자만 입력하신 후에 위의 메뉴에서 표시형식의 ","를 클릭하시면 됩니다.
mensou
작성자 17.07.29 09:46

지금 보니 D열을 제가 입력한게 아니고 인터넷에서 다운받을것으로 했어요
"' ' " 가 따로 입력되어 있네요.. ㅠㅠ

답변 감사드립니다.
조금씩 조금씩 엑셀을 배워 보고자 합니다. ㅠㅠ
호두리
18.01.22 21:16

잘 배웠습니다. 감사합니다.