那些算大于B的？如果是CDEF=SUMPRODUCT(--(ASC(A1:A7)>ASC("B")))
将 A,B,C,D,E,A,F 输入 A1单元格B1输入公式 =SUMPRODUCT((CODE(MID(SUBSTITUTE(A1,",",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1,",","")))),1))>CODE("B"))*1)
