엑셀 서식 오류가 나는데 도대체 왜 나는지 모르겠어요ㅠㅠㅠㅠㅠㅠ7

네ㅜㅜ 다른곳은 오류안나는데 저마케팅파트만 오류나네요..ㅠㅠㅠ

범위가 마케팅파트는 GM 열까지인데, 다른 파트의 것이랑 똑같이 CU열까지 설정이 되어서 18일까지 나오는 것 같습니다.
메모장에서 안에 내용 가지고 와서 CU -> GM 바꿔주기 하면 값이 다 나올 것 같습니다.
그냥 슬쩍 봤을 때는 이건거 같아서..그만..ㅌㅌ

아 그뜻이였군요ㅎㅎ 정말 감사합니다!



=IF(WEEKDAY($K$3)=2,VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-2)+7,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-2)+13,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-2)+19,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-2)+25,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-2)+31,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-2)+37,FALSE),IF(WEEKDAY($K$3)=3,VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+7,FALSE),IF(WEEKDAY($K$3)=4,VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+7,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+13,FALSE),IF(WEEKDAY($K$3)=5,VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+7,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+13,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+19,FALSE),IF(WEEKDAY($K$3)=6,VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+7,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+13,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+19,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+25,FALSE),IF(WEEKDAY($K$3)=7,VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+7,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+13,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+19,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+25,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+31,FALSE),VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+7,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+13,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+19,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+25,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+31,FALSE)+VLOOKUP(B34,마케팅파트_실적!$C$4:$GM$13,42*($L$3-1)+37,FALSE)))))))
2013-07-19
20:18:42

감사감사합니다!!ㅎㅎ