<div style="text-align:left;"><img src="http://thimg.todayhumor.co.kr/upfile/201702/148660011278aac34176174ce09aec27e7ed1698ca__mn500352__w1350__h478__f62553__Ym201702.png" width="800" height="283" alt="exce;.png" class="chimg_photo" style="border:none;" filesize="62553"></div><br><div>그리 거창한 그런 엑셀은 아닙니다만</div> <div>사용용도는 던파 길드레이드 멤버 기록용입니다 </div> <div><br></div> <div>저기 보시면 Function 이 F1:F37 까지만되있긴한데 제가 원하는건 F:F 거든요 근데 F38 때문에 F:F 가안되요. </div> <div>찿는값은 "NG" 라는 단어가있을경우 카운트되는거고요 다른곳을 찿아봐도 전부 =sum() -sum() 을 이용해서 특정셀 제외하는방법이더라고여 </div> <div>그래서 따라해봤는데 안되고요</div> <div><br></div> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">=</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">counta</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">(</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">arrayformula</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">(</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">iferror</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">(</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">search</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">(</span><span class="string" style="color:#008000;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">"NG"</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">,</span><span style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;color:#f7981d;">F1:F37</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">)</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">)</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">)</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">)</span></div> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"><br></span></div> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">이걸 어떻게 변형해야 F:F 중에서 NG 라는 단어가 있으면 카운트가 올라가게 만들수있을까요</span></div> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;"><br></span></div> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">다른 속성들은 F 안에없기에 괜찮았는데 자꾸 종류를 늘리다보니...</span></div> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;white-space:pre-wrap;">이미 2시간가량 이녀석이랑 씨름했는데 답이안나와요 ㅠㅠ</span></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.