累計 同月取最大 (12911)

C2{=MAX((TEXT(A$2:A$21,"EM")=TEXT(A2,"EM"))*B$2:B$21)+MAX(N(+C$1:C1)*(TEXT(A$2:A2,"EM")<>TEXT(A2,"EM")))



留言