단짠단짠털뭉치 = LET(
CG6, SUM(IFERROR(AGGREGATE(14,6, PTS_NUM/mCG, k_6),0)),
CG5, SUM(IFERROR(AGGREGATE(14,6, PTS_NUM/mCG, k_5),0)),
CG4, SUM(IFERROR(AGGREGATE(14,6, PTS_NUM/mCG, k_4),0)),
CC1, IFERROR(AGGREGATE(14,6, PTS_NUM/mCC, 1),0),
CC2, SUM(IFERROR(AGGREGATE(14,6, PTS_NUM/mCC, k_2),0)),
EG1, IFERROR(AGGREGATE(14,6, PTS_NUM/mEG, 1),0),
EG2, SUM(IFERROR(AGGREGATE(14,6, PTS_NUM/mEG, k_2),0)),
EC1, IFERROR(AGGREGATE(14,6, PTS_NUM/mEC, 1),0),
EC2, SUM(IFERROR(AGGREGATE(14,6, PTS_NUM/mEC, k_2),0)),
nCG, SUMPRODUCT(mCG),
nCC, SUMPRODUCT(mCC),
nEG, SUMPRODUCT(mEG),
nEC, SUMPRODUCT(mEC),
C00, IF( (nCG>=6)*(nEG>=2), CG6+EG2, -1E9),
C10, IF( (nCC>=1)*(nCG>=5)*(nEG>=2), (CC1+CG5)+EG2, -1E9),
C01, IF( (nEC>=1)*(nCG>=6)*(nEG>=1), CG6+(EC1+EG1), -1E9),
C20, IF( (nCC>=2)*(nCG>=4)*(nEG>=2), (CC2+CG4)+EG2, -1E9),
C11, IF( (nCC>=1)*(nCG>=5)*(nEC>=1)*(nEG>=1), (CC1+CG5)+(EC1+EG1), -1E9),
C02, IF( (nEC>=2)*(nCG>=6), CG6+EC2, -1E9),
MAX(C00,C10,C01,C20,C11,C02))
이런 기다란 식을 만들고 있습니다...
그런데 자꾸 이렇게 변수가 많아지면.......
이런 팝업창 오류가 뜨더라구요 ㅠㅠㅠ
혹시 해결하는 방법 없을까요...?
CG6, CG5, ...
위와 같이 인수명에 숫자가 포함된 오류
아..... 그것도 모르고 변수가 많아서 터진 줄 알았어요 ㅠㅠㅠㅠ 엉엉..... 감사합니다 ㅠㅠㅠ