我昨天本想请大神帮忙简化的，但大神提出不如直接截图

=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)

自己顶个

有心锻炼下自己。。但你这老多图，真心看不进去啊。帮顶下吧。

再顶

如果不是太急，最近两三天有点忙，要不加我试试，1181963929

如来神顶

图太多，公式太长，还没看，已吓尿

跪求大神

再顶个

把你的条件说出来，公式没必要这么长，大道至简。效果一样，公式越短才能显出水平呢！