一直被發洗澡卡覺得煩 <.< 又不是要追妳,講公事也急著秒發,是覺得全世界都對妳有意思嗎,小公主?
=IF(ISNA(VLOOKUP(M6,{"年",-1;"年半",-0.5;"A",1;"P",1},2,FALSE)),0,VLOOKUP(M6,{"年",-1;"年半",-0.5;"A",1;"P",1},2,FALSE))
=COUNTIF(O46: P46, ">0") + COUNTIF(V46:W46, ">0") + COUNTIF(AC46:AD46, ">0") + COUNTIF(AJ46:AK46, ">0") + COUNTIF(AQ46:AR46, ">0")