Sub test3()
Range("F30:M37").FormulaR1C1 = _
"=IFERROR(IF(R19C3=TRUE,IF(R8C13=""ALL"",COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R20C50),""<=""&R10C67)/RC4,(COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),R8C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),R10C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50" & _
"DIRECT(R18C50),R29C,INDIRECT(R14C50),R12C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),R14C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),R16C13,INDIRECT(R20C50),""<=""&R10C67))/RC4),IF(R17C3=TRUE,IF(R8C13=""ALL"",COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(" & _
"29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(R20C50),""<=""&R10C67)/RC4,(COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(R14C50),R8C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT" & _
"""<>[SERVC]*"",INDIRECT(R14C50),R10C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(R14C50),R12C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(" & _
"14C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(R14C50),R16C13))/RC4),IF(R15C3=TRUE,(COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R52" & _
"CT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R53C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R54C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R55C2,INDIRECT(R20C50)," & _
"0C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R56C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R57C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R58C2,INDIRECT(R20C50),""<=""&R10C67)-COUNT" & _
"ECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R59C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R60C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R61C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50)" & _
"RECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R62C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R63C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R64C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50" & _
"DIRECT(R14C50),Assumptions!R65C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R66C2,INDIRECT(R20C50),""<=""&R10C67))/RC4))),0)"
End Sub
Any help much appreciated.
Bookmarks