求大神帮忙简化下

=ROUND(IFERROR(IF(COUNTIF(C$41:C$85,"实习")+COUNTIF(C$41:C$85,"新工")>=1,IF(OR(C41="实习",C41="新工"),60,IF(C$35=0,IF(C41<1,C41*(C$32-COUNTIF(C$41:C$85,"新工")*60)/(COUNTIF(C$41:C$85,"*")+SUM(C$41:C$85)-COUNTIF(C$41:C$85,"实习")-COUNTIF(C$41:C$85,"新工")),(C$32-COUNTIF(C$41:C$85,"新工")*60)/SUM(COUNTIF(C$41:C$85,"*")+SUM(C$41:C$85)-COUNTIF(C$41:C$85,"实习")-COUNTIF(C$41:C$85,"新工"))),IF(C41<1,C41*(C$35-COUNTIF(C$41:C$50,"新工")*60)/(COUNTIF(C$41:C$50,"*")+SUM(C$41:C$50)-COUNTIF(C$41:C$50,"实习")-COUNTIF(C$41:C$50,"新工")),(C$35-COUNTIF(C$41:C$50,"新工")*60)/(COUNTIF(C$41:C$50,"*")+SUM(C$41:C$50)-COUNTIF(C$41:C$50,"实习")-COUNTIF(C$41:C$50,"新工"))))),IF(C$35=0,IF(C41<1,C41*C$32/(COUNTIF(C$41:C$85,"*")+SUM(C$41:C$85)),C$32/SUM(COUNTIF(C$41:C$85,"*")+SUM(C$41:C$85))),IF(C41<1,C41*C$35/(COUNTIF(C$41:C$50,"*")+SUM(C$41:C$50)),C$35/(COUNTIF(C$41:C$50,"*")+SUM(C$41:C$50))))),0),2)具体用途是算工资的，由于条件太多整出个这个，真心求大神帮忙简化，说明：新工由班组出这六十元，实习由公司出，其中包含打分的，所以会存在小于1的情况，还有就是单个上机和双上机与下面包装工要分开计算，由于不能上传附件，但确实条件太多，无奈