健保費 被追繳 針對工會投保 (11719)

E6{=SUM(FREQUENCY(TEXT(ROUND(MMULT(N(OFFSET(C1,{1;2;3;4}*3-3+{1,2,3},)),{1;1;1}/3),),"[>="&E2&"]0;"&E2)*1,H2:H16)*I2:I17)*3-OFFSET(I1,MATCH(1=1,E2<=H2:H17,),)*12

F6{=SUM(FREQUENCY(TEXT(C2:C13,"[>="&E2&"]0;"&E2)*1,H2:H16)*I2:I17)-OFFSET(I1,MATCH(1=1,E2<=H2:H17,),)*16




留言